Insert Date() in table field using a macro

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.
 
J

JK

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!!!
 
S

Steve Schapel

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() ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run a VBA Sub using Windows Scheduler? 5
Clear a date field using a macro 12
Update table based on partial text in field 2
setting the argument in SETVALUE Action of macro 6
Using a macro to insert text into a field 6
Macro or CODE to change data format in a table for user 3
Automated Weekly Output Table to Excel 3
Run macro if table field value = today 1

Top