Multi search items in a form( copy paste from excel) (1 Viewer)

P

philip1101

New member

Local time

Today, 18:05

Joined

Aug 25, 2019

Messages

3

• Aug 25, 2019

• #1

Hi guys,

Basically iam working with the records of our employees aroung 20K+. I i designed a form but i don't know how to execute it. please find it on my attachment. most likely the records will come on a batch and i need to do some massive vlook up and pivot table in excel that hangs most of the time. By the way im a new user of access and starting to learn on it. please help me guys. the idea is like this i will get the passport no from an excel sheet and then i would like to paste it at once in to a search form then the search form will show those passport no that i paste.

 

Attachments

• 
  Capture.JPG

  86.8 KB · Views: 91

Ranman256

Well-known member

Local time

Today, 11:05

Joined

Apr 9, 2015

Messages

4,339

• Aug 25, 2019

• #2

Import the excel sheet to a work table. Only these names are in it.

Run a query that updates the 1 person (or all) to yes.
You can dbl-click 1 name in the list to run the query that changes it.

When done,run a query to add the names to the main table.

 

P

philip1101

New member

Local time

Today, 18:05

Joined

Aug 25, 2019

Messages

3

• Aug 25, 2019

• #3

Thanks for your reply, however is it possible to do a multi search in a FORM instead of running a query as what i attached in my post. sorry iam a noob in this program

 

isladogs

MVP / VIP

Local time

Today, 16:05

Joined

Jan 14, 2017

Messages

18,211

• Aug 25, 2019

• #4

Yes its certainly possible and in fact is the correct approach as end users should never have direct access to tables or queries
You still need to import your Excel file to an Access table (import NOT copy and paste)
Both the form and subform will use that table or a query based on it as their record source.
For an example search form see http://allenbrowne.com/ser-62.html
Another example of a form used to select records based on multiple filters http://www.mendipdatasystems.co.uk/multiple-group-filter/4594454290

 

Last edited: Aug 25, 2019

P

philip1101

New member

Local time

Today, 18:05

Joined

Aug 25, 2019

Messages

3

• Aug 25, 2019

• #5

it's a big help! Thank you so much mate, i'll just check and review it.

 

isladogs

MVP / VIP

Local time

Today, 16:05

Joined

Jan 14, 2017

Messages

18,211

• Aug 25, 2019

• #6

You're welcome. Come back if you have any questions

 

M

Micron

AWF VIP

Local time

Today, 11:05

Joined

Oct 20, 2018

Messages

3,478

• Aug 25, 2019

• #7

cross posted
https://www.accessforums.net/showthread.php?t=78084

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 08:05

Joined

Aug 30, 2003

Messages

36,124

• Aug 25, 2019

• #8

FYI, I moved your thread out of the introductions forum.