How to use VBA to search through a text box in a MS Access form for a list of names from a query?
I have text box in a form that contains a work log. I need code that will search through the work log for each name listed in the query until one is found or finds no matches.
Example work log:
01/18/17 10:20:05 - (AB00123456-002 - Move PC) (john.doe)
WIP to install seat
01/17/17 16:18:43 - (AB00123456-002 - Move Seat) (john.doe)
updating asset information
01/17/17 15:34:04 - (AB00123456-002 - Move Seat) (jane.doe2)
Cx emailed and appointment scheduled for 18 Jan @ 0940. Seat located in CTR's office. Cx located in bldg. 1111, cube 111. Assigned to john.doe
Example Table:
Max.young
John.smith
John.johnson
jane.doe2
Example work log:
01/18/17 10:20:05 - (AB00123456-002 - Move PC) (john.doe)
WIP to install seat
01/17/17 16:18:43 - (AB00123456-002 - Move Seat) (john.doe)
updating asset information
01/17/17 15:34:04 - (AB00123456-002 - Move Seat) (jane.doe2)
Cx emailed and appointment scheduled for 18 Jan @ 0940. Seat located in CTR's office. Cx located in bldg. 1111, cube 111. Assigned to john.doe
Example Table:
Max.young
John.smith
John.johnson
jane.doe2
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER