|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
VBA coding for Access 2000
I know that this forum usually deals with SQL and Oracle but I need help with a simple Visual Basic for Access code. I have looked online up and down and I have not been able to find a VBA code for a Timestamp for Access 2000. I want the timestamp field in the form to automatically insert the current time/date when I first bring up the recorde then save the time stamp when I save the record. I have seen coding for access 2002 and 2003 but none for 2000. Thanks for the help.
|
|
#2
|
|||
|
|||
|
can anyone help me?
|
|
#3
|
|||
|
|||
|
In the table design, set the default value for the field to "Now()" (minus quotes). This will ensure that all new records will have the current time stamp.
For updates in the form, use the following code in the OnDirty event: Private Sub Form_Dirty(Cancel As Integer) Me!FieldName.Value = Now() End Sub This will update the field whenever the record is updated. I hope this helps. |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > VBA coding for Access 2000 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|