Results 1 to 11 of 11
  1. #1
    Phil H is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2019
    Location
    Phoenix, AZ
    Posts
    8

    Search for record

    I was into ACCESS heavily 8-10 years ago, then away from it, now back into it. I seem to recall there was a way to search for a record (like by a last name) by starting to type in the name, wherein the field would display the beginning letters of names from the table and allow you to select before the whole name was typed. I think there was a name for this, but I can't seem to remember it. I hope this triggers something. Sorry for lack of more specific verbiage.
    PhilH

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,557

  3. #3
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    186
    If that is not enough, then here is another one: Filter By character and Sort.
    http://www.msaccesstips.com (Learn MS-Access Tips and Tricks)
    Learn Advanced MS-Access Programming with examples and VBA.

  4. #4
    Phil H is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2019
    Location
    Phoenix, AZ
    Posts
    8
    Thanks to you both...this gives me something to work on...PhilH

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,557

  6. #6
    Phil H is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2019
    Location
    Phoenix, AZ
    Posts
    8
    I can't quite get this to work. In the Form Load event, if I enter:
    Call FindAsUTypeLoad([Me], "FirstName")
    I get a Run Time error 2465. It says "cant find '|1' in expression. There is no '|1' in the expression.
    If I leave off the field supression, and use the following in the Form Load event:
    Call FindAsUTypeLoad([Me])
    I get the same error as above.
    I've checked the Troubleshooting comments and don't see any problems, except for the fact that it says "you may need to add the DAO reference." I don't know exactly how to do that. Maybe you could help me out with that so I can try it.
    Thanks for your help, Phil H

  7. #7
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,557
    Phil,

    I suggest you post a copy of your database (zip format) so readers can see exactly what is happening.
    At least show us a graphic of your tables and a copy/paste of the code relevant to the situation.

  8. #8
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,309
    Maybe thinking to direct but why not just use a combo box based on FirstName, when they pull the list down and start typing it will do what you are asking I believe. Then when they select a name in the AfterUpdate Event property you can do something with it. Are you wanting to do fuzzy searches or multiple field searches?

  9. #9
    Phil H is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2019
    Location
    Phoenix, AZ
    Posts
    8
    I think Bulzie's suggestion below does what I'm looking for, but I would still like to try adding the DAO reference as suggested in the Find As U Type write-up. However, as I indicated, I just don't know how to do that. If it's a simple line to be added somewhere, maybe you could tell me what and where. If it's complicated, it's probably not worth the trouble. Anyway, thanks again for your help.
    Phil H

  10. #10
    Phil H is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2019
    Location
    Phoenix, AZ
    Posts
    8
    Yes, I think that does what I wanted. This is a good example of what we forget when we're away from something for an extended period. Some years ago I would have known this, but I'd forgotten this capability of combo boxes. Thanks for your help.
    Phil H

  11. #11
    Join Date
    Apr 2017
    Posts
    1,039
    I have feeling, this is you are looking for
    Attached Files Attached Files

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

Similar Threads

  1. Replies: 1
    Last Post: 02-28-2018, 01:02 PM
  2. Replies: 8
    Last Post: 07-23-2017, 02:04 PM
  3. Replies: 6
    Last Post: 02-02-2015, 02:14 PM
  4. Record Search??
    By stevio359 in forum Queries
    Replies: 9
    Last Post: 05-20-2011, 11:47 AM
  5. Record search
    By dhammikai in forum Forms
    Replies: 3
    Last Post: 04-05-2010, 10:19 AM

Tags for this Thread

Posting Permissions

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