I'm creating a Ticketing System in Ms Access 2000. I'm a newbie...by the way. My problem is; I want to track each time someone logs into my database: When they open a new ticket and when they update an exisiting ticket. I want to track their username, time and date the ticket was last updated. I have a tranaction code but it's not working. Can someone please help me. I have been working on this for couple of days and I cannot get it to work.
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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I create a Tranaction Log list - Time and Date Stamp
- Thread starter Tommoyak
- Start date
PhoenixDon
MIS
Off the top of my head, I would think you need two fields in your table. START and STOP. You could make a button for each and then the code to put the time stamp in.
Private Sub btnStart_Click()
START.Value = Now()
End Sub
Private Sub btnStart_Click()
START.Value = Now()
End Sub
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Question