If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
help with coding a form
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 |
#2
|
|||
|
|||
help with coding a form
Just use a form - allow additions but not deletions. Not sure if no edits
would work. Someone will post with correct procedure. "Rick Wright" wrote in message est... 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 |
#3
|
|||
|
|||
help with coding a form
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" wrote in message ... Just use a form - allow additions but not deletions. Not sure if no edits would work. Someone will post with correct procedure. "Rick Wright" wrote in message est... 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 |
Thread Tools | |
Display Modes | |
|
|