Search results

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.

Hi everyone. I made a data base with a form that a team of people will fill out. I would like to add perms or maybe a password to one field on my form. I am very lost on how to do this. Do i have to write VBA for it? or is it in the access program already. Thanks in advance.

I am having trouble with vba code for between. Such as if this box has a value within .11 and .25 then return "different control source" with "A". Like I said should be a simple enough question. I do not know why I can not get it. Thanks in advance

Hey guys first time posting in this section. I am wanting to move some fields to the center of my form depending on a combo box. The only thing i can find online is something along the line of me.right. I have no idea if this is correct or not. Some insight would be nice.

JHB i can see why you have been thanked over 1000 times. I will make sure to add another!

I mean I can't print with the options you gave me when I change the forms to reports. That was my problem is when I try and print they do not come out like they do on the screen. It works in the sample you gave me but not on my original document.