simulate timestamp 1

[zyrag]

i want MS access to save the timestamp into a date/time field on my table everytime a transaction is entered. how do i achieve this without coding through macro?

 

[IanGalletly]

Hi Zyrag

There are lots of ways to crack this nut. The quickest may be the following

In the field definition within the table design set the default value to =Now()

As new records are added to the table the date stamp will be automatically set.

Hope this helps

 

[trystanhuwwilliams1]

Zyrag - There are many ways to do this, the simplest way would be to set up a form which based on the table with a text box which automatically enters the current date when you exit the last field of your table. (You would need to add a field called Timestamp to your table).

Set up a form based on the table and enter the following code into the On Lost Focus event of the last field:

Private Sub LAST_FIELD_LostFocus()
Dim cur_date as date


cur_date=Date
[TimeStamp].Value=cur_date
End Sub

You could lock this field or even make it invisible

 

[zyrag]

thanks to both of you guys. you both have great ideas but Ian's way solved much of my requirements. I wasn't able to mention that i'm using vb6 as the front-end, but trystan's way also works great.