Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-05-2019, 09:06 AM   #1
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 774
Thanks: 38
Thanked 31 Times in 26 Posts
MickJav is on a distinguished road
Calendar With holidays/Events Example

I downloaded a version of this calendar from this site back in 2005 and have tried to download and open it but it wont open so I have created a version of the one I use with a number of updates.

I had a lot of help from this site in correcting errors found since moving from mdb to accdb

I have commented all the code to help you understand how it works

It also incudes a holidays system that colours the calendar dates you indicate as holidays.

If you can suggest any additions or find any errors please let me know.


Please use this post to post questions etc https://www.access-programmers.co.uk...d.php?t=303140


If you like what I've done please come back and let me know by clicking the thanks button
Attached Files
File Type: zip Calendar Example.zip (181.0 KB, 266 views)

__________________
DD's Simple Home Accounts:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

DD's Book Library:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Under Development DD's Works Manager Due end August 2019, DD's Employee Works Rota Demo Expected 2020

Last edited by MickJav; 02-15-2019 at 01:40 PM. Reason: Added link to another topic for this one
MickJav is offline   Reply With Quote
Old 01-11-2019, 12:12 PM   #2
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 774
Thanks: 38
Thanked 31 Times in 26 Posts
MickJav is on a distinguished road
Re: Calendar With holidays/Events Example

Calendar Yearly Events Update


Please do not post replies here use the link below:
https://www.access-programmers.co.uk...d.php?t=303140

Before you start make a backup.

Should you require this feature please download the attached db Calendar Yearly Events zip At the bottom of the next post.

Once downloaded you should import into the Calendar Db The Following:


Edit Table StblPreferences Add field:
Field Name: DefaultEmployee Type: Number "All other setting are default"
Open the table and add a value of 1 for the michael ?? employee record



Table: tblYearlyEvents "Note if you have removed the default employees import without data but import the relationships"

Queries:
QryYearlyEvents
QryYearlyEventsAll
These are used in the calendar as 2 sides of a union query as I was unable to do what I wanted with a single query but as I don't expect there to be a lot of records I am happy with it, but should somebody who knows queries better than me find a solution to what the queries do please let me know.

Forms: ZfrmYearlyEvents
This is where you enter the events and is a subform on form frmMain which I have include, should you wish to you can replace the old frmMain with this one as it has all the settings for ZfrmYearlyEvents.

Now you have that done you will need both databases open so you can copy code from modUpdateCode in the CalendarEvents Update to your calendar example

When I ask you to copy text I will be referencing modUpdateCode At all times

Copy text in image below:


To The selected location in modCalendar:



Now copy the StrYe SQL Line




Past it to the location below in modCalendar:



Now Copy the selected text in the image below




Continued In Next Post
Attached Images
File Type: png 2019-01-11.png (22.7 KB, 650 views)
File Type: png 2019-01-11 (7).png (44.2 KB, 626 views)
File Type: png 2019-01-11 (1).png (14.3 KB, 623 views)
File Type: png 2019-01-11 (8).png (33.4 KB, 627 views)
File Type: png 2019-01-12.png (15.6 KB, 580 views)
__________________
DD's Simple Home Accounts:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

DD's Book Library:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Under Development DD's Works Manager Due end August 2019, DD's Employee Works Rota Demo Expected 2020

Last edited by MickJav; 01-12-2019 at 08:58 AM.
MickJav is offline   Reply With Quote
Old 01-12-2019, 07:41 AM   #3
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 774
Thanks: 38
Thanked 31 Times in 26 Posts
MickJav is on a distinguished road
Re: Calendar With holidays/Events Example

Continued From last post:


Past copied text to modCalendar image location:



Copy Selected Text in Image below:


Now Past To modcalendar selected text in Image


Now all you have left is to Add
YE.Close
To The Location in modcalendar image


Now copy the Function GetYearlyEvents
To the bottom of modcalendar


Should you have problems please use the Calendar Post below to Relate to this example
https://www.access-programmers.co.uk...d.php?t=303140
Attached Images
File Type: png 2019-01-12 (1).png (27.0 KB, 589 views)
File Type: png 2019-01-12 (2).png (15.1 KB, 572 views)
File Type: png 2019-01-12 (4).png (41.6 KB, 572 views)
File Type: png 2019-01-12 (5).png (3.6 KB, 583 views)
Attached Files
File Type: zip Calendar Yearly Events.zip (39.7 KB, 167 views)

__________________
DD's Simple Home Accounts:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

DD's Book Library:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Under Development DD's Works Manager Due end August 2019, DD's Employee Works Rota Demo Expected 2020
MickJav is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
calendar form and holidays mazza.j Forms 2 10-26-2009 12:50 AM
showing multiple events on a calendar jarheadjim Forms 0 04-22-2008 11:02 AM
Calendar Odject for Scheduling Holidays Shaft Forms 9 03-13-2006 06:23 AM
Report Calendar of Events MsLady Reports 37 08-01-2005 07:58 AM
recurrent events calendar schalkse General 1 06-21-2005 02:47 AM




All times are GMT -8. The time now is 05:01 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World