Understanding Recordsets in Microsoft Access VBA - a Beginner's Guide

[@Shadow.Dragon]

Great video, Richard! I've used recordsets for years, but it never hurt to review in case new functionality is added (or old functionality is forgotten by us "senior" developers LOL!!!).

[@599CD]

Very true!

[@xavierbatlle1828]

I always check if the recordset is nothing or not before closing it. This is useful when there are error handling sentences. 😊

[@599CD]

Good tip

[@fontie38]

Finally. Honestly, the recordset video tutorial i learned from was yours. That was ages ago😆. Thank you so much

[@599CD]

Yeah I've had an older video on the website for years but it was in need of a rerecord

[@Jojosmith342]

all thumbs up as always to the best teacher Richard. thanks Richard for another valuable lesson

[@599CD]

My pleasure!

[@simonmaersk]

Hi Richard. Thank you for the content. I actually have something similar to this, where I send out mass-emails. Instead of sending individual emails in a loop, I build a string with all the email addresses separated by a semicolon. Then, I just add them all to the email as BCC recipients.

[@599CD]

Yeah that's one way to do it

[@rajeshmajumdar4999]

Thanks Rick!

[@599CD]

Welcome

[@accessdevelopingzone7603]

Hello Richard, I've watched a video to learn about Recordsets and email sending. Is it feasible to use SendGrid's service for API-based email sending?

[@599CD]

Yeah, I'm sure it's possible, but I've never used it. I do use SendGrid, but I use their basic SMTP service. I haven't tried using their API yet. I did set up an API for their SMS service just for a test video, but it's not something that I use on a regular basis.

[@sushilgoyal2991]

I have data base in MS Access and when I close it on "Google drive" then the waring shows every time "the compact and repair operation has been cancelled. You might not have adequate permission to the folder that the data is located in. you need full permission to the director the database is located to compact and repair. contact your system administrator for more information." How we can resolve this issue.

[@599CD]

DO. NOT. RUN. ACCESS. FROM. CLOUD. STORAGE. DRIVES. 599cd.com/AO

[@alializadeh8195]

Thanks

[@599CD]

Welcome