Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
tracking date and time
- Thread starter eshaan
- Start date
Hi Eshaan,
I used the following to track username when he/she enters a new record. It goes something like this: Create an unbound form with an unbound cbox (cbxUserID) which can lookup the employee names. Then you store the selected employeeName through a public keyword (lngCurrentEmpID). Ones the employee enters a new record you assign the value to a textbox (EnteredByName) that stores the value in the bound table. To time stamp the new record, create a date variable (DateENtered) and set its default value to Now()
Pampers.
You're never too young to learn
I used the following to track username when he/she enters a new record. It goes something like this: Create an unbound form with an unbound cbox (cbxUserID) which can lookup the employee names. Then you store the selected employeeName through a public keyword (lngCurrentEmpID). Ones the employee enters a new record you assign the value to a textbox (EnteredByName) that stores the value in the bound table. To time stamp the new record, create a date variable (DateENtered) and set its default value to Now()
Code:
Private Sub cbxUserID_AfterUpdate()
'this code is written by Evan Callahan
' Copy the employee ID entered to a public variable. Since this
' variable is declared in the Miscellaneous module using the
' Public keyword, it is available throughout the application.
lngCurrentEmpID = cbxUserID
End SubPampers.
You're never too young to learn
- Status
Similar threads
- Locked
- Question
