How to create user login form (MS Access 2000 - 2003)

[Nando]

Hi Allan,
I don't know if it0s ok to ask you this here but since its the same topic

I'd like to know how can I implement a login form in access 2010 for a web database meaning that I can't use VBA and it only has to implemented with macros.

Right now I have a table called users and I can verify if the user existsin the table to open the main form BUT I have the problem where the user just can close the window of the login form and they will be taken to the main form
How do you get to block this only with macros? I think there's not an onUnload event handler

Thanks!

[Allan Murphy]

Sorry, I do not experience with web databases.

Just a thought, on your Login form you could set the following properties Close Button from Yes to No. The Min Max buttons from Both Enabled to None. I know in an ordinary database this prevents the user from Closing the form or Minimising or maximizing the form.

If this fails may I suggest you post your request to the forum.

[Nando]

Thanks Allan for your reply.

Well, unfortunately it seems that on web databases the forms don't have all the functionality available
Close button and min max buttons properties are not present so I'm not able to control that way.

I'll just have to think a way to disable everything in the main form if some temp var has not been initialized. This way the user could close the login window but will end up with a main form completely disabled.

[niso]

I have developed a similar Login form that validates the User ID and Password plus it also validates the users password expiry date. If you like I could send a sample to you or post it to this group.

I use a form with unbound boxes for the Userid and Password, when the user presses the Button to access the database I use a couple of Dlookups to check for a valid user then check for valid password. If both are correct then the next form is opened. If either is incorrect then a message is displayed, the user then has the option to re-enter the user id and password or click on the Exit button to close the database

Can you please forward me the as I would like to see how this code works

[Allan Murphy]

Niso

I you have a look at message 43 or 44 on this forum you will see examples of my login screen etc. The validation code maybe on the login screen or a module called Display menu.

[niso]

Thanks Allan, I hope its gonna work but I will let you know if I had any problems.

[m@rk]

Hi Allan,
Thanks for this Login example, its just what I was looking for!
Just a quick question, I am wanting to display the logged in user name on a form so it acts as a signiture, how do I display this.

Once again thanks,
m@rk

[Allan Murphy]

Hello m@rk

That you for your comments.

By forms do you mean the screen or a form printed as a report.

About message 43 on this forum gives details regarding displaying and using the user id. Here is a snippet from that message

'store the user id on the utility form frm_utility
Forms!frm_utility!user_id = Forms!frm_main!user_id

When you want to stamp a process with the user's id you woulduse something like this user_id=forms!frm_utility!user_id

The frm_utility is open and hidden when the user logs in, the user id is stored on the form. So to use it on the screen or in a report you make reference to the user id as above

[m@rk]

Hi Allan,

Thanks for your reply, I hav tried making a reference to the user id (by copying the text box) from the frm_utility but it still doesnt seem to work?

I basically want to display the name of the person logged in and then populate a form field as a sort of digital signature. (currently the task is done on paper and then signed off)

Can you offer any further help / example on doing this?

Thanks,
Mark.

[Allan Murphy]

Hello Mark

On your form or report add a text box and set the record source to =forms!frm_utility!user_id

Regards

[kan]

Hi Allan,

I am so newbie one. I also need your login that don't need level.

Please kindly help to forward to me on kanporn@hotmail.com

Thanks in advance

[Allan Murphy]

Have a look at message 44 on this thread. Do not use the code that determines the access level.

The login validates the user ID and password, check sfor expiry date of the password. Then opens a switchboard depending on the user's access level.

If you have problems with the please post your attempt to this thread.

[sherryb41]

Allan, I have tried to follow other's examples of login screens and always something was left out or not explained. I really appreciate you helping us here. I have downloaded the example in #10 and opened it in Access 2003 and it works just fine. When I import it into Acess 2010, it stops with the error message: Object doesn't support this property or method. Can you tell me what I need to change to make it work. Thanks.

[Allan Murphy]

Sherry

Thank you for your comments. This is my way of thanking other people who posted various solutions that helped me over the years.

Your problem maybe due to not having a reference set in Access 2010. At the moment I am using Access 2007 not Access 2010.

I have attached a screen shot of the references required for Access 2007 there maybe similar references for 2010. I have also included a zip copy of a newer version of the #10 this new version is located at #43 from memory. I may have made some minor changes to this version.

When I install Access 2010 I will update this thread.

[Allan Murphy]

Sherry and all previous viewers

Here is the login version in Acccess 2010 format.