Running Code as Access 2007 Shuts down

N

news.microsoft.com

I want to run some VBA code in Access 2007 as the application is being shut
down.

How is that done?
 
K

Ken Snell MVP

You have your application open a hidden form when it starts up (either in
Startup options, or from the first form that is opened automatically). Put
hte "shutdown" code in this hidden form, in its Unload event. When ACCESS is
shut down, this form's code will run when the form is being unloaded.
 

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

Cannot open any folders (pinned or recent) from Word 365 Open Dialogue/Backstage 0
Insufficient Memory or Disk Space. Close programs down? 0
Text in note pane of "normal" display suddenly much larger 1
Apple Script in Outlook 365 Mac keystrokes blocked on M1 mac 0
VSTO C# add in Outlook.Appointment error 0
Running Code before Access 2007 closes down 1
vb code for 30 day trial limit 3
Desiabled Macro's and VBA Code 2

Top