Access Tribulations

[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.

 

[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*');

 

[dsc]

Thanks. Hope I can make it work. Need some study.