table usage

[Paul \(OMAC HX\)]

Hi All,

I use access as a members area login. When the username and password are
entered correctly the results form displays a link in to the index login
page.

My question is , is it possible to also have the login recorded in another
table with the users details so i can see the usage of the members area.
Or is this a confliction

The user enters there username and password and in a results form underneath
it pulls up the link this can be seen at www.omachx.com - members area.

Any help is greatly appreciated.

Thank you

Paul

 

[pietlinden]

Hi All,

I use access as a members area login. When the username and password are
entered correctly the results form displays a link in to the index login
page.

My question is , is it possible to also have the login recorded in another
table with the users details so i can see the usage of the members area.
Or is this a confliction

The user enters there username and password and in a results form underneath
it pulls up the link this can be seen atwww.omachx.com- members area.

Any help is greatly appreciated.

Thank you

Paul

sure, you could validate the username/password with one function and
write the login info to another.

dim strUserName As String
strUserName=Me!txtUserName

DBEngine(0)(0).Execute "INSERT INTO tblLogins(UserName,LoginDate)
VALUES('" & strUsername & "'," & Now() &")",dbFailOnError