Hot keys to call a Macro or VBA

[benkingery]

I am comfortable with VBA and/or creating macros. I have an Access front end that users interact with. I have stripped away the database window so the only visual thing is the switchboard from which users access menu items.

Problem is this. For some reason when we upgraded to Access 2007, we are finding that the switchboard locks up when data is imported or exported via a programmed vba module. So, user is in a section and performs a task by clicking a menu item. That task imports or exports data according to a vba module, and then user can't exit that portion of the switchboard. The switchboard becomes totally unresponsive.

The only fix for users is to close the Access front end and then reopen it (obviously less than optimal). If I am in the room, I can unhide the database window, and then close the switchboard and reopen it which also solves the problem.

Anyone have any ideas about how to fix this? My easiest solution I thought of was to create a quick Macro or VBA module that would close the switchboard form and then reopen it. Problem is I need a way to call that code with hot keys or something....

Anyone have any ideas?

Thanks,

Ben

 

[gemma-the-husky]

there probably is something going on locking the form that you ought to investigate

hotkeys - look at autokeys macros - they should do what do what you want.

 

[benkingery]

Autokeys macros were the answer. Thanks.

Yeah, I'm not sure where to look in investigating the lockup problem with the switchboard. Since it seems to be isolated to that, I wasn't that worried.