help with coding a form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rick Wright - 09 May 2008 19:44 GMT

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

Reply to this Message

Jason - 10 May 2008 09:23 GMT

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

> GlacierHi -
>
[quoted text clipped - 13 lines]
>
> - Rick

Reply to this Message

Pete D. - 10 May 2008 15:09 GMT

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.

> Just use a form - allow additions but not deletions. Not sure if no edits
> would work. Someone will post with correct procedure.
[quoted text clipped - 21 lines]
>>
>> - Rick

Reply to this Message