Results 1 to 5 of 5
  1. #1
    r0v3rT3N is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    10

    Question Another Search Filter Question

    Hello again,
    I am in need of more help.
    This time, I have categories with the name of "Customer ID" , "First Name" , "Last Name" , "Age" , "Date Of Birth" , "E-Mail Address" , "Yearly Income", and "City".
    I am trying to make a search bar, (From a text box named "txtSearchCustomers") and then click a button to actually search. (The button on click event is where I am placing this code.

    These are the 2 types of code I tried.
    Code:
        
        Me.Filter = "[Customer ID] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)    Me.Filter = "[First Name] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)
        Me.Filter = "[Last Name] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)
        Me.Filter = "[Age] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)
        Me.Filter = "[Date Of Birth] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)
        Me.Filter = "[E-Mail Address] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)
        Me.Filter = "[Yearly Income] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)
        Me.Filter = "[City] = " + Chr(34) + Me.txtSearchCustomers + Chr(34)   
        Me.FilterOn = True
    and

    Code:
        Me.Filter = "[Customer ID] OR [First Name] OR [Last Name] OR [Age] OR [Date of Birth] OR [E-Mail Address] OR [Yearly Income] OR [City]" +     Chr(34) + Me.txtSearchCustomers + Chr(34)   
        Me.FilterOn = True
    Any help is appreciated.

  2. #2
    r0v3rT3N is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    10
    An answer before 2:30 would be much appreciated.
    Thanks,
    rT

  3. #3
    r0v3rT3N is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    10
    Anything?
    Only have 21 minutes.

  4. #4
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    Quote Originally Posted by r0v3rT3N View Post
    Anything?
    Only have 21 minutes.
    Really? lol

  5. #5
    r0v3rT3N is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    10
    Quote Originally Posted by redbull View Post
    Really? lol
    Yes, last week I was able to get an immediate response with an answer.

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

Similar Threads

  1. Filter Form by search
    By DCV0204 in forum Forms
    Replies: 2
    Last Post: 02-09-2012, 10:29 AM
  2. Replies: 2
    Last Post: 07-29-2011, 07:46 PM
  3. How to filter/search using a forum?
    By MediaCo in forum Access
    Replies: 3
    Last Post: 07-04-2011, 03:30 AM
  4. Query filter search
    By mseeker22 in forum Queries
    Replies: 6
    Last Post: 06-22-2011, 03:35 PM
  5. Database Search filter
    By dada in forum Programming
    Replies: 7
    Last Post: 08-19-2010, 12:42 AM

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