Access Tribulations

D

dsc

I can open and work with an Access database from a Word macro, but what I
need to do now is search a table with the same functionality as the Access
"Find: Match: Any part of field" functionality.

I've never worked with Access queries, so I don't know if that's the way to
go. Can you pass variables to a query?

Any assistance appreciated.
 
J

Jezebel

You surely can. Check help on wildcards in SQL queries. The wildcard
character is * or % depending on whether you're using DAO or ADO. Your query
might be something like:

SELECT * FROM MyTable WHERE (Name like '*ates*');
 
Top