Tags: 2002-sp3i, access, app, area, bar, database, deploy, menu, microsoft, mysql, myworkstation, oracle, sql, startup, tools, turned, users, vba, via

Menu Bar Startup Options via VBA

On Database » Microsoft Access

2,601 words with 2 Comments; publish: Mon, 31 Dec 2007 00:36:00 GMT; (25062.01, « »)

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.

All Comments

Leave a comment...

  • 2 Comments
    • 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

      #1; Mon, 31 Dec 2007 00:37:00 GMT
    • 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.

      #2; Mon, 31 Dec 2007 00:38:00 GMT