Creating a Calendar in Access

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Creating a Calendar in Access

Post by Leesha »

Hi,
I have a user who stores data in access that contains dates for follow-up with customers and the method for follow-up (IE phone, email, social media etc). I have created a follow-up list for then that runs based on the date range they put in. This works fine, however they would like to be able to print it out on a calendar view so they can visualize items they may may want to move to other days/months. Is there a recommended approach to doing this or does someone have a template they are using?

Thanks,
Leesha

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Creating a Calendar in Access

Post by HansV »

Access MVP Crystal Long has a video showing how it can be done. If you click SHOW MORE below the video, you will find a link to a downloadable database.

How to Create Calendar Reports from Access Queries with dates! ... as shareable Web Pages
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Creating a Calendar in Access

Post by Leesha »

Hi Hans,
I did see her video earlier but when I went to download it and read the licensing info it would be an issue as this db will be sold.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Creating a Calendar in Access

Post by HansV »

Duane Hookom has some calendar samples: Hook'D on Access
And a free template: Microsoft Access Calendar Form Template
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Creating a Calendar in Access

Post by Leesha »

Thanks Hans! I'll take a look at those. One more thing, I've been using code you gave me for a queyr years ago to find the weekending date for a specified date. Now I need to find the first day of the week, with the first day of the week being a Sunday. I played around with the code you gave me but can't get it to work. This is the code I've been using:
Week_ending_date: [care_date]+7-Weekday([care_date],7)
What would it look like if [care_date] is 5/7/22 and the first day of the week that I'm looking for is 5/1/22.
Thanks!
Leesha

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Creating a Calendar in Access

Post by HansV »

Use

=[care_date]+1-Weekday([care_date])
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Creating a Calendar in Access

Post by Leesha »

Thanks! If you have a minute, can you explain how it works? Thanks!

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Creating a Calendar in Access

Post by HansV »

Without a second argument, Weekday returns the day number using USA convention:

Sunday=1
Monday=2
...
Saturday=7

So if we subtract Weekday([care_date]) from [care_date], we subtract 1 on a Sunday, 2 on a Monday, etc., landing on the Saturday before. Adding 1 takes us to Sunday.
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Creating a Calendar in Access

Post by Leesha »

Thanks so much! Maybe I can do it myself the next time.
Leesha

Gasman
StarLounger
Posts: 81
Joined: 22 Feb 2022, 09:04

Re: Creating a Calendar in Access

Post by Gasman »

Using Access 2007.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Creating a Calendar in Access

Post by Leesha »

Thanks! I appreciate it!