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

Поделиться
HTML-код
  • Опубликовано: 14 окт 2024

Комментарии •

  • @Shadow.Dragon
    @Shadow.Dragon 10 месяцев назад +3

    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
      @599CD  10 месяцев назад +1

      Very true!

  • @xavierbatlle1828
    @xavierbatlle1828 10 месяцев назад +1

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

    • @599CD
      @599CD  9 месяцев назад +1

      Good tip

  • @fontie38
    @fontie38 10 месяцев назад

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

    • @599CD
      @599CD  9 месяцев назад

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

  • @Jojosmith342
    @Jojosmith342 9 месяцев назад

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

    • @599CD
      @599CD  9 месяцев назад

      My pleasure!

  • @simonmaersk
    @simonmaersk 10 месяцев назад

    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
      @599CD  9 месяцев назад

      Yeah that's one way to do it

  • @rajeshmajumdar4999
    @rajeshmajumdar4999 10 месяцев назад +1

    Thanks Rick!

    • @599CD
      @599CD  10 месяцев назад +1

      Welcome

  • @accessdevelopingzone7603
    @accessdevelopingzone7603 10 месяцев назад

    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
      @599CD  9 месяцев назад

      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.

  • @alializadeh8195
    @alializadeh8195 10 месяцев назад

    Thanks

    • @599CD
      @599CD  10 месяцев назад

      Welcome

  • @sushilgoyal2991
    @sushilgoyal2991 9 месяцев назад

    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
      @599CD  8 месяцев назад

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