Recent content by Cpar

lol because its me and one other user. I promise we wont be nervous. I just want my format to not stay the same through all of my records.

I have had this trouble in the past, but i just added a lot of new code to my form. I am having trouble with the format of my form staying the same from each record. Meaning i type data into one form (Some of which has code to make fields move around my form). Then when i switch to the next form...

Bob fitz you asked me "What happens if you copy your code to the forms on current event". In which i replied with Post 19. If you re read it it goes something like this. When i put the code in my "on current" event it asks for my password when i open the form. I do not want this to happen. That...

If i put this Dim Mypassword Mypassword = InputBox("Enter Password", ("Password")) If Mypassword = "12345" Then Me.Sig.Visible = True Else Me.Sig.Visible = False End If Into my form "on current" event it asks me for a password right when the form opens. I do not want this to happen. I want to...

Anyone help me?

Yes i can try and describe better. Once again sorry. I am trying to make a button on my form that when clicked it will ask for a password. If the password is correct it will then show a picture. If the password is not correct it will not show the picture. So i have a button with this code in it...

Sorry if i am being confusing. I have this code in my "on click" button. Private Sub Command1502_Click() Dim Mypassword Mypassword = InputBox("Enter Password", ("Password")) If Mypassword = "12345" Then Me.Sig.Visible = True Else Me.Sig.Visible = False End If End Sub I now need to write some...

Any idea on how to convert the code? to make it work with the "on current"

Yes. I guess my question is idk how to code it into the "on current" section

I have the code in the button on click event.

Ok i tried reading through the debugging tips. Tried pressing F8. Idk why but its not working for me. All i know is when i put Dim Mypassword Mypassword = InputBox("Enter Password", ("Password")) If Mypassword = "12345" Then Me.Sig.Visible = True Else Me.Sig.Visible = False End If In the "on...

Sorry im not sure what step through my code means? If i just take out the Private Sub Check1503_Click() part every time i open my form it asks me for the password. I do not want that. I want to have to click the button. If i leave Private Sub Check1503_Click() as part of the code under the "on...

Hey guys i put a password on a button but i am having trouble with one part. See i need to put the code in my form "on current" and "after update". If you guys could help me revise this code that would be awesome. Here it is. Private Sub Check1503_Click() Dim Mypassword Mypassword =...

What i really want (and i think you can do this) is when someone logs in to their computer they have their own perms in Access.

Arnelgp can you give me an example on how to check my password with code? I am not understanding.