If, Then, ElseIf, Else, End If - Conditional Statements in Microsoft Access VBA (Visual Basic)

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

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

  • @jaredwarner3972
    @jaredwarner3972 Год назад

    I built a database for my mother's business. I put in attachment fields because they sounded nice at the time (this was before I found your channel). Now I know why you say DO NOT USE ATTACHMENT FIELDS. It slows everything down. After watching this video I have made nice hyperlinks to folders to take the end user to the documents I previously had in the attachment fields. I am now really enjoying the database I have created. Thank you for making your videos. I wish I could afford to be a member

    • @599CD
      @599CD  Год назад

      Sounds great! Glad you like.

  • @moodkn
    @moodkn 2 года назад +1

    Thanks..!
    Excellent Exercise

    • @599CD
      @599CD  2 года назад

      Welcome. :)

  • @MARC1TIM
    @MARC1TIM Год назад

    @599cd Do you have any advice/vids on the With statement?

    • @599CD
      @599CD  Год назад +1

      This is one of those topics that I talk about in a lot of different videos but I don't have one specific video where I cover just that statement. It's on the list somewhere for its own video one of these days.

    • @MARC1TIM
      @MARC1TIM Год назад

      @@599CD I was just wondering your experience with it for declaring recordsets and other temp/one time objects.

  • @manalwaqas7249
    @manalwaqas7249 2 года назад

    what should i do if im asked to display a message asking the user if they want to view the query i created in one question :•if they do, the query i created in the Question should run •if they do not, the chart i created in another question should open.
    this is related to creating a button in a dashboard in the database where i have to use a MsgBox
    would be grateful if you reply 🙏🙏

    • @599CD
      @599CD  2 года назад

      I don't understand

    • @zachrhoden8529
      @zachrhoden8529 2 года назад

      Search how to make a clickable yes / no popup box in Access. On Yes open the query you created, on no open the chart you created.

  • @santoshadhikari9933
    @santoshadhikari9933 2 года назад

    How do we sum by partition in ms access select query?

    • @599CD
      @599CD  2 года назад

      I don't know what you mean "by partition."

  • @anupmukherjee8722
    @anupmukherjee8722 2 года назад

    Every time when I open my access file I should use VBA enable option "on" otherwise the file does not run the VBA program.

    • @599CD
      @599CD  2 года назад

      OK

    • @scottaxton2513
      @scottaxton2513 2 года назад +1

      See Richard's Trusted Location video: ruclips.net/video/YDu4iqlci30/видео.html