[AccessD] Startup Properties / Hide All toolbars and menus

jwcolby jwcolby at colbyconsulting.com
Tue Jun 19 12:12:15 CDT 2007


That might have been me.  I haven't tested the code with 2003, and I don't
have time to do so right now so I cant help you much I'm afraid.  It sounds
like a bug in 2003 though to be honest.

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gale Perez
Sent: Tuesday, June 19, 2007 12:53 PM
To: accessd at databaseadvisors.com
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