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