Search results

  1. J

    having trouble with a subform

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

    having trouble with a subform

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

    having trouble with a subform

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

    having trouble with a subform

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

    having trouble with a subform

    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?
  6. J

    having trouble with a subform

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

    need help updating a field based off a selecton in a combo box

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

    need help updating a field based off a selecton in a combo box

    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)
  9. J

    Having a problem locking a form

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

    Having a problem locking a form

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

    Having a problem locking a form

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

    Have an issue with code checking for Null data.

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

    setting a Field on form to only allow text input

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

    I have a right click problem

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

    Can you use OR in an IF statement?

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

    Can I run code in a field when the enter key is pressed?

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

    Need help with a sub form. Linking issue

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

    Vba code question

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

    Vba code question

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

    Vba code question

    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
Back
Top Bottom