Results 1 to 8 of 8
  1. #1
    philip1101 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Aug 2019
    Posts
    5

    Multi search items in a form

    I'am a new user of access and thinking if it is possible to have an option for a multi search in a form in access. the scenario is this, I'am handling 20K+ records of our employees on my table and everytime i update my record i used v-look up and filter in excel manually. I'am using their passport no as the look up value to filter the records that i needed. because usually the emails comes in a bulk of records that i need to update. If there is like a copy and paste option in the access then will multi search will start.


    Please provide the codes that i needed. Thank you so much in advance
    Click image for larger version. 

Name:	Capture.JPG 
Views:	30 
Size:	103.2 KB 
ID:	39559

  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
    16,716
    I have approved your post so that members can read and reply.
    Welcome to the forum.

    For clarity, please give us a sample of your multi-search. A simple description of the logic involved (which record, what fields, update criteria..) would be helpful. If you could give an example with 1 or more of the records in your post, even better.
    An overview of the business involved can also help clarify the context.


    ?? What exactly does the Passport No. for Sr#5 means??
    Good luck.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    If you want to search for multiple passport numbers at one time, that does get complicated. Often involves selecting values in a multi-select listbox and VBA code builds filter criteria. Review http://allenbrowne.com/ser-50.html

    Another approach would involve putting the passport numbers you want to search for into a table then in query INNER JOIN that table to the data table you want to find records in. Only records that match will return in query.
    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.

  4. #4
    moke123's Avatar
    moke123 is online now Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    In SR# 5 in your graphic the passport # is divided with a "/". Does this indicate 2 passports?
    If so, you may want to adjust your tables so you can search easier for either/or passport #.

  5. #5
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    philip1101 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Aug 2019
    Posts
    5
    Hi @orange just ignore the passport no.5 it should be 1 passport no. I attached a screen shot that i drafted in form but unfortunately i dont know to execute this with codes

  7. #7
    philip1101 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Aug 2019
    Posts
    5
    @moke123 thanks for your reply just ignore the 2 passport in sr#5 it should be only 1

  8. #8
    philip1101 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Aug 2019
    Posts
    5
    Thanks @june7 its a big help i'll check the links that you shared

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

Similar Threads

  1. Help With Multi Field Search Form
    By icaines9517 in forum Forms
    Replies: 6
    Last Post: 08-02-2016, 10:01 AM
  2. Multi-field search form
    By rebeldolphin69 in forum Forms
    Replies: 2
    Last Post: 06-15-2016, 05:28 AM
  3. Replies: 8
    Last Post: 09-02-2015, 03:00 PM
  4. Multi Use Search Form
    By CharlesWilliams in forum Forms
    Replies: 4
    Last Post: 03-13-2015, 01:09 PM
  5. How to Search Fields from Multi-Tables Form?
    By Yeisha2008 in forum Queries
    Replies: 9
    Last Post: 07-19-2012, 11:41 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