Solved

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

Posted on 2009-05-13
2
287 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

932 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now