I know that if you define an AUTOEXEC macro that it will automatically run each time the Access database is opened. Is there a way to define a macro or VBA function or subroutine that will automatically be executed if the user selects "X" close button in the upper right-hand corner of the Access window or at any other time Access is closed by any other method? Thanks in advance...
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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Running a Macro or VBA Code When Access is Closed
- Thread starter zerocul
- Start date
jgoodman00
Programmer
- Jan 23, 2001
- 1,510
Could you create a hidden form, which loads at startup, & has an event which runs when it is closed (when the db is closed in this case)??? James Goodman
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question