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

    Search Query sql code

    i added bound text boxes for all the fields i am searching for, however it is only showing one line at a time, and i can scroll through the filtered data, but its only showing one line. How can i get it to show the filtered data as in a spreadsheet view underneath the search.
  2. nico7

    Search Query sql code

    Record Source: SELECT [Master Table].ID, [Master Table].CreationDate, [Master Table].[Part Number], [Master Table].[Defect Code 1], [Master Table].[Quantity Defective 1], [Master Table].[Defect Code 2], [Master Table].[Quantity Defective 2], [Master Table].[Quantity Defective 3], [Master...
  3. nico7

    Search Query sql code

    i put the date range and the search button in the header of the form. i tried searching and i am still not getting anything to pop-up and show me the filtered data. however, it seems like the form is filtering my master table, just not showing the results
  4. nico7

    Search Query sql code

    can i link my form with my master table without any code? i went into the forms record source and choose all the fields in my master table. and tried to search. it looks like the form is doing the search and i can see on the bottom of my form it says how many rows the form matched. but i cant...
  5. nico7

    Search Query sql code

    where do i find the form's record source?
  6. nico7

    Search Query sql code

    i want to use my search form to filter my data. however i was having problems earlier with my search form, it kept asking me to enter parameter values for the associates, and wasnt sure why, so i looked into this search query and i realized that the associates were not included, now after i...
  7. nico7

    Search Query sql code

    i dont have any problems with my vba code, i just put it there for reference. im 100% sure that my vba code is correct. i just need some help to form my sql code for my search query, that this search form is based on
  8. nico7

    Search Query sql code

    i have a search form that has a vba code completed. however this search form is based on a search query and in order for the search form to filter my master table, i have to get the sql code in my search query correct. i am having problems with constructing the sql code. the following is my vba...

Part and Inventory Search

Back
Top