help with coding a form

[Rick Wright]

GlacierHi -

I'm just starting to learn access and need some assistance with my project.
I'm trying to design a db to track the login and logout times of users. My
concept is to have a form linked to a table that contains the member#, Name,
logintime and logouttime. This form will have only two command buttons: 1.
Login 2. Logout. When 1 or 2 is clicked the user will be prompted to
enter their name and a new record will be created for the member with date
and time recorded. Then I can create a report that will show the members
login/logout information.

I don't know how to code the event procedure. I tried creating a macro that
runs a query, but it fails when trying to setvalue to the login field. I
know that there must be a better way. Any and all assistance would be
appreciated.

- Rick

 

[Jason]

Just use a form - allow additions but not deletions. Not sure if no edits
would work. Someone will post with correct procedure.

 

[Pete D.]

With a small combination of modules you can,
1. extract user network logon name and system
http://www.mvps.org/access/api/api0008.htm
http://www.mvps.org/access/api/api0009.htm

3. grab date/time
With CodeContextObject
.DateModified = Date
.TimeModified = Time()
.UserLogon = fOSUserName()
.MachineName = fOSMachineName()
End With

Automate updating a record in a logn table
Fire all these events with a timed startup form, (splash screen) or an
autoexec macro so no user intervention required, totally seamless.