Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-06-2019, 02:48 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 Topic

Related project: https://www.access-programmers.co.uk...d.php?t=303130


Just noticed this un-needed code



Code:
Code from frmscheduleCalendar

    'For I = 1 To 37
     '   Me.Controls("Text" & I).Visible = False
    '    Me.Controls("Day" & I).Visible = False
   ' Next
As it does the same thing in the module Code below
Code:
     For A = 1 To 37
        F("Day" & A).Visible = False
        F("Text" & A).Visible = False
        F("Rmd" & A).Visible = False
        F("Sch" & A).Visible = False
        F("Main" & A).Visible = False
        F("Nw" & A).Visible = False
        F("date" & A) = Null
        F("day" & A) = Null
     Next
As I didn't design the original I've decided to go though it and make improvements where I can and post them here.

__________________
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-06-2019 at 03:25 AM.
MickJav is offline   Reply With Quote
Old 01-06-2019, 02:56 AM   #2
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,627
Thanks: 2
Thanked 2,047 Times in 2,002 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Calendar With holidays/Events Example Topic

Quote:
Originally Posted by MickJav View Post
Just noticed this un-needed code
Where?

Quote:
Originally Posted by MickJav View Post
As I didn't design the original I've decided to go though it and make improvements where I can and post them here.
Why?
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 01-06-2019, 03:01 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 Topic

Comment out the code indecated in image until you are happy
Attached Images
File Type: jpg 2019-01-06_LI.jpg (94.3 KB, 70 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
Old 01-06-2019, 03:16 AM   #4
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,627
Thanks: 2
Thanked 2,047 Times in 2,002 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: Calendar With holidays/Events Example Topic

I think you should put it in the thread with the database!
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
Old 01-06-2019, 03:23 AM   #5
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 Topic

nobody can comment or input to the project except mods or they have to approve every post so no.


Please read: https://www.access-programmers.co.uk...d.php?t=118626
__________________
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-06-2019 at 03:33 AM.
MickJav is offline   Reply With Quote
Old 01-10-2019, 12:12 PM   #6
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 Topic

I'm working on an update for the calendar which I hope to complete by sunday

I'm adding a yearly events like birthdays, Anniversaries Etc.
I know most wont need it but I have a use for it in my personal Db.


I'll be adding an update db with what you will need and post a complete description on how you can add it to the calendar.
Attached Images
File Type: jpg 2019-01-10.jpg (104.0 KB, 35 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
Old 01-13-2019, 08:04 AM   #7
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 Topic

Yearly Events Update Info




This will allow you to show yearly events like birthdays, Anniversaries on your own calendar (I.E. when you are loged into your db)


By ticking the all field that event will be shown on All employees calendars this should be restricted to managers/Admin as it would relate to special dates for the company they wish to keep the employees aware of.


Download this update from the link below:
https://access-programmers.co.uk/for...33&postcount=3


A full description has been added to the topic starting on post 2
Attached Images
File Type: png 2019-01-13.png (7.6 KB, 188 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
Old 01-27-2019, 03:15 PM   #8
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 Topic

I am currently working on a new project including an updated version of this project this includes Peter Hibbs Holiday planner i am posting update on utteraccess as Peter originally wrote the program.
I still have 2-3 weeks work left then will make it available as an example.

https://www.utteraccess.com/forum/in...iew=getnewpost
__________________
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
Old 02-16-2019, 12:55 PM   #9
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: Employee Example Version 2

I'm hoping To complete this update by the 24th


This update includes:
  1. Works Diary
  2. Updates to the Holiday Planner For works diary
  3. Updates to calendar For works Diary
  4. New Meetings system for Works Diary
  5. I have used the groups/tasks From peter Hibbs Gantt Chart Demo, This is a demo Item which shows some of the things that can be done with the data from the works Diary
  6. Works Diary Uses Same Admin/Manager System as The Holiday planner
  7. The Main Screen/Preferences Screen has been updated
  8. Complete word doc going though the calendar, Holiday Planner and Works Diary Usage
It will be uploaded to this topic Hopefully by the date above
https://www.access-programmers.co.uk...d.php?t=303671
Attached Images
File Type: png 2019-02-16 (1).png (72.9 KB, 28 views)
File Type: png 2019-02-16 (2).png (66.7 KB, 22 views)
File Type: png 2019-02-16 (4).png (82.9 KB, 20 views)
File Type: png 2019-02-16 (5).png (60.4 KB, 22 views)

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 With holidays/Events Example MickJav Sample Databases 2 01-12-2019 07:41 AM
calendar form and holidays mazza.j Forms 2 10-26-2009 12:50 AM
Calendar Odject for Scheduling Holidays Shaft Forms 9 03-13-2006 06:23 AM
recurrent events calendar schalkse General 1 06-21-2005 02:47 AM
[OFF TOPIC] Happy Holidays pat_nospam General 0 12-24-2003 02:06 PM




All times are GMT -8. The time now is 05:24 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