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: 690
Thanks: 35
Thanked 15 Times in 14 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
Attached Files
File Type: zip Calendar Example.zip (181.0 KB, 100 views)

__________________
If an example or something I have done has helped you please click the scales or thanks.


Examples
Calendar/Holidays Example:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Spin Up/Spin Down Example:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Find And Replace Tool:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Stop Watch Timer:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by MickJav; 01-06-2019 at 03:37 AM. Reason: Added link to another topic for this one
MickJav is online now   Reply With Quote
Old 01-11-2019, 12:12 PM   #2
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 690
Thanks: 35
Thanked 15 Times in 14 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, 197 views)
File Type: png 2019-01-11 (7).png (44.2 KB, 191 views)
File Type: png 2019-01-11 (1).png (14.3 KB, 189 views)
File Type: png 2019-01-11 (8).png (33.4 KB, 189 views)
File Type: png 2019-01-12.png (15.6 KB, 144 views)
__________________
If an example or something I have done has helped you please click the scales or thanks.


Examples
Calendar/Holidays Example:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Spin Up/Spin Down Example:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Find And Replace Tool:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Stop Watch Timer:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by MickJav; 01-12-2019 at 08:58 AM.
MickJav is online now   Reply With Quote
Old 01-12-2019, 07:41 AM   #3
MickJav
Newly Registered User
 
Join Date: Nov 2005
Location: Margate
Posts: 690
Thanks: 35
Thanked 15 Times in 14 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, 138 views)
File Type: png 2019-01-12 (2).png (15.1 KB, 132 views)
File Type: png 2019-01-12 (4).png (41.6 KB, 131 views)
File Type: png 2019-01-12 (5).png (3.6 KB, 132 views)
Attached Files
File Type: zip Calendar Yearly Events.zip (39.7 KB, 31 views)

__________________
If an example or something I have done has helped you please click the scales or thanks.


Examples
Calendar/Holidays Example:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Spin Up/Spin Down Example:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Find And Replace Tool:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Stop Watch Timer:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
MickJav is online now   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:02 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