MS Access 2003
Is there a way to programmatically change MS Access menu options from within an access program?
For example, my access app has a macro that moves records from an active table to an archive table, by means of appending records to the archive table and then deleting the same records from the active table.
This append/delete action opens up a MS Access dialog box to confirm the action (which i know how to turn off via the Tools/Options - Edit/Find Tab menu).
When operating the program, I know that I want to perform this action, but another less experienced user might not read or understand the warnings, and answer the dialog questions incorrectly, thus cancelling the append and/or delete action.
I'd also like to make my access app turn off the various toolbars, and status bar, in order to have the most available onscreen space for my forms (which take up most of a maximized access session on a 1024x768 screen).
I have MY workstation set up the way I need it to be for using the app, but don't want to have to do the same manual setup on each end users pc.
btw, I included a readme_1st.txt text file with the app, when i made it available to my coworkers on the network, indicating the MS Access menu options to set BEFORE using the app. Not a single one of them can read and follow simple instructions, and i recieved no less than 7 panicked phone calls when the dialog box popped up. Not fun![[sad]](/data/assets/smilies/sad.gif "[sad] [sad]")
.
"help me, Obi Wan Kenobi......
You're my only hope."
Is there a way to programmatically change MS Access menu options from within an access program?
For example, my access app has a macro that moves records from an active table to an archive table, by means of appending records to the archive table and then deleting the same records from the active table.
This append/delete action opens up a MS Access dialog box to confirm the action (which i know how to turn off via the Tools/Options - Edit/Find Tab menu).
When operating the program, I know that I want to perform this action, but another less experienced user might not read or understand the warnings, and answer the dialog questions incorrectly, thus cancelling the append and/or delete action.
I'd also like to make my access app turn off the various toolbars, and status bar, in order to have the most available onscreen space for my forms (which take up most of a maximized access session on a 1024x768 screen).
I have MY workstation set up the way I need it to be for using the app, but don't want to have to do the same manual setup on each end users pc.
btw, I included a readme_1st.txt text file with the app, when i made it available to my coworkers on the network, indicating the MS Access menu options to set BEFORE using the app. Not a single one of them can read and follow simple instructions, and i recieved no less than 7 panicked phone calls when the dialog box popped up. Not fun
."help me, Obi Wan Kenobi......
You're my only hope."
