 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / March 2005event on DB closing
is there a way to fire a procedure on closing the DB? the application object doesn't have any events...so how? I would like to record in a table the date and time of the closing Nico > is there a way to fire a procedure on closing the DB? > the application object doesn't have any events...so how? > > I would like to record in a table the date and time of the closing > > Nico Open a hidden form at startup and use its Close or Unload event. When the app (or Access) is closed those events will fire.  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com UH-UH..NICE! > > is there a way to fire a procedure on closing the DB? > > the application object doesn't have any events...so how? [quoted text clipped - 5 lines] > Open a hidden form at startup and use its Close or Unload event. When the app > (or Access) is closed those events will fire. The typical trick is to create a form that is opened as a hidden form with the DB opens. The in the onClose event for the form fire the code. David H > is there a way to fire a procedure on closing the DB? > the application object doesn't have any events...so how? > > I would like to record in a table the date and time of the closing > > Nico |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.