I have six append queries and a delete query to transfer completed ECN's to an Archive dbase from my Working dbase. I created a macro to execute the append queries and the delete query. I tried to run the macro in the Switchboard's OnExit event, and the entire dbase started run very strangely. So I removed that, and then I tried to add a quit to the macro and in the switchboard menu, I change that exit to run macro. That to failed, again somemore strange behavior occured. So I removed the quit from the macro, then I tried to make a function, running everything in that and including a Application.Quit at the end. Again nothing but the same strnge behavior as was in the macro. My twenty dollar question is where can I run that macro so that it works, like when I click on it? Ideally I would like to run it once when exiting the dbase or at the end of the day. I know I can run it on the forms OnExit event but then it could be running a dozen times a day, and I woulds rather not do that unless I have to. Thank you in advance to anyone having a solution to this preplexing question.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Where to Run a Macro to Append Data to Another Dbase
- Thread starter quest4
- Start date
- Status
Similar threads
- Locked
- Question
