Search results

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...

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...

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...

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.

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.

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.

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.

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...

This is exactly what I was looking for. Thank you!!!!

Access 2007

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...

That would be nice if I knew how to do that.

I have a table with usernames and passwords. I put some random stuff in there. Then I made a form. Lost from there.

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

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?

Where do you put this code though?

Wonderful! I'll try to do that. Thanks!

Constructing the menu should be easy. They open the access file and click on the form corresponding to their unit. They know this by the form name. Maybe the best way would be to have a central database that collects the automated ID and then those go to another database for each unit which...

It's military so keeping their passwords to themselves shouldn't be an issue (hopefully :rolleyes:). The forms haven't changed in a good while. I'm just making them paper-less instead of paper-based so it will help out the office I'm working for greatly. They won't have to enter each data point...

It is about 50 departments that would each need their own form. Kind of a large organization. :o I will play with that though and see if I can get it to work.