Get back into a DB when GUIs are off

[Guest]

In Office 2003, I have noticed through examination of the [Tools] [Startup]
dialog box that many of the basic controls can be turned off; I like the
flexibility of being able to control the interface, but is there a list of
keyboard shortcuts or other info for regaining these controls?

I don't want to lock myself out of my own DB by disabling all the standard
GUIs, but at some point you want to test your DBs appearance and then get
back in to tweak it. How do the pro's handle this?

Thanks for your input.

 

[Marshall Barton]

In Office 2003, I have noticed through examination of the [Tools] [Startup]
dialog box that many of the basic controls can be turned off; I like the
flexibility of being able to control the interface, but is there a list of
keyboard shortcuts or other info for regaining these controls?

I don't want to lock myself out of my own DB by disabling all the standard
GUIs, but at some point you want to test your DBs appearance and then get
back in to tweak it. How do the pro's handle this?

I kind of bail out on this by just creating a VBA procedure
that turns thing on (show db window, unhide tool/menu bars,
?). Then use an AutoKey macro on an obscure key combination
(Ctrl+shift+F7) to run the procedure.

Don't forget that changing the AllowBypassKey (shift key)
option won't take effect until the next time the db is
opened.

 

[Guest]

I like your idea; can you help me out with how to set up and trap the key
combination and fire the code? - I've never worked with Access Macros, but I
have coded a lot. Thanks.

In Office 2003, I have noticed through examination of the [Tools] [Startup]
dialog box that many of the basic controls can be turned off; I like the
flexibility of being able to control the interface, but is there a list of
keyboard shortcuts or other info for regaining these controls?

I don't want to lock myself out of my own DB by disabling all the standard
GUIs, but at some point you want to test your DBs appearance and then get
back in to tweak it. How do the pro's handle this?

I kind of bail out on this by just creating a VBA procedure
that turns thing on (show db window, unhide tool/menu bars,
?). Then use an AutoKey macro on an obscure key combination
(Ctrl+shift+F7) to run the procedure.

Don't forget that changing the AllowBypassKey (shift key)
option won't take effect until the next time the db is
opened.

 

[Marshall Barton]

Select the Macro tab on the database window. If there is a
macro named AutoKeys click on it and then click on Design,
otherwise click New (and save it with the name AutoKeys).
Under the Macro Name column, enter the key code combination
that you want to use for the backdoor, select RunCode in the
Action column and the name of your VBA function procedure
in the property in the lower part of the window.

For more details see AutoKeys in Help.

Don't worry about becoming faniliar with macros. I use only
one or two macros, AutoKeys and sometimes AutoExec.
--
Marsh
MVP [MS Access]

I like your idea; can you help me out with how to set up and trap the key
combination and fire the code? - I've never worked with Access Macros, but I
have coded a lot. Thanks.

In Office 2003, I have noticed through examination of the [Tools] [Startup]
dialog box that many of the basic controls can be turned off; I like the
flexibility of being able to control the interface, but is there a list of
keyboard shortcuts or other info for regaining these controls?

I don't want to lock myself out of my own DB by disabling all the standard
GUIs, but at some point you want to test your DBs appearance and then get
back in to tweak it. How do the pro's handle this?

I kind of bail out on this by just creating a VBA procedure
that turns thing on (show db window, unhide tool/menu bars,
?). Then use an AutoKey macro on an obscure key combination
(Ctrl+shift+F7) to run the procedure.

Don't forget that changing the AllowBypassKey (shift key)
option won't take effect until the next time the db is
opened.