By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Menu Bar Startup Options via VBA

P: n/a
Hello.

Re: Access 2002-SP3
I have some options turned off under "Tools/Startup" area on my
workstation. When I deploy my app to 5 users (who will all have a full
blown version of Access 2002 on their PC's) I would like to disable
some startup options programatically at runtime via VBA.

I am looking for VBA code to turn off these options at application
startup and turn them back on for the user when they shutdown my app:

"Allow Full Menus"
"Allow default Shortcut Menus"
"Allow Built-in Toolbars"
"Allow Toolbar/Menu Changes"
"Use Access Special Key"

Also, without changing the menu bars, is there a way via VBA to disable
only the databasewindow icon (the one that pops the DBWindow container)
at startup, (leaving all other toolbar icons alone) then enable the
databasewindow icon back when my app shuts down?

Any assistance is appreciated.
Thank you.

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
TechBoy wrote:
Hello.

Re: Access 2002-SP3
I have some options turned off under "Tools/Startup" area on my
workstation. When I deploy my app to 5 users (who will all have a
full blown version of Access 2002 on their PC's) I would like to
disable some startup options programatically at runtime via VBA.

I am looking for VBA code to turn off these options at application
startup and turn them back on for the user when they shutdown my app:

"Allow Full Menus"
"Allow default Shortcut Menus"
"Allow Built-in Toolbars"
"Allow Toolbar/Menu Changes"
"Use Access Special Key"


This can be done, but as "Startup Options" the code will only affect what
happens "the next time" the file is opened, not what is available in the
current session. Is there some reason you don't just set these properties
BEFORE you distribute?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
Hi Rick,
Thank you for your reply.
Is there some reason you don't just set these properties

BEFORE you distribute? <<

yes. I don't want the users to be able to go to
Tool/Startup/StartupOptions and click checkboxes to turn all the menus
on and thus be able to get to the DBWindow and jimmy with the data and
possibly corrupt it and/or the table relationships..
My desire to set them via VBA (via an .mde version) inside the app at
startup would prevent the power users from getting to the DBWindow.
This app has some sensitive data in it.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.