Search results for query: *

i apologize about that, here is the complete master table details: ID: AutoNumber CreationDate: Date/Time Part Number: Number Defect Code 1: text Defect Code 2: text Defect Code 3: text Associate: text Associate 2: text hopefully this clears things up, please let me know if you need any more...

in design view of master table: creationdate = date/time part number = number defect code 1,2,3 = text associate 1,2 = text i am not sure why it is not working, it keeps asking me to enter the parameter values of the defect code and the associate, when it goes through that code...

i entered a defect code and an associate number into my search and used the debugging window, this is what i got: 1=1 And "12 - Assembly - Fails Drop Test" In([Defect Code 1], [Defect Code 2], [Defect Code 3]) 1=1 And "12 - Assembly - Fails Drop Test" In([Defect Code 1], [Defect Code 2]...

i do have these field names in my table, but i just tried the breakpoint debugging technique, and it only prompted for these values when i made the filter run through this code: Me.Filter = strFilter so im guessing there is something wrong with it

for the defect it asks to enter the parameter for defect code 3 for associate, it asks to enter for both associate and associate 2. however for the date, and product number, nothing seems to happen.

by the way should i explicitly format the date to always be in this form "m\/d\/yyyy". if so do i just add it after my code?

thank you Duane, but whenever i search using either the product number or the date range, nothing happens and i get no data. if i search using the associate, or the defect, i get a message asking me to enter a parameter value. i am not exactly sure why this is happening.

the defect code 1,2,3 and associate 1,2 are text. but the codes i have right now dont seem to be working, can i get some help on writing the codes for these two. thanks

i was thinking of having this search form at least require one of the search criteria to be filled out. so i guess if nothing is filled out, the search should return all my data. by the way, i am a little unsure about the codes for the defects and the associate, because i want the search to...

the fields i am using from my master table are: Part Number CreationDate Defect Code 1,2,3 Associate 1,2 and the combo boxes associate with these fields are: productnum date1-date2 Defect associateid respectively, and the search command button is cmdfindrecords. Option Compare Database Option...

hi, i have a master table with all my part information, and it has columns with part number, creationdate, defects,... and i am trying to write a code for my search form. i have created a search form on Access, and it has 5 combo boxes for: part number defects assembled by and the other 2 combo...