Insert Date() in table field using a macro

  • Thread starter Thread starter JK
  • Start date Start date
J

JK

I run a macro each night that runs multiple update queries. I use this setup
to keep my access 03 database in sync with our company database J.D. Edwards.

During this update, I would like the marco to auto insert the current date
date() into a table i created called tblUpdateTablesInfo, field = LastUpdate.
I tried to use the setvalue function but I can't seem to make it work.

Any help would be greatly appreciated.
 
I figured it out. I created a new form with the one date/time field. I
created a macro to setvalue of the field to Now() when the form is opened.
Then, in my update macro, I open and then close the form. It seems to be
working. If there is a better way, please let me know... Thx!!!
 
JK,

In my opinion, this is a rather awkward approach. Since you are already
using Update Queries, and running them within your macro, why not just
include another Update Query based on your tblUpdateTablesInfo table to
update the LastUpodate field to Date() or Now() ?
 
Back
Top