[AccessD] Startup Properties / Hide All toolbars and menus

Bill Patten bill_patten at earthlink.net
Tue Jun 19 12:50:09 CDT 2007


Hi Gale,

I'm not sure why your's is not working, mine works fine in 2003. Also one of 
them turns off the shortcut menu  because in one form where I wanted my 
clients to have access to the right click menu I and to enter 
Me.ShortcutMenu = True so they could use it.

Any chance that the SetStartupProperties()  sub is not being called?

HTH
Bill


----- Original Message ----- 
From: "Gale Perez" <galeper at gmail.com>
To: <accessd at databaseadvisors.com>
Sent: Tuesday, June 19, 2007 9:53 AM
Subject: [AccessD] Startup Properties / Hide All toolbars and menus


Hi!

Sometime ago, someone on this list provided a function to set/unset startup
properties to disallow certain features:

Sub SetStartupProperties()

    ChangeProperty "AllowFullMenus", dbBoolean, False
    ChangeProperty "AllowSpecialKeys", dbBoolean, False
    ChangeProperty "StartupShowDBWindow", dbBoolean, False
    ChangeProperty "StartupShowStatusBar", dbBoolean, False
    ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
    ChangeProperty "AllowToolbarChanges", dbBoolean, False
    Application.SetOption "Show Hidden Objects", False
    ChangeProperty "AllowBreakIntoCode", dbBoolean, False
    ChangeProperty "AllowBypassKey", dbBoolean, False


End Sub

This code seemed to work just fine with Access 1997, but with 2003,
the "File, Window, Help, Adobe PDF" portions of the menu are still showing
up.  I also need to hide shortcut menus and tried adding ChangeProperty
"AllowDefaultShortcutMenus", dbBoolean, False (also tried it with
spaces, "Allow Default Shortcut Menus"), but that didn't do it.  Is there
another way to do this?

Thank you so much for any assistance.

Gale
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list