add a date to a table - for audit 1

[psarros]

I have a form that has a button on it that performs a function. I need to know when that function was performed, so I have created another table.

What is the code to add the date and time into that table

 

[yamafopa]

Add a new column to the table underlying you form. Make this column of type DateTime. Put a control on the form that is bound to this field. It's up to you whether you want to have this control visible or not, but don't enable it since you never want anyone to change it. On the click of your button ...

Me.audit_date = Now()

Now() represents the system time and date at the moment your reference it.

You can also use Date() which will give you only the date.

hth

yamafopa!

 

[psarros]

I can't add it to the same table, there a thousands of records. It would be overkill. I want to update a separate table.

 

[Bullschmidt]

Perhaps create an append query that that you trigger with code.

And a calculated field in the query might be:
MyFieldCalc: Forms!MyForm!MyID

And another calculated field in the query might be:
MyDateTime: Now()

Best regards,
J. Paul Schmidt

http://www.Bullschmidt.com

- Putting Databases on the Web

http://www.Bullschmidt.com/DevTip.asp

- ASP Design Tips

 

[Bullschmidt]

Or if you just want to store the date and not the time:

And another calculated field in the query might be:
MyDate: Date()

Best regards,
J. Paul Schmidt

http://www.Bullschmidt.com

- Putting Databases on the Web

http://www.Bullschmidt.com/DevTip.asp

- ASP Design Tips