Search results

  1. E

    Message Boxes

    This is virtually the same problem I was having before.. I want a message box to appear if a quantity entered is lower than a specified value. I am using....... If textbox = ????? Then If textbox2 < 10 Then MsgBox(????????[,vbOKOnly]) End If End If Someone please tell me what I'm doing wrong...
  2. E

    Validation Rules

    I want to know if it is possible to set a validation rule to pick up values from a differnt table. For example I have a table of minimum order quantities and I am setting up a new table with the same field, but if a lower quantity is entered I want a message box to appear asking for a higher...
  3. E

    Open Form to Maximum

    I am trying to set my form to open to full screen size, but every time I try it won't work. I think i'm missing something simple, but it is driving me mad..
  4. E

    EMERGENCY PLS!!!

    I have no idea why this has happened, but I was working on a form, the screen crashed and now all of my VBA codes for command buttons etc have disappeared and everytime I try to redo them I get a message box saying Module not found. PLEASE HELP!!!
  5. E

    More Help with Check Boxes Pls

    I have set up a form with check boxes in when I select them and close the form, they are not still selected the next time I open the same form. Why?????
  6. E

    Multi-select with check Boxes

    This is probably quite easy but it is driving me mad!!! How do I set the properties of an option group to allow me to select more than one check box??? I don't want to store the info anywhere else only to view it on screen or run a report from it. Please Help!!!!!!!!!
  7. E

    Linking 2 forms

    I have set up a subform with a command button to open a 'notes' form. I want it to only pick up data which is linked to the main forms record. I have set up a relationship between 2 matching fields but it still shows all records rather than just 1 specific one. Help!!
  8. E

    Viewing specific data when opening a form

    I have set up a command button to open a form showing specific data to display. After typing in text and returning to the previous form the text is not saved. WHY???
  9. E

    Forms????

    I have set up a database with a subform, on the subform I have put on a cmdbutton to open another form - which is fine. But after I have entered text into the opened form & gone back to the main screen the text I have just entered is lost. WHY???? Also on the same forms I have asked the...
  10. E

    Viewing Locked Records

    I have set my form properties 'allow no deletions/additions' But my subform now will not show any data (the fields do not appear at all!) WHY??
  11. E

    Edit/Data Entry

    I have set the properties on a form to 'yes' on the data entry option, but I want to be able to edit other records in the same form.
Top Bottom