Solved

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

Posted on 2009-05-13
2
288 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
2 Comments
 
LVL 39

Accepted Solution

by:
thenelson earned 125 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

803 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