UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
7 Pages V « < 5 6 7  (Go to first unread post)
   Reply to this topicStart new topic
> Ms Outlook Style Calendar For Access Projects, Access 2003    
 
   
drakopp
post Oct 29 2018, 05:56 AM
Post#121



Posts: 4
Joined: 3-November 17



Good day! How can I set the calendar if the work week starts on Monday?
Go to the top of the page
 
Peter Hibbs
post Oct 29 2018, 07:08 AM
Post#122


UtterAccess VIP
Posts: 1,634
Joined: 17-June 10
From: Dorset. UK.


Hi drakopp,

Read the manual, the Configuring the Calendar section shows how to do that under Change the Week Start Day paragraph.

Peter Hibbs.
Go to the top of the page
 
drakopp
post Oct 29 2018, 08:25 AM
Post#123



Posts: 4
Joined: 3-November 17



Hi, Peter!
I downloaded the version from post 84. I changed the constant, but nothing changed in the monthly and yearly form. In the version from the starting post on a monthly basis, after changing the constant, everything changes.
Go to the top of the page
 
Peter Hibbs
post Oct 29 2018, 08:59 AM
Post#124


UtterAccess VIP
Posts: 1,634
Joined: 17-June 10
From: Dorset. UK.


Hi drakopp,

It works for me OK. You need to close the form and open it again to see the changes.

Peter Hibbs.
Go to the top of the page
 
drakopp
post Oct 29 2018, 09:20 AM
Post#125



Posts: 4
Joined: 3-November 17



Sorry, but did not help.
Attached File  2018_10_29_16_08_05.png ( 15.66K )Number of downloads: 18
Attached File  2018_10_29_16_07_24.png ( 25.1K )Number of downloads: 29
Attached File  2018_10_29_16_06_33.png ( 37.54K )Number of downloads: 22
Go to the top of the page
 
Peter Hibbs
post Oct 29 2018, 09:34 AM
Post#126


UtterAccess VIP
Posts: 1,634
Joined: 17-June 10
From: Dorset. UK.


Hi drakopp,

OK, I see the problem, you are changing the constant in the pop-up calendar code (which is correct) but you also need to do the same thing in the main calendar code which is in module modCalendarCode like this :-
CODE
Public Const conFirstDay = vbMonday     'Set to vbSunday if first day of week to show as Sunday. Change to vbMonday, vbTuesday, etc for other days.


Hopefully that will fix the problem.

Peter Hibbs.
Go to the top of the page
 
drakopp
post Oct 29 2018, 09:40 AM
Post#127



Posts: 4
Joined: 3-November 17



Great. Thanks, Peter.
Go to the top of the page
 
dzoker
post Jan 29 2019, 04:48 PM
Post#128



Posts: 415
Joined: 12-February 14



Peter Hibbs,

I tried your Database 'Outlook Style Calendar V3o WB' but I'm getting a Invalid use of Null when trying to open the frmCalendarAppt? Can you help please.

ty
Go to the top of the page
 
Peter Hibbs
post Jan 29 2019, 05:46 PM
Post#129


UtterAccess VIP
Posts: 1,634
Joined: 17-June 10
From: Dorset. UK.


Hi ty,

You can't open that form on its own, you must open it from the main calendar form (as explained in the notes).

HTH

Peter.
Go to the top of the page
 
dzoker
post Jan 30 2019, 09:35 AM
Post#130



Posts: 415
Joined: 12-February 14



Peter,

QUOTE
You can't open that form on its own, you must open it from the main calendar form (as explained in the notes).

Duuh, it always help to read the manual. reading.gif

I know that in one of the previous posts you said that the chart was made for only one appointment per day (as requested), hence it shows only one color but I was wondering how difficult would be to have it show multiple color bars in the same day?

Awesome work Peter and everyone else!! cheers.gif

Thank you
Go to the top of the page
 
Peter Hibbs
post Jan 30 2019, 09:59 AM
Post#131


UtterAccess VIP
Posts: 1,634
Joined: 17-June 10
From: Dorset. UK.


Hi Ty,

OK, good (you are not the first to make that error though).

I know that in one of the previous posts you said that the chart was made for only one appointment per day (as requested), hence it shows only one color but I was wondering how difficult would be to have it show multiple color bars in the same day? Do you mean that you want multiple color bars on the Monthly view or one of the others?

Perhaps the version in Post #58 in this thread will do what you want (and there are various other variations of the calendar in other posts). If you want something a bit different then let me know as I may have already done something similar.

Peter.
Go to the top of the page
 
dzoker
post Jan 30 2019, 10:14 AM
Post#132



Posts: 415
Joined: 12-February 14



Peter,
QUOTE
Do you mean that you want multiple color bars on the Monthly view or one of the others?

I was asking about the chart not the Monthly calendar.

See the attached file. In this case I have an appointment from 02/02/19 - 04/12/19 (Yellow) and 05/02/19 - 04/10/19 (Blue). as you can see in the days they overlap I can only see the blue one where I need to show blue and yellow (in all view)

Maybe I'm asking too much.

TY
Attached File(s)
Attached File  Chart.bmp ( 787.07K )Number of downloads: 25
 
Go to the top of the page
 
Peter Hibbs
post Jan 30 2019, 12:15 PM
Post#133


UtterAccess VIP
Posts: 1,634
Joined: 17-June 10
From: Dorset. UK.


Hi Ty,

Yes, I think you are asking a bit too much, how would you show a chart where appointments overlap? You would need extra rows for each color (I guess if there were only ever two overlapping you double up the rows and make them smaller in height but it would be a major redesign). I think you may have to rethink how you wan't to display your data to overcome this issue.

What do you think?

Peter.
Go to the top of the page
 
dzoker
post Jan 30 2019, 01:03 PM
Post#134



Posts: 415
Joined: 12-February 14



Peter,
QUOTE
What do you think?

I mean, the Monthly calendar view works just fine I was just wondering if the chart can do it too (I like the chart view).

I will try to incorporate this into a student database that I build and maintain and I think it would be a great upgrade to it.

Thank you for your time.
Go to the top of the page
 
7 Pages V « < 5 6 7


Custom Search


RSSSearch   Top   Lo-Fi    18th February 2019 - 05:08 AM