Calendar With holidays/Events Example (1 Viewer)

Status
Not open for further replies.

MickJav

It wasn't me
Local time
Today, 19:27
Joined
Nov 28, 2005
Messages
2,242
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/forums/showthread.php?t=303140


If you like what I've done please come back and let me know by clicking the thanks button
 

Attachments

  • Calendar Example.zip
    181 KB · Views: 532
Last edited:

MickJav

It wasn't me
Local time
Today, 19:27
Joined
Nov 28, 2005
Messages
2,242
Calendar Yearly Events Update


Please do not post replies here use the link below:
https://www.access-programmers.co.uk/forums/showthread.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
 

Attachments

  • 2019-01-11.png
    2019-01-11.png
    22.7 KB · Views: 1,100
  • 2019-01-11 (7).png
    2019-01-11 (7).png
    44.2 KB · Views: 1,063
  • 2019-01-11 (1).png
    2019-01-11 (1).png
    14.3 KB · Views: 1,051
  • 2019-01-11 (8).png
    2019-01-11 (8).png
    33.4 KB · Views: 1,064
  • 2019-01-12.png
    2019-01-12.png
    15.6 KB · Views: 1,022
Last edited:

MickJav

It wasn't me
Local time
Today, 19:27
Joined
Nov 28, 2005
Messages
2,242
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/forums/showthread.php?t=303140
 

Attachments

  • 2019-01-12 (1).png
    2019-01-12 (1).png
    27 KB · Views: 1,027
  • 2019-01-12 (2).png
    2019-01-12 (2).png
    15.1 KB · Views: 1,005
  • 2019-01-12 (4).png
    2019-01-12 (4).png
    41.6 KB · Views: 1,002
  • 2019-01-12 (5).png
    2019-01-12 (5).png
    3.6 KB · Views: 1,018
  • Calendar Yearly Events.zip
    39.7 KB · Views: 381
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom