How do I display Modified date

  • Thread starter Thread starter DavPet
  • Start date Start date
A form's modified date? Do you have a field where you store this? If so,
put that field in your footer.
 
No I don't store it.
I want to display the same date that shows under "Modified" when
you view the database window with "Details" turned on.
 
I have never seen a way to obtain that date. Maybe someone will post a
reply with a trick that I have not seen before.
 
=DLookUp("DateUpdate","MSysObjects","Name='NameOfForm'")

To avoid having to hard-code the form name, you can set the control source
in the form's Load event:

Me.txtModified.ControlSource =
"=DLookUp(""DateUpdate"",""MSysObjects"",""Name='" & Me.Name & "'"")"

I've only tested this in Access 97 (where each form does get a different
modified date). I would think that in Access 2000 and higher, all forms
would have the same modified date, due to the monolithic save.
 
I'd had a chance to look at it in Access 2003, and it seems to give a
different time than on the Details display in the database window.
 
Dunno' much about "monolithic save" but:
The second version works for me (Office 2003).
The first version gives a date but not the one I need.

thank you
 
Back
Top