?
Solved

Can I capture the MS Access 'close event' during design

Posted on 2009-05-13
2
Medium Priority
?
293 Views
Last Modified: 2012-06-27
I am wanting to record in my DB every object's modified time-stamp when I close Access
Currently there is a bug in Access 2003 that doesnt update the MsysObjects table's "UpdateDate' for an object, but MSAccess does store a 'modified' date which is not accessible to the user via tables...only through code.

I believe I can iterate through forms, queries, reports, modules etc using the following line of code and a recordset out of MSysObjects

      CurrentDb.Containers(strObject).Documents(strObjectName).LastUpdated

I will save the results to a table, but I want this to occur when I close Access.
I use this DB for design purposes only, it is linked to VSS and stores many objects which  I then use to build custom applications by importing the objects I need into new databases.
The DB does not run a user application, so a hidden form is not the option.
Can I capture the closing event, and run my table update routine via VBA, before Access closes?
0
Comment
Question by:Milkus1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 39

Accepted Solution

by:
thenelson earned 250 total points
ID: 24385357
The only way to capture MS Access closing is to have a form open (it can be open hidden) and capture its closing event. The form will close just before the DB closes.
0
 

Author Closing Comment

by:Milkus1
ID: 31581295
Not really the answer I was seeking, and just reiterated what I said i didnt want...prefer no answer if this is the case
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question