Results 1 to 8 of 8
  1. #1
    tommy93 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    36

    Query for user to filter by every field

    Hello,


    Im currently creating a database that the user needs to filter through several fields for certain criteria.

    For example, the table in question has "Customer" field, "Shipping to" field, "Shipping date" field, and "Shipping line".
    One day he may need to find a customer that is shipping to.. lets say america. Another day he may need to see what locations are being shipped to via a certain shipping line.

    How would i go about doing this in an access 2010 form?

    Thanks.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    See this free video tutorial for ideas.
    http://www.datapigtechnologies.com/f...earchform.html

  3. #3
    tommy93 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    36
    Quote Originally Posted by orange View Post
    See this free video tutorial for ideas.
    http://www.datapigtechnologies.com/f...earchform.html
    Thank you, that looks like it should do it. As long as it still works in Access 2010 haha.

  4. #4
    tommy93 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    36
    Quote Originally Posted by tommy93 View Post
    Thank you, that looks like it should do it. As long as it still works in Access 2010 haha.
    Ok that doesnt seem to work on Office 2010, or atleast i cant get it to work for some reason, any help?

  5. #5
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    What doesn't work. What results are you getting. Help us to help you by telling us what you did and what happened. Is there something in the video that you don't understand? Help us help you with specific responses -- otherwise we are just in a guessing game.

  6. #6
    tommy93 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    36
    Quote Originally Posted by alansidman View Post
    What doesn't work. What results are you getting. Help us to help you by telling us what you did and what happened. Is there something in the video that you don't understand? Help us help you with specific responses -- otherwise we are just in a guessing game.
    Ok, followed that video he sent me down to a T.
    Indexed the fields i will be searching through, completed the form and the query as shown. But, when running the query through the form, it doesn't return any records at all?

  7. #7
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Ok. Suggest you upload a copy of your data base with sample data. Let us look and see what is happening. Make sure to run a compact and repair before you upload and also remove any confidential information. We only need sample data.

  8. #8
    tommy93 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    36
    Ok, had to upload it into a zip file.

    The form and query in question are both named "search". The query is meant to search through the jobs table for the information required, based on what the
    user types in the search form.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 09-22-2011, 03:35 PM
  2. Replies: 1
    Last Post: 08-13-2011, 04:44 AM
  3. Replies: 1
    Last Post: 08-25-2010, 09:43 AM
  4. Replies: 8
    Last Post: 06-30-2010, 10:57 PM
  5. Replies: 5
    Last Post: 08-05-2009, 12:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums