How To Connect Excel to Access for Dynamic Reports

[@kennethwdc]

This is just what I needed. Well thought out video presentation. The right mix of typing out code and using code that you've already typed, as well as including trial and error.

[@advantageapplications5712]

Thanks, my friend and thanks for checking out my video!

[@RandalSullivan-n4b]

Great video and interesting way to easily enhance the analysis of data.

[@advantageapplications5712]

Thanks for the positive feedback, Randal... Much appreciated my friend.

[@TheRealWillM]

Thanks so much, very timely video as it so happens

[@advantageapplications5712]

Thanks so much for watching, I'm glad it was useful!

[@nibgrahi5651]

Taking query filter conditions from a Form can be done by simply putting form object names in the criteria in query design view. So why this VBA approach? Any specific advantage?

[@advantageapplications5712]

Great question, and you are correct... if we just wanted to run the query and pass it parameters from the form, we could reference the form's controls right in the query. But, for this use case... needing to open an Excel workbook that pulls data from the query that it is linked to, we need to change the query definition itself, otherwise the Excel data doesn't reflect what the user specified in the parameters form.
I hope that makes sense and thanks for checking out my video!!

[@bumpersmith]

Why didn't you use late binding if this is to be distributed?

[@advantageapplications5712]

Hey, thanks for watching! I like to use early binding (when I can) to get the benefit of intellisense.

[@bumpersmith]

@@advantageapplications5712 Ok, I agree but shouldn't it be late binding when done so when distributing the DB there will be no worries if the user is setup for early binding?