Recent content by Epi
-
E
Password protecting multiple forms
Dude I will change that. This is just an EXAMPLE of what I will actually use. EXAMPLE meaning that password is not the actual password I will use. The forms will be hidden. They will have to open the password form for their own department and enter the unique password upon which the macro... -
E
Password protecting multiple forms
I used password as the password because it was on my EXAMPLE form. I went about it in a different way by using something similar to the following code: Private Sub Command0_Click() If Text3 = "Password" Then DoCmd.RunMacro "Macro1" Else: MsgBox ("Please Renter Correct Password"), vbOKOnly... -
E
Password protecting multiple forms
Alright I have a new idea. Instead of having that whole extra database attached to a form and what not. Can I just put a button on the form I'm protecting? It doesn't matter if anyone sees it, just if they enter data into it. I added a button and put in this code: Dim PassWord As String... -
E
Password protecting multiple forms
The on click event. UserID: Texas Aggies Sully Password: 12345 23456 34567 Unit: A B C Really you can use whatever you want. I just am doing an example access database/form so I can figure out what to do and implement it in the real database/form. -
E
Password protecting multiple forms
Alright new button that is just a button and I redid the coding back to where it was prior. Now I press the button after entering correct UserID/password combo and nothing happens. I think something is wrong with my code. -
E
Password protecting multiple forms
I need to use a toogle button right? And put that code in for that button? The other button just takes me to the form and isn't doing anything else so I assume I need the toogle button. When I do this it keeps going back to the code and saying syntax error. -
E
Password protecting multiple forms
Do I need to enter each UserID etc into the code? Is that what I'm doing wrong? Also the button on there that I made is programmed to go to hhform. None of the other button options seemed applicable. -
E
Password protecting multiple forms
Quick question though I did everything as directed but when I put in the code: Dim varunitnumber as integer If me.txtpassword = dlookup("[Password]","Users","[UserID]='"&me.txtusername & "'" then VarUnitNumber=dlookup("[Unit]","Users","[UserID]='"&me.txtusername & "'" Docmd.close acform... -
E
Password protecting multiple forms
This is exactly what I was looking for. Thank you!!!! -
E
Password protecting multiple forms
Yeah this will be on one server and there are way to many computers for me to mess with. Plus I have ZERO experience in this kind of coding. I know SAS and SPSS. I can make pretty forms in Access and also do databases with relationships, queries, importing/exporting etc. So when people say... -
E
Password protecting multiple forms
That would be nice if I knew how to do that. -
E
Password protecting multiple forms
I have a table with usernames and passwords. I put some random stuff in there. Then I made a form. Lost from there. -
E
Password protecting multiple forms
An identifier for the unit using it possibly. That would be the extent of it. http://www.databasedev.co.uk/login.html This is helping some but I have no idea where to put the codes and how to find the places to put the codes etc. :( This just keeps turning into a bigger and bigger headache -
E
Password protecting multiple forms
Guys I have no idea what the login button is....I need a little more detailed instructions. Is it the code builder thing? I've found that before. Okay created an example login form/database. Now what?