Display Last Saved date and time
Competent Performer
Windows 10 
Access 2016
I want to display Last Saved date and time on my Main Menu after doing a vba backup subroutine. I had created an unbound text box and saved the date and time to it at the end of the backup, which was fine but it didn't retain that info when I closed and restarted the application.
Code:Me.tbxFileVersion = Format(Now(), "yyyy-mm-hhnn")
Indifferent
Windows 10 Office 365
Very Inert Person
Windows 10 Access 2016
If you're wanting to show that on the main form, you need a table field and bind the textbox to it. Your update process would update this field.
Unbound controls have no place to store data so the contents are lost when you close the object, provided that the unbound control isn't populated by an expression. Then maybe.
EDIT - I've found file attribute date/times to be unreliable as reported in Windows Explorer. That's why I would use a table field and the system date time when the operation runs.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Competent Performer
Windows 10 Access 2016
My Main Menu didn't use a linked table where I could add a field so I created a new table with one field to store this data. Thanks for the help.
Very Inert Person
Windows 10 Access 2016
Been there, done that. You might find that table useful for other db properties or information going forward.
Glad to have been of some help.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
How do I run a saved Import routine automatically every time i open my database?
Date Field Check against Saved Date?
Posting Permissions
Reply With Quote