Getting Date from a process to a access table

[miller1975]

Hello All,
I am running a VB batch code to get some data in Access. What I want to do is capture the date when the batch ran and store that value in a table.
For example the table where this date should stored will be called "UpdateDate" and it will have just one field called "ProcessDate".

Can this be done. Please advice.

Thanks in advance.

 

[Golom]

Presumably you're inserting a new record in the table when the batch runs so try something like

INSERT INTO tblRunDates (BatchNumber, UpdateDate)
VALUES ( 12345, Now() )

 

[miller1975]

Hello Golom

INSERT INTO tblRunDates (BatchNumber, UpdateDate)
VALUES ( 12345, Now() )

Here what does 12345 do?
Why do we have to use field BatchNumber?
And will use/run this query from Access

 

[Golom]

I was assuming that you were inserting a new record into your table every time you ran a batch. The "12345" is where you should insert the batch number. If you don't include it somehow then you will just have a table filled with date stamps with no way to relate them to the batches.

If the record with a batch number already exists and you just want to enter the time stamp then

UPDATE tblRunDates SET UpdateDate = Now()
WHERE  BatchNumber = 12345

And again, "12345" is the batch number that you want to set the UpdateDate for.

 

[vladk]

One word of concern: The Now() function returns date/time from the PC that is running that VB code. You need to make sure that nobody can reset that PC's clock to some wrong value. It is safer to use the server's date/time stamps by applying Access date/time functions on the server side.