How to search a query in Access?

You can use VBA to search an Access database for a specific phrase.  This is useful if your database is quite large and you need to track something specific like a hard-coded reference. The following code allows you to search all the queries in a database project for a particular string. After identifying all the queries that contain the string, it prints them out to the Visual Basic Editor Immediate Window for your reference.

I hope you find it useful for your own projects!

Thank you for reading this post. Please take time to read the disclaimer about content found on this site.

Share :Facebooktwitterredditpinterestmail

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.