Re: help with coding a form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.



"Jason" <JAllenNZ@xxxxxxxxxxx> wrote in message
news:uV7TucnsIHA.4260@xxxxxxxxxxxxxxxxxxxxxxx
Just use a form - allow additions but not deletions. Not sure if no edits
would work. Someone will post with correct procedure.
"Rick Wright" <rbw95662@xxxxxxxxx> wrote in message
news:WrqdnV62UrThBrnVnZ2dnUVZ_rjinZ2d@xxxxxxxxxxxxxxxxxx
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






.

Quantcast