VBA Code To Run When The Access Application Quits

  • Thread starter CrazyAccessProgrammer
  • Start date
J

Jeanette Cunningham

Hi,
one way is to create a form that opens in hidden mode at startup.

When access closes, it closes forms in the reverse order that they were
opened.
The hidden form opened at startup will be the last form closed.
On the hidden form's unload event, put the code that needs to be run when
access closes.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
C

CrazyAccessProgrammer

Thanks (again) Jeanette. Next question, how do I get as smart as you? =)
 
J

Jeanette Cunningham

Perseverance and lots of time spent reading the access discussion groups to
help you solve your development problems. Access has a very steep learning
curve, so allow plenty of time for learning before expecting it to become
easy.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Access wait for Excel 9
Example Of VBA SQL Statement 0
Shell programming 12
Stored Procedure 15
Vista and Access 2003 2
VBA - Word automation (mailmerge) - convert access 2007 3
Quit Access 2
Set a flag when updates occur in a subform 4

Top