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
Creating a Calendar in Access
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Creating a Calendar in Access
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
How to Create Calendar Reports from Access Queries with dates! ... as shareable Web Pages
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1484
- Joined: 05 Feb 2010, 22:25
Re: Creating a Calendar in Access
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.
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.
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Creating a Calendar in Access
Duane Hookom has some calendar samples: Hook'D on Access
And a free template: Microsoft Access Calendar Form Template
And a free template: Microsoft Access Calendar Form Template
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1484
- Joined: 05 Feb 2010, 22:25
Re: Creating a Calendar in Access
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
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
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- BronzeLounger
- Posts: 1484
- Joined: 05 Feb 2010, 22:25
Re: Creating a Calendar in Access
Thanks! If you have a minute, can you explain how it works? Thanks!
-
- Administrator
- Posts: 78236
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Creating a Calendar in Access
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.
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
Hans
-
- BronzeLounger
- Posts: 1484
- Joined: 05 Feb 2010, 22:25
Re: Creating a Calendar in Access
Thanks so much! Maybe I can do it myself the next time.
Leesha
Leesha
-
- StarLounger
- Posts: 81
- Joined: 22 Feb 2022, 09:04
Re: Creating a Calendar in Access
Have a look here https://www.access-programmers.co.uk/fo ... db.315110/
or here https://www.access-programmers.co.uk/fo ... se.275897/
or here https://www.access-programmers.co.uk/fo ... se.275897/
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.
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.
-
- BronzeLounger
- Posts: 1484
- Joined: 05 Feb 2010, 22:25
Re: Creating a Calendar in Access
Thanks! I appreciate it!