2.27 Creating a Multi User Login System in Access VBA

[mrosamabinobama]

thanks a lot!

[iProRyan]

Awesome, Thanks! Something silly but I can't find it in properties, how do you make the password text box, use a * symbol instead of the actual letters?

[Firchild]

@iProRyan It should be under 'password characters' I'm sure it's in properties!

[iProRyan]

@Firchild After some research, I found that it comes under "Input Mask" and then "Password" in the properties windows.

[Firchild]

@iProRyan Ahh, I knew it was there somewhere!

[Valzz99]

I'm doing GCSE I.T at the moment, and currently I'm writing a report, explaining how the current very simple database can be improved for the better. Whether I should be talking about creating a Login/Password and explaining how the coding allows the system to operate I don't know, but hopefully it'll gain me a few marks for perhaps research I've carried out.

[fredrick2031]

Brilliant Video Firchild - very helpful and easy to understand.

If possible, please could you help me with an urgent request - can you please upload a tutorial on how to create a multi user login system using data from a table in MS Access - the Login form will then check whether the data entered matches the data in the table.

Thank you

[tareksul]

May I ask permission to use this coding in my 12th grade school project, I'll make sure I cite from where I got it.

[Firchild]

@tareksul Of course, that's what it there for!

[jyeshe108]

hey, I want to save user accounts' username and password as a user setting but i don't think there is code to do that. if anyone knows if this is possible or if there is a different way to do it please reply.

Thanks in advance,

Joshua

[misr4misreen]

شكرا جزيلا

[Josheykun]

I found why its bugging with the setfocus, you have to make sure that you setfocus to whatever you have called the taxt box that is where the user will type in their username.

[Josheykun]

I got the same problem with the higlighting .set focus and im on access 2003

[jegesmu]

thanks for the tutorials Firchild

you're the best :)

[kingshinigami1989]

well i' did everything word to word

ditto

the debugger starts and highlights set focus

and it says something along the lines that:

.SetFocus is not there or allowed or not found

something like that

[Firchild]

Sorry mate, you'll have to debug. Users have been using this in access 2003 and 2007 with no problems (both my own students and youtube users). Unless you're using some other variant of access or VB on its own, in which case, this won't work.

[a4whlndude]

Amazingly helpful video series. simple easy to understand tutorials in very well planned steps. Thank you so much for posting these.

[DLiberator78]

Thanks, I shall look forward to your password in tables tutorial in 6 months time.

[DLiberator78]

Wow that is a fast reply. Thanks for your answer it now makes perfect sense. Will you ever make a tutorial video to explain how to do this with the table method?. Thanks.

[DLiberator78]

...Is there a particular reason why you used the VBA code for passwords and not store the username and password in a table? Managers could have an added field in their form that could add users to the database which can then load another form to add the users and passwords to the T_users. Also in this table you could have a field for managers and one for normal employees. Like I said I have a couple of examples that I found while researching on the web and I wanted to know your thoughts. Thanks.

[DLiberator78]

First and foremost I would like to thank you so much for taking the time and effort in producing these video tutorials for Access. I have learned a great deal and as I am a relative noob these guides have been invaluable. I mean no disrespect but having followed this particular guide I find that storing usernames and passwords in code rather cumbersome and longwinded. Would it not be better to store User and pass in a table? I have a couple of demos that use the table method and form...

[Firchild]

This is designed for A-level Computing where marks are gained for coding. Hence, we use code, as this is meant to prepare students for more advanced use of VB, C++/CSharp and the ilk. Agreed, it would be easier to use a table, but the examiners would pan it as it shows little or no coding ability.