Navigation:  Articles > Jul-1997 >

Tip: Don't Forget to Intercept These Keystrokes

Previous pageReturn to chapter overviewNext page

We are good at Access and Excel Programming and UpgradesLoad Basecamp Backup XML to Access or SQLServerThe Smart Access PDFs and DownloadsThe Toolbox - Access KBData Mining Tool In AccessThe Access WorkbenchThese are the products and services that we sell 


Steve Sarre


You can set up an AutoKeys macro to perform an Access action or execute a custom function. The Access online help shows the large number of keyboard shortcuts that are available. You may wish to intercept or handle some of these by masking them with an AutoKeys entry.


It's common to prevent access to the (usually hidden) database container window by substituting a message box if the user presses F11. However, here are some other important but easily overlooked shortcuts that might be worth masking:


Alt-F1          Bring the Database window to the front. 

Shift-F7          Open the Replace dialog box. 

F12          Open the Save As dialog box. 

Alt-F2           Open the Save As dialog box. 

Ctrl-H          Replace. 

Ctrl-S          Save form


Steve Sarre is a subscriber from the United Kingdom..