Displaying Records on the calendar - MS ACCESS

Поділитися
Вставка
  • Опубліковано 31 гру 2024

КОМЕНТАРІ • 10

  • @dagsgaz
    @dagsgaz 4 місяці тому

    Jack, your videos really are the best to follow along to!
    Is there a way to display multiple items but from two different tables?

  • @JamesB-c3z
    @JamesB-c3z 5 місяців тому

    Hi Jack,
    I have been watching your how to’s on building a calendar. For me, your videos are by far the easiest to follow. I have been successful in implementing a calendar for scheduling purposes. It seems to function perfectly. The only issue I am having is using the day number buttons to pop-up either a report or form to display more info on the job being scheduled (similar to the birthday list). The problem with the birthday list is that it does not include the year. I am at best a novice and I
    would like to complete this project the way you intended. Let me know if you are willing to help?

  • @jpaesen66
    @jpaesen66 6 місяців тому +1

    Nice to see you back in bussiness !!🥳🥳

    • @DhammaTravelVlog
      @DhammaTravelVlog 6 місяців тому

      Yeah, it was nice. I kinda ran out of things to do with MS ACCESS.
      Good to hear from you; and I am sure you are still busy as always.

    • @jpaesen66
      @jpaesen66 6 місяців тому +1

      @@DhammaTravelVlog yes, I am always bussy. My work is still in progress but we are online with my program for serveral months now. Just hope you do ok as well. If you run out of things to do with Ms Access, I can let you go true my database... 😜😜🤪🤪

    • @MicrosoftAccessHowTos
      @MicrosoftAccessHowTos  6 місяців тому

      @@jpaesen66 I would like that. 🙂

  • @sadaftours4518
    @sadaftours4518 6 місяців тому +2

    Nice Jack Beautiful work done, There is one issue with me in the display order on the calendar because we are not selecting a year in our function so every year in the same month orders or jobs show twice this year and last year.

    • @MicrosoftAccessHowTos
      @MicrosoftAccessHowTos  6 місяців тому

      It really depends on what you want to display on the calendar. If you query by date range as in this video sample, you get everything between the two dates. However, if you only query by day and month, you get everything for the day and month regardless of what year it is.

  • @sadaftours4518
    @sadaftours4518 6 місяців тому

    So do we have to mention the year too in the function or calendar?

    • @MicrosoftAccessHowTos
      @MicrosoftAccessHowTos  6 місяців тому

      Your question did not point to the result you were trying to accomplish. Therefore, I don't know how to respond to your question.