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: *

  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

    Thanks Pampers that worked Great.
  3. 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?
  4. elevins

    Querying out Duplicates and Suming Total Values

    Thanks gmmastros. That worked great!!!
  5. 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...
  6. elevins

    Looking to update a table?

    OK thanks I think that will work.
  7. 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...
  8. elevins

    Query between date and time

    I think PHV that... "WHERE ((SenLog.Date + SenLog.Time) Between ([Start Date] + [Start Time]) And ([End Date] + [End Time]));" ...is on the right path but I am still not getting an output from it. I can put in values in correct spots and it will come up with zero results. My worry is that the...
  9. elevins

    Query between date and time

    This is what I had before in the SQL view of my query. SELECT SenLog.Date, SenLog.*, SenLog.Time FROM SenLog WHERE (((SenLog.Date) Between [Start Date] And [End Date]) AND ((SenLog.Time) Between [Start Time] And [End Time])); I am using these dates as an example I would like it to be able to...
  10. 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?
  11. elevins

    Invalid Use of Null

    Thanks PHV that was very helpful, I now have the option to make the checkbox false.
  12. elevins

    Invalid Use of Null

    OK.. I really appreciate you help. I tried that but am still having the same problem. Lets see if I can clarify my question. Again I have 3 check boxes and 8 text boxes on a form, along with a command button that runs an event procedure to search a table for content and displays that criteria...
  13. 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...
  14. elevins

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

    Once I check a box like "Stored" and then unckeck it It changes the Dynamic Query to False and stays that way until I close the Form. Is there a way to have it "clear" the check box after deselection?
  15. elevins

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

    Great! That helped out a lot. Thanks. Where = Where & " AND [Stored]=" & IIf(Me![Stored], "True", "False") As you can probably tell I am not great with this code but I am learning quickly. The problem now is that it only will work corectly for the feild "Stored". If I code the other fields...
  16. elevins

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

    Anybody's help would be much appreciated. This is the only problem I am stuck on with my database.
  17. elevins

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

    I tried this and does not seem to work for my searching of a Checkbox. Do you have any other ideas?
  18. 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