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 derfloh 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: elevins
  • Content: Threads
  • Order by date
  1. elevins

    Validation for Control Box on Form

    I am trying to use a data validation for a control text box [ItemCodeEnter]. When users are entering data I would like this control box to check the table.field [Inventory.ItemCode] before allowing them continue. The idea is for them to type text but only be able to type the values that already...
  2. elevins

    OnClick I would like to go add record then go to First text box

    I have a form with 5 data entry text boxes and a add record button. After I click the 'Add Record' command button I would like it to add the record then go to the first text box. This will make it easier for the people doing data entry. Any sugestions?
  3. elevins

    Querying out Duplicates and Suming Total Values

    I have been trying to make a query in SQL, that would take out duplicates and then sum all the values. I am looking for some direction on how to approach this. Lets say I have three fields of data: Item Lot Quantity 111 SSS 100 111 SSS...
  4. elevins

    Looking to update a table?

    I have two tables: The fist table is a 'Software list' table, which has 3 fields; SoftwareID, Program, and Version. The second table is 'Software_ID',which I would like to have 2 feilds; ComputerNum and Software ID. Basically I have several computers and I want to keep a list of ALL software...
  5. elevins

    Query between date and time

    I am wanting to query between a start date & time and an end date & time. Lets say I wanted all records between 2:00AM on 05/15/2005 and 4:25AM on 05/16/2005. How would query this to get ALL records in the middle of those times?
  6. elevins

    Invalid Use of Null

    In a Dynamic Query I am using a button to run an event procedure. I have 3 check boxs that I would like to search and display 'if' the check box is selected. There will also be 9 text boxes and I would like to enter criteria and check box and have the query display a table with the correct...
  7. elevins

    Using Dynamic Query - Would Like to Search Check Box from table

    Can anyone help me? I am using Dynamic Query, it is run when a click a command button. All the text boxes are working fine but I would like to use check boxes to search also. I am having trouble finding any info on how to search using a check box. Here is an example of what code I am using...

Part and Inventory Search

Back
Top