How to Create and Modify QueryDefs Programmatically in your MS Access Database

In this episode, we'll look at how to programmatically create and modify query definitions in Microsoft Access. Being able to create and (especially) modify QueryDefs in MS Access is a nice trick that makes the coding of your application easier, and more flexible. Sometimes it is just easier and faster to change a QueryDef on the fly in your code, so that your users have a better experience in your app.

Interested in transforming your career or finding your next gig?

Want my team to do a project for you? Let's get to it!

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

Demo of my BZ RDP Cloaker:

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

#msaccess #vba

[vladoz]

Do you have a video where the table name changes in a query definition? Say, the same query is used each year, but the table name contains the current year in its name.

[zoomingby]

FYI, any created querydef object (with a non-zero length name) is automatically appended to the querydefs collection.

[DataisKing]

I use QueryDefs to run SQL statements so that my database users can export from Excel by filtering dropdowns on forms