Login Page or Screen

[amanda]

How do i create a login page to capture date and time for students? Prefer to
use Access, Excel. Thought is to have student access page with a username and
password and the date and time stamp would automatically be captured along
with the computer ID.

 

[Gyorgy Moldova [MCSE, MVP]]

You may create an Access database, with a form created, where a field's
value has been set to Now() which inserts the current date/time.... However,
the more problematic thing is that how do you get the user add his/her
record to the DB.

hth
g

 

[Badger04]

Amanda

You can use the Environ function to capture the users system values, below
captures some but there are more.

You can either bind the Access form to a table to capture the values
automatically or you can use a recordset, adding and removing entries when
users log in and out.

Badger

If UCase(Environ$("FULLNAME")) = "" Or IsNull(Environ$("FULLNAME")) Then
gUserId = UCase(Environ("user_name"))
gUserName = UCase(Environ("full_name"))
AssetId = Environ$("Computer_Name")
gLoginDateStamp = Now()
Else
gUserId = UCase(Environ("Username"))
gUserName = UCase(Environ("fullname"))
AssetId = Environ$("ComputerName")
gLoginDateStamp = Now()
End If