Search results for query: *

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

Thanks Pampers that worked Great.

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?

Thanks gmmastros. That worked great!!!

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

OK thanks I think that will work.

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

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

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

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?

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

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

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

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?

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

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

I tried this and does not seem to work for my searching of a Checkbox. Do you have any other ideas?

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