Search results

awesome, I just need to fine tune things. Its working great thanks for the help

ok that does lock it down but how does 1 start a new record?

ok that did the trick for entering a complete record. Now how do I keep someone from changing 1 after there entered? jon

Private Sub Form_BeforeUpdate(Cancel As Integer) If (Not Nz(Me.description) <> "") Or (Not Nz(Me.serialnumber) <> "") Or (Not Nz(Me.revlevel) <> "") Then MsgBox "You must enter the serial number and the rev of the part being replaced. If the part does not have either one or both...

ok so I have the valaditation code on the before update but the subform still allow me to start a new record before completing the 1st record. How do I prevent this?

I have a subform with 4 fields, it is setup as a continous form. I want to make sure that all 4 fields have data before going to the next record. I also want to make sure once the record is entered it can not be edited. So I added a footer with a command button (save) that I have code to check...

ya that was it I had it pointing the the field partnumber when it should have been ComboPN thank you

I have a combo box and I'm trying to get a second field filled in based of the selection using column 2. I get an error on column when the code runs any ideas? Me.[description] = Me.[PartNumber].Column(1)

ok I got it figured out. Apperantly if you are using conditional formatting you have to disable it there as well. If you don't then you can still access the text even when you have the field setup correctly

even doing that the user can still click on the textbox and copy the txt. I has a bunch of txt fields and I want them locked so aused can not click on them or be able to select all the txt and copy it

I have done this before and can't remember how I did it and I can't fogure out how to do it. I have a form with txtboxes that are for displaying info to the users. I want to lock them so that users can not click on them or high light the fields. So basically the user can only click on fields I...

So on a command button I have this code in the OnClick event When I click the button it will ask me to enter the name if blank but if I enter something in that field and then delete the data is bypasses this. Does the same the the reason field, Why? jon {CODE} If IsNull(Me.CE) Then...

Is there a way to setup the format on fields to only allow text inputs, no numbers wanted. I know I can do this at the table level but is some cases numbers are ok. So I want to code it so I can control when numbers are ok and when there not. jon

I have a form that several fields and I had a user show me this issue that I was not awear of this morning. He opened the form and started adding data to it. Them he right clicked on the form and there are some options equals, does not equal and he selects and of the choices and my whole form...

this is what I'm trying to achive. If IsNull(Me.[oldoffset1]) Or (Me.[oldoffset2]) Or (Me.[oldoffset3]) Or (Me.[oldoffset4]) Or (Me.[oldoffset5]) Or (Me.[oldoffset6]) Or (Me.[oldoffset7]) Then jon

Right now on a form I have code that runs when the used DoubleClick on that field. Users want to have the code run when the EnterKey is pressed as well but when putting the code in the onEnter command line it would run the code when you tab thru the field. jon

found an If statement that was pointing to the value of a Yes/No field. Apperantly you can't use yes. I changed to the 1 / 0 and it works like a champ.

Awesome works, could you be so kind and explain the and left to me? jim

Wait a sec. I need to catch the field if its not null and if its already 1- something. So let say step5 currently = JD and the code runs it will make step 5 = 1- JD and if it runs a second time then step5 will = 1- 1- JD and if it runs a 3rd etc etc etc every time it runs it will put a 1- in...

Sorry I need to change it if it is not null so if step 5 has initials JD and my code runs it puts the 1- JD in the field if it runs again it puts 1- 1- JD in the field. So if it's null it put nothing. So I know I can put another If statement but I was hoping for something simpler