Update textbox to current date via VBA

[templeowls]

Bit of an odd one....on my main form, I have a textbox to display the date when the DB was last updated. Every time I update the DB, I have to manually change that date to today's date.



Is there a way via VBA and a command that, when the command is pressed, it just updates the date to today's date? I can't use the 'date' or 'now' function because then it will always show today's date and not the last updated date.

[Welshgasman]

So you just populate the the textbox wirh Date() via you command button?

It is not going to update each time, as it is not a control source?, you activate it with your command button.

Might want to google and see if you can run that code just before the application closes?

Could have it on an autoexec, but no guarantee DB would be updated?

[ranman256]

Add date to the update query, or update event

[templeowls]

So you just populate the the textbox wirh Date() via you command button?

No, so the textbox simply has a raw date in the control source (i.e. right now it is: ='2/10/2023')

As such, I need to manually open the form in design view and change that date to whatever today's date is when I update the DB.

I was hoping to use VBA to be able to update that date via a command.

[Minty]

Store it a "system table" that has other system related data in it.
It can be completely un-normalised, it's just for your use as a developer.

Then look it up when you need it, and set it in the table from wherever you need in the code.

I have a "make production" routine that does a load of house keeping for the database I'm working in.
I hide certain tables, set the toolbar off, update version numbers, set the database updated date, relink SQL views with the correct indexes set to enable them to be editable if I've switched from a development backend etc. etc.
All in one sub that I manually call once that dev session is finished.

[templeowls]

I'll try that. Thanks Minty!