Calendar Yearly Events Update
Please do not post replies here use the link below:
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"
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.
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