Master Database Save on Quit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a program with multiple forms to enter data into different tables.

Some times the user leaves the form open and goes to a different form.

Then Quits the program. This sequence sometimes fails to post to the table
as the form was never closed.

Is there some VBA command that will close all open forms or post the data so
data is not lost when the person exits the program
 
Each form is closed by Access before it closes. You could code the Close
event of all your forms to perform any updates that are not complete.
 
You must log in or register to reply here.

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

Quit Database 1
Access how to open existing database from another database using Access - VBA 0
Need combo box to refresh when moving to new record 2017 1
Data entry for a table from a form 1
Saving, quiting data 1
Name in table changes 3
search query on form causes db to crash 7
Find prev record on other requeried form 2

Back
Top