Hey all,
Access scripting question here.
But first a little background:
We have a rather robust Access DB now that multiple users logged into it at the same time. To help control who see's different tabs and who can click on different buttons and what not, we have an Access Control module setup. It lists out different roles and what those roles have access to all the way down to individual buttons. I wrote up a cool excel file that helps me adjust those rules graphically. When im happy with the rules, i hit a button and those rules are exported out to a TXT file ready to be copied to the Access module. Currently, the module has 11,044 lines of code in it.
On to my question:
I am having the hardest time finding examples of this. Basically i'm looking for a Access script that once executed it will open a browse window allowing me to browse and select a TXT file. It will then copy the contents of that target file to the windows clipboard.
My thoughts then would be to manually open the module, select all text, delete it, paste the copied contents into the module, and then save the file. If this part could be done using VBA that would be wonderful but im not aware VBA being able to edit the contents of a module.
Bookmarks