Startup Properties

[akn112]

Hi all,

does anybody know where i can find information on changing startup options within vba code?

[mattj]

See here: http://msdn2.microsoft.com/en-us/library/aa172350(office.11).aspx

HTH
Matt

[akn112]

Am i on the right path in the code below? How do i check if the property already exists? Kinda confused. Thanks for the website!

Dim dbs As DAO.Database
dbs.CreateProperty "StartupShowDBWindow", dbBoolean, False, True
dbs.CreateProperty "StartupShowStatusBar", dbBoolean, False, True
dbs.CreateProperty "StartupMenuBar", dbBoolean, False, True
dbs.CreateProperty "AllowFullMenus", dbBoolean, False, True
dbs.CreateProperty "AllowShortcutMenus", dbBoolean, False, True
dbs.CreateProperty "AllowBreakIntoCode", dbBoolean, False, True
dbs.CreateProperty "AllowSpecialKeys", dbBoolean, False, True

dbs.allowspecialkeys = true
'.... etc...

Set dbs = Nothing

[mattj]

I've not used these options, so I'm not sure exactly how to check for the property.
See here for a simpler method: http://groups.google.com/group/microsoft.public.access.modulesdaovba/browse_thread/thread/53666696b3102d8c/fe22cab2ab7096c5%23fe22cab2ab7096c5

[akn112]

Hey Matt, it seems the link u sent me is quite limited in it's functionality. Not sure if you can use it for disabling special keys. i have a somewhat working database. the only problem is it only sets the startup properties, meaning, the next time it starts up, it'll take affect.