Working With Recordsets in VBA

All of the source files and code used in this video (and all of my videos) are available to members. To become a member of this channel, for less than the price of a cup of coffee, please visit the link below and click "Join":
buymeacoffee.c...
In this video I cover how to create a recordset in VBA using SQL SELECT statements, how to test for records, how to iterate through the records in a recordset and how to access field values in each record.
Please like and subscribe. If there is a particular topic you would like to see a video on please let me know.
www.AdvantageA...

[@bumpersmith]

Nice Job. I would like to see you create more Access VBA videos. You are very good at explaining the topic and speak clearly.

[@advantageapplications5712]

Thank you my friend. I'm going to dedicate a lot more time to this channel this year and add new content and tutorials. I hope you stick around.

[@GaganDeep-mj5hi]

Very nice. Please make some more videos.

[@advantageapplications5712]

Thanks so much for the kind encouragement, my friend! It's been a little slow going lately due to work obligations but more videos are certainly on their way. I just posted a pretty big one on migrating existing Access DBs to SharePoint and preserving the identity values in primary key fields. I hope it's useful. Take care!

[@DustyAnimations]

H I’m four years late but its a great tutorial well explained

[@advantageapplications5712]

Thank you for the kind feedback. I'm going to re-dedicate time to this channel this year and add more tutorials and content. I hope you stick around. Take care!

[@Jojosmith342]

All thumbs up to the greatest teacher. Already subscribed. Hope everyone else is doing the same. Thank you so much for your hard work and another valuable tutorials

[@advantageapplications5712]

Thank you my friend for that glowing feedback. It means a lot to me. I'm going to re-dedicate myself to adding content and tutorials to this channel this year. I hope you stick around. Take care!

[@KHBrainTV]

Please make More lesson you are great easy to understand

[@advantageapplications5712]

Thank you for the encouragement my friend. I plan to spend a lot of time on this channel this year and add more content and tutorials. I hope you stick around. Thanks!!

[@StetsonMgtSolutions]

Great project.....trying to use outlook on my computer and not finding a method to use what you have here. Can you elaborate further? update: As an experiment, I changed all the customer email addresses to one I use for testing and then fired the routine and I get the "all done", but no emails were sent, and the immediate window does not show what was done.

[@advantageapplications5712]

Hey! That's a great idea, I think I'll make a video very soon on how to send emails through Outlook via MS Access. It's interesting that your immediate window isn't showing the emails in it. I believe you are a channel member on Buy Me a Coffee, correct? If so, have you downloaded the source file I used in this video to confirm that it works on your computer and to compare your code with it?

[@StetsonMgtSolutions]

@@advantageapplications5712 Yes, I am a channel member, and I did use your code. I you do make a video on using outlook, that would be great. It is a daunting process currently. I am assuming that the current code will not use outlook as it stands. I am getting an "Error in Loading DLL" message when selecting Microsoft DAO 3.6object library