Results 1 to 3 of 3
  1. #1
    banker is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    2

    Search box not working


    I am using Access 2010 and have downloaded a standard contacts database but I have found that the standard search function at the bottom of the form is not allowing me to find mobile phone numbers in my records. It allows me to search for the first 7 numbers and then stops. We have a large number of sequential mobile numbers allocated to people and the first 7 numbers are the same for a number of people however the last 3 numbers determine who has which phone. I need it to search for 10 numbers. I am in Australia and I am a novice user. Any help would be great. Thanks.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    You are using the intrinsic search control on the navigation bar at bottom of form? You say the search is limited to the first 7 characters of the phone number? I tested that on other strings and not limited to 7 characters.

    How is the phone number stored in table? Does it include punctuation such as parentheses and hyphens? Are you including those characters in the search?

    Want to provide db for analysis or the link to the template?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    banker is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    2
    Hi June7,

    I think I now know the problem thanks to your prompting below. There are spaces separating the sequence of numbers on the numbers tested. When I include the spaces the search works. All good and thanks for the prompt response.

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

Similar Threads

  1. Combo Box search not working
    By Lowell in forum Forms
    Replies: 1
    Last Post: 06-02-2012, 12:53 AM
  2. Replies: 5
    Last Post: 04-06-2012, 11:06 AM
  3. Search Button in a Form not Working
    By spideynok in forum Forms
    Replies: 30
    Last Post: 03-29-2012, 01:10 AM
  4. Access 2010 - search query not working
    By beetgirl in forum Access
    Replies: 6
    Last Post: 07-12-2011, 09:56 PM
  5. Search field is not working correctly
    By jakeao in forum Programming
    Replies: 9
    Last Post: 05-18-2009, 07:47 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