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: f430s
  • Order by date
  1. f430s

    search form coding

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

    search form coding

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

    search form coding

    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]...
  4. f430s

    search form coding

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

    search form coding

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

    search form coding

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

    search form coding

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

    search form coding

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

    search form coding

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

    search form coding

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

    search form coding

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

Part and Inventory Search

Back
Top