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

[@RobertTozzi]

@0:5:11 you refer to the field name without an equal sign (Status "First Name: " & rs!FirstName). When I do this on the current version of Access I get an error "Invalid Use of Property". But using an equal sign (Status = "First Name: " & rs!FirstName) causes only the last status entry to populate the textbox. Why would this be happening?

[@599CD]

Status is a custom subroutine that I wrote to display information in a text box on the main menu. The way that it is in the video is correct, and it has been that way for decades and has not changed. See 599cd.com/StatusBox.

[@diegkol]

First got an error the Record set does not work - needed to add Microsoft DAO 3.6 Object Library. Can I turn a Query's data into a recordset? And how?

[@599CD]

599cd.com/Ask

[@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.

[@rajeshmajumdar4999]

Thanks Rick!

[@599CD]

Welcome

[@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