Hi ppl,
I'm just about to install a database this week. However, I'm trying to provide a "Back up Database" facility.
I noticed there was some code floating around to do this. However, I was hoping just to put it in the File Menu so users could backup manually.
I have set the Startup options not to show full menus as I don't want the users to be able to play around with all the other menu functions they don't need.
Unfortunately, doing this, has caused me to lose my "Back Up Database" File Menu option. And of couse, the Tools menu is gone as well.
I've now customized the file menu in the User Ready Database to include the "Back Up Database" menu item.
I keep getting the following error message everytime I click on the "Back Up Database" File menu item:
ERROR MSG:
"You can't exit microsoft office Access now.
If you're running a Visual Basic module that is using OLE or DDE, you may need to interrupt the module."
The only Form I have open when I click on this menu item is the Switchboard. My Switchboard has 3 [Event Procedures] for OnCurrent, OnOpen and OnClose. I've attached my VB code for the Switchboard.
I think it might be related to the switchboard form. But I don't know what's causing the problem. The same "Back Up Database" file menu item works without errors in the Developer Version of my Database (i.e. with the full menus).
I've included a txt file of my Switchboard code. Most of the code is the standard code that Access generates when you create a switchboard using the Tools -> Database Utilities -> Switchboard Manager.
Hope someone can shed some light on this error.
I'm just about to install a database this week. However, I'm trying to provide a "Back up Database" facility.
I noticed there was some code floating around to do this. However, I was hoping just to put it in the File Menu so users could backup manually.
I have set the Startup options not to show full menus as I don't want the users to be able to play around with all the other menu functions they don't need.
Unfortunately, doing this, has caused me to lose my "Back Up Database" File Menu option. And of couse, the Tools menu is gone as well.
I've now customized the file menu in the User Ready Database to include the "Back Up Database" menu item.
I keep getting the following error message everytime I click on the "Back Up Database" File menu item:
ERROR MSG:
"You can't exit microsoft office Access now.
If you're running a Visual Basic module that is using OLE or DDE, you may need to interrupt the module."
The only Form I have open when I click on this menu item is the Switchboard. My Switchboard has 3 [Event Procedures] for OnCurrent, OnOpen and OnClose. I've attached my VB code for the Switchboard.
I think it might be related to the switchboard form. But I don't know what's causing the problem. The same "Back Up Database" file menu item works without errors in the Developer Version of my Database (i.e. with the full menus).
I've included a txt file of my Switchboard code. Most of the code is the standard code that Access generates when you create a switchboard using the Tools -> Database Utilities -> Switchboard Manager.
Hope someone can shed some light on this error.
