Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: laruajo
  • Content: Threads
  • Order by date
  1. laruajo

    Searching for a record

    I have a form that is based on a query with a 5 digit number as the primary key. I would like to be able to search for a specific record based on that number in the form. Here is a little background, when the form is opened it prompts for the password then for the first number they wish to...
  2. laruajo

    Check for record, if exists fill in, if not leave form blank

    Let me see if I can explain this clearly. I have a form that has a multiple field primary key-SONum and IRRNum- one SONum can have a couple IRRNums, each record containing different data. What I would like the form to do is: when a user goes in and types in a SONum in the field, if it already...
  3. laruajo

    ctrl alt del, prevent this from closing form

    I have placed code on the Unload event of a form to check if certain fields have data in them (once the user has started entering in data), if not the form will not close. However, I have realized that ctrl alt del, allows them to close the form with only half the data in it. This is causing...
  4. laruajo

    Trouble setting up relationships

    I am having trouble setting up the relationships in my database correctly and looking for any help that anyone can provide. Here are my tables (some tables have many fields so I will only list the primary key which is the only similary field in the tables, if you need more info just ask) Table...
  5. laruajo

    The form automatically fills in when value entered in one field

    The way my form is set up now, it is bases off a query that prompts the user for a SO Num. If the number exists the form opens displays the first record with that SO Num and they can flip through all other records with that number. If the SO Num does not exist the form opens blank and they can...
  6. laruajo

    close two forms

    I have a form that data is entered in, a button is then pressed to accept the data and take the users to another form where they receive a number. When the users either press the button on the first form to accept the data and go to the other form, or press the close button on the second form...
  7. laruajo

    stop form from closing

    There is something I have been trying to figure out for quite sometime that could solve several problems I am having with my database. My question is, Is there anyway to prevent a form from closing when the 'X' button is pressed. I have code on the Before_Update() event of the form that 1...

Part and Inventory Search

Back
Top