Log-in Screen

[imintrouble]

Hello! I am in need of creating a login screen which I suppose would be made with a form. I already have the form opening up when the database is opened.

I am then in need of a way to create a login screen which allows the user to enter their name, the date, and effectivly, log in, entering the time that they logged on into a table where a field is already created, Start_Time.

Vice/Versa however I also need a way that the user can either go back to the login form or what have you and logout creating a time entered into the End_Time field, or by creating an unload/onclose event to state the end time instead.

If any more information is needed, please feel free to ask.

[A S MANN]

The Procedure I Use is as follow for my user to log in in my Front End.
Create a Table With All User Name pre-define.
Create a Log in Form With a Combo Box Connected to User in Table.
Create text boxes for Module Name (Control Source="Module Name" ),
Date Of Log in(Control Source=Date() ),
Time (Control Source=Now() Format =Medium Time) ,
Log In Computer Name (Control Source=getuser() )
you Need Fuction =getuser() and add to your module as fuction
add one Log In Button Set to take user to Home Form After Log In
on click event
stDocName = "Home Form"
DoCmd.OpenForm stDocName, , , stLinkCriteria
This will be simple Log In Form.First create a simple Log In form Tha add more fuctions such as
The Log In Data can be added to LogIn Table
User Log In Right Can also be checked to Take user to various forms in place of Home Form etc etc.

[imintrouble]

stDocName = "Home Form"
DoCmd.OpenForm stDocName, , , stLinkCriteria
This will be simple Log In Form.First create a simple Log In form Tha add more fuctions such as
The Log In Data can be added to LogIn Table
User Log In Right Can also be checked to Take user to various forms in place of Home Form etc etc.

I got everything up until this point. Not sure what i'm supposed to do witht this information. Any further help with this would be greatly appreciated.

[A S MANN]

I will try to send you a sample copy of My Log In Form Probably you can copy it to your DB(Frond End) And use it. How can you get the file. Probaly i need your E Mail Id to send the file.

[imintrouble]

yeah that would be fantastic. the e-mail to reach me by would be jrcobb2@cougars.ccis.edu I check this e-mail all the time. Thanks!

[A S MANN]

I need to Create a Seperate file for Log In Form, Their Module Table Etc, Sending You soon in your Mail ID.

[A S MANN]

I had send a mail to jrcobb2@cougars.ccis.edu with a zip file having instrctions and a sample mdb file hope this will solve your proble,
thanks

[karanvemuri]

hi guys, m lukin for the same thing,will be glad if you can share it with me... my email id myhomeunited@gmail.com

[A S MANN]

I had send you the Mail at myhomeunited@gmail.com on 11/10/2011 4 pm
Contact me Soon