2.26 Password Login Form / screen using VBA in Access

[BrunoMarsCrazyy]

OMG thanks needed it for my computing coursework

[baysharks21]

I'm sorry - I finally figured it out..

THANKS!!!

[mrosamabinobama]

YOU ARE AWESOME!!!!!, SAVED MY LIFE!!!!! (I had to do assignment)

[wellhrd]

It works well i follow using 2007! Gr8 man!

[Peeboontheng]

1 word 'COOL'

[hi2udemon]

@Peeboontheng two words 4 me.....thumbs up! :)

[ConswaylahBear]

Ive done exactly wat is said but when i press the button nothing happens... plz help asap

[Firchild]

@ConswaylahBear Read the feedback to the previous, identical comment..

[hlmasoud]

i did it as told but nothing happened when i press on the button.

please help

[Firchild]

@hlmasoud Check your code is referencing the text boxes username and password (and that you've named the text boxes from text1, text2 etc - and not changed the label instead)

[hlmasoud]

@hlmasoud

found the error. i had the security warning disabled.

1000 thanks for this vedio.

cheers

[Firchild]

@hlmasoud No worries, that security warning is a pain! It does stop nasties though..

[shwaen]

hi firchild thx for ur video! i follow all ur steps but whn i click validate, ntg happens. Thanks for ur helping hand!!!!!!!

[AndreMartins2010]

caro amigo, agradeço sua aula. Foi muito interessate!

Dear friend, thank you for your lesson. It was very interesting!

André - São Paulo - Brasil

[subhanibutt786]

my some problems solves thank a lot

[frankkdonald]

Very Helpful, Thanks :)

[gr1zzley]

i try to do this and copied the code on to my data base but i keep getting a error message 424 on my code it refers to the username.setfocus

any helps

[Firchild]

@gr1zzley You haven't named the box that accepts the username as "username"

[thepvporg]

I would like to point out and make it very clear that Microsoft Access CAN NOT be made SECURE in the manner as illustrated. What this is useful for is segregated users menus. Also an Access database SHOULD NEVER be used to store sensitive data, if you want to store sensitive data, you are reminded of the legislation on doing so and you should consult the data commissioner on the data you are looking to store to ensure you comply with the law.

[Firchild]

@thepvporg At what point do I suggest that Access is used to hold sensitive data? This is designed for schoolkids to produce a project.

[thepvporg]

@Firchild. You have to make it known that a username and password is not secure in Access, the method you suggest is not secure, its easily compromised. So understanding risks and why code is risky or wares and the pit falls. Login in is useful for identifying users inserting data and filtering in some scenarios.

Nice vids BTW, you get to the point and no "Oh I have to mention at this point that.. or I think its important at this point to.." type comments, you know rhymes with Bull & Hooks..

[Firchild]

@thepvporg Hate to be a stick in the mud.. But this is designed to show code. At no point do I suggest that this is an uncircumventable method.. If I were to attach caveats to my videos, they'd be a lot longer and less focused.. By all means, post a video of your own highlighting the implications of storing data, and the focus of the Data Protection Act, and I'll post a link to it at the end of this video.

[thepvporg]

@Firchild, No but the fact that your tutorial is a password and username interface, implies that you can Secure the database when you can't. The most robust applications made using Access are easily broken. Even hiding the password table won't help. I know this because I wrote a background authentication module for VBA to passively track users by the machine name and user login name from the computer system via an API. No login meant no access, as user has to exist on a network (Authenticated)

[torosyan]

@thepvporg in terms of my ICT A2 coursework this is perfect and exactly what i was looking for.

although you do have a fair point. but i think this video is targeted for those who are in a situation like me, or small businesses where sensitive data is not stored.

[Ejo85]

Hi Firchild! Your videos are just great.

I had one problem when it came to the login button, the field names were correct and so was the code but when i pressed login (your validate button) nothing happened.

My solution was to select "enable this content" in the security warning that is visible under the menu bar when you first open up the database.It works!

Thanks!

[JT09AFC]

Hello wonder if you can help me... i think your video is great, i've follwed all the steps and im at the same stage. Just wondering if you know how to make it so that when the user types the password.. then it is hidden e.g. ***** ? would be great if you could help. Thanks in advance.

[RLiz08]

nice vid...i have a problem in my log in form...i want that when the user types the username and password incorrectly 3 times, the program ends. can anyone help me?

[theanon111]

@RLiz08 try this..

Option Compare Database

Private intLogonAttempts As Integer

Private Sub cmdLogin_Click() intLogonAttempts = intLogonAttempts + 1 If intLogonAttempts > 3 Then MsgBox "You do not have access to this database. Please contact your system administrator.", vbCritical, "Restricted Access!" Application.Quit End If

End Sub

hope this works

[so2murad]

Hi. I have a problem when I'm running Validate it gives a message stating Expression entered in properties field causes error: Expected: identifier

Could anybody help me ?

[MrShoNuff71]

I'm getting a compile error "method or data member not found" in access 2007 with this code .SetFocus is highlighted in VB. I'm trying to create a log in screen without having to create a table.

[fe207zman3]

is it possible to create a register button where once you register a username and password it will automatically appear in the code and then accept it??

[JeleJov]

OK, after another hour of fiddling with Access 2007, I found out what the problem was. In "Trust Center Settings" I selected "Never show information about blocked content" which for some reason disabled the code for login to work properly. Now that I put it back to show message about blocked content, it is working as it should.

[Firchild]

@JeleJov THANK YOU! Now this is what I've been talking about, you're the kind of viewer I like! Rather than whine about a problem, you've gone off, found a solution and posted it. Thank you to you and all of your ilk! I REALLY appreciate your input!

[huytranasd]

@JeleJov Thanks you so much. I stuck in this problem in hours too.

[WiresAnSteel]

Hey da iawn ti Diolch

-good job, thx for explainin so simply.

[narutarddd04]

Nice tutorial dude. But, I keep on getting this error Run-time error '424': Object required where do you get that DoCmd in this code DoCmd.Close DoCmd.OpenForm "F_Switchboard" in your validate button I think that's where my problem is I though that was the Password Form? and your password form i think is still not saved at that point 3:16 Thanks for your reply,

[PIZZLEPIZZLEPOWPOW]

just a question. whats the point of a login form when the form you are login in to view is still accessible under tables. how do you get rid of the form you made a login form for. so that you have to log in to view it.? if that makes sense

[Firchild]

@PIZZLEPIZZLEPOWPOW If you look at the videos that I did that hid the forms, it would make sense, these videos are part of a series

[phpacademy]

I remember doing this at school! Great tutorial...

[telmuun1221]

hi i`m using access 2007 and when i click validate nothing happens,, pls help me thats really important :(

[marianalivinglife]

Hi Firchild.

is it possible to have this programming: when you open your database, the opening will be a presentation that says the login and password and then welcome to write your databases???? i want to open my file and when i say yes to open my file, i want nothing in the access desktop than only my form login.. is it possible?

[SuperJoosh]

thank you so much! I was stuck on getting this right for a while, the thing I had wrong was i didn't change the text box name from unbound to "username" and "password".. it all works now. thank you!

[aaronr367]

could i tell me please how to make a form open up on opening the database

a quick reply would be much appreciated thank you

by the way this tutorial inparticular helped me alot thank you

[Firchild]

@aaronr367 It's already in the videos mate

[franceskakills]

@Firchild which video? sorry

[Ahmadkhanize]

@aaronr367 , ur comments starts from something funny : Can i tell me" , lol...and tnx ms firchild for ur tutorials

[peteschofielduk]

This is so helpful, I've been trying to make sense of access, queries and sql for ages.

Thank you so much for posting these.

[laynejef]

you are the best teacher in youtube!!!!!

[ZHJ1988]

Brill

Thanks alot..

[bizzyb2068]

The password is still visible when viewing the VBA code. Any way around this?

Converting to ACCDE doesn't allow the form to acces the code.

[neilcstocks]

bizzyb2068, if you are familiar with the DAO object in VBA, then what you can do is create a table that stores your Usernames and passwords. Make sure that your password field's input mask is set to password. Then use VBA search the table for the username and if it finds a match then have it check to see if the password field matches password text box. I have used this method a few times and it works beautifully. Of course that is the plain way, I use additional methods to make it more secure.

[Carliboy21]

does it work with iMac

[Firchild]

Dunno, never tried running access on an iMac, why don't you try it and let me know? If you're running Windows/Office thru Parallels or Boot camp then yes, it'll work

[tomaselvis]

I get:

"This error occurs when an event has failed to run because Microsoft Office Access cannot evaluate the location of the logic for the event. For example, if the OnOpen property of a form is set to =[Field], this error occurs because Access expects a macro or event name to run when the event is fired."

I have checked everything 10 times!

I have a swedish access 2003. :-(

[Firchild]

You'll have to reinstall Access i think, sounds like there's a chunk missing or corrupted

[Firchild]

OR.. New info.. A new instance of access has corrupted a previous one (I installed 2010 recently, and a lot of the functionality of 2003 has been ripped out)

[dethklok1989]

whats the login for?

like which database?

[Firchild]

It doesn't matter which database it's for, It'll work on any db

[dewi20]

cheers!

[Parts44]

hey is it xactly the same if ur using access 2007

and thx for the vid

[66911972]

Hi

Thanks for your videos! I did manage to learn quite alot from your videos.Thanks again! But is it possible that u touch a bit on the Option group function in Access. Coz right now, im kinda stuck at that function. Lets take an example, I have 2 options 'Yes' and 'No'. When I click on the'Yes' option, the word 'Yes' does not appear in the table in Access. What should i do?

[Remission101]

Hi Firchild. I am using Access 2007 and the code you provided does not seem to be working. I followed all your instructions and yet everytime I click on "Validate" nothing happens. What should I do?

[Firchild]

It works with Access 2003 and 2007. All my students have this working on 2007 fine.. Maybe you have it misconfigured or a dicky copy?

[muslimrao]

Should we use SQL on backhand. if yes.. then how ... please do let us know !

- thnks for your such efforts. GOD BLES YOU

[Firchild]

SQL on backhand...

Umm, err, I know what SQL is, but what's a backhand?

[Firchild]

Do you mean backend? If so, you really shouldn't be using access as an interface with mySQL or SQL Server. I'd use good old VB, not VBA via access

[mheadstate21]

Great tutorial 1 question how would i do multiple users? like sallys name and specific password. Joes name specific password etc. Also i would like to use a listbox to chose a name from and type password can u help?

[Firchild]

Check out 2.27

[nag20in]

hi..

i am a new user to the world of Access, you made my life soo easiy to learn access.. tons of thanks..my friend, very nice videos with great pase... i love them.. you rock

[merciless6000]

thnx, ur video really helped me with puttin password protection on my database

[merciless6000]

thnx ur video really helped me when puttin on password protection on my database

[keezysg]

awesome! really helped me with what i was doing.

ONE FLAW. that i figured out.

if you open it as AutoExec.. you can press F11 and it shows everything anyway!

any ideas around this?

[Firchild]

Database password?

[landforce123]

Very well done firchild, a bit fast for new comers like me to the world of Macrosoft Acccess.

[khapena]

Wow!!!...Firchild, you read my mind, I wanted to know how to protect my forms using username and password using asterists mask.

Thank you