Displaying the "Last Updated" field from the Properties of a table

[Guest]

Is there a way to take the Created date from a Table’s Properties field and
display it on a form? I have a form that I want to show the date that the
table the form is accessing, was late updated.

 

[Jeff Boyce]

Careful what you wish for... <g>.

Do you mean the date the structure of the table was created (not the same as
last updated), or do you mean the most recent date a record was added, or do
you mean the most recent date a record was updated?

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

Hi Jeff,
I usually replace the table every couple of days from an extract I get from
another data base, it's a xls spreadsheet. So the created date and the
modified date of the table are usually the same. I'd like to put a text box

 

[Jeff Boyce]

Getting the table property might be a bit more work. If, when you refresh
your table from excel, you also stored the "UpdatedOn" date/time value, you
can easily display a control on the form to show that date/time.
Take a look at the DMax() function in Access HELP. While there, you can
also check on the table property.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/