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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
15 Pages V < 1 2 3 4 5 > »   (Go to first unread post)
   Reply to this topicStart new topic
> Ms Outlook Style Calendar For Access Projects, Access 2003    
 
   
isladogs
post Sep 18 2018, 07:00 AM
Post#41


UtterAccess VIP
Posts: 1,899
Joined: 4-June 18
From: Somerset, UK


Peter
In my own version of a monthly calendar which is very similar to yours, I add a More label for when there are more events than can be displayed in the available space.
E.g on 4th of the month below

Attached File  CalendarMonth.jpg ( 51.35K )Number of downloads: 81


Clicking that label opens the daily calendar where all items can then be seen

HTH

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 
isladogs
post Sep 18 2018, 12:28 PM
Post#42


UtterAccess VIP
Posts: 1,899
Joined: 4-June 18
From: Somerset, UK


Sorry the image in my last post was very low resolution and I left it too late to edit the post.
Here's a better version of the monthly calendar:

Attached File  CalendarMonth.PNG ( 59.59K )Number of downloads: 55


And here are the related day & week calendars

Attached File  CalendarDay.PNG ( 34.41K )Number of downloads: 35


Attached File  CalendarWeek.PNG ( 56.85K )Number of downloads: 31

This post has been edited by isladogs: Sep 18 2018, 12:30 PM

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 
Peter Hibbs
post Sep 19 2018, 06:24 AM
Post#43


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


Colin,

Thanks for the tip. On my calendar the user can click on the date field which opens a pop-up form that shows all the appointments for that date or if they click on the date above the text box it opens the daily calendar for that date so I have that option pretty much covered.

As a matter of interest, how do you show the different colours for each date? I am guessing you have three smaller Text boxes for each date with some VBA code to fill in the colours.

Peter.
Go to the top of the page
 
isladogs
post Sep 19 2018, 07:53 AM
Post#44


UtterAccess VIP
Posts: 1,899
Joined: 4-June 18
From: Somerset, UK


Hi Peter

QUOTE
As a matter of interest, how do you show the different colours for each date? I am guessing you have three smaller Text boxes for each date with some VBA code to fill in the colours.


VBA code is used but not as you suggested
Each event is assigned to a category when it is created/edited

Attached File  EditCalendarEvent.gif ( 27.74K )Number of downloads: 4


The colours for each category are allocated/edited using this form (by program admins only)

Attached File  CalendarCategories.gif ( 47.29K )Number of downloads: 9


Finally, this colour converter form provides an easy method of determining the colour value required for any given colour

Attached File  ColourConverter.gif ( 25.14K )Number of downloads: 3


HTH


--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 
Peter Hibbs
post Sep 19 2018, 03:04 PM
Post#45


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


Hi Colin,

OK, looks good. Perhaps you should submit it to the UA Archive!

Peter.
Go to the top of the page
 
isladogs
post Sep 19 2018, 03:47 PM
Post#46


UtterAccess VIP
Posts: 1,899
Joined: 4-June 18
From: Somerset, UK


Thanks. It's a small part of a very large commercial application used in UK schools.
As such it would take a lot of work to turn it into a standalone application.

However, I do have several other items that might be suitable for the archive.
Whilst I have done this at several other forums, not sure how to submit items here.
Is there an article explaining how?

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 
Peter Hibbs
post Sep 19 2018, 05:13 PM
Post#47


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


Hi Colin,

I am not sure if there is a specific help page for posting the the UA Archive (I couldn't find anything) but here are two help pages which might help - Guidelines and UA Help.

To post a new article to the Archive you can just start a new thread in the Archive section (in the same way as to any other section) except that it will not appear immediately on screen. The UA managers will assess it and decide if it is suitable for the archive and if it is it will appear a day or two later. If they decide it is not suitable I guess they will let you know but none of mine have been rejected so I don't know what the procedure is.

Just some advice on posting articles from my experience - you need to make sure it will work for any country, i.e. dates and currency formats, etc. I have many enquiries about my earlier efforts where the date fields do not work in some European countries because they use date formats like dd.mm.yyyy for example. Now I always use the code supplied by Allen Browne for date formats which should work in any country. I have questions from countries all over the world (like Brazil, Australia, USA, Spain, Greece, Poland, etc) about how to change a design to work in those countries so you should be prepared for any follow ups. And the language translations can be a bit of a challenge as well. If you scan through some of my posts you will see what I mean.

Also I believe that you should provide some comprehensive instructions on how to use the examples (unless they are very self evident) as a some new users only have a very basic knowledge of Access and/or VBA/SQL coding.

Anyway, good luck if you do post anything.

Peter.
Go to the top of the page
 
isladogs
post Sep 19 2018, 05:28 PM
Post#48


UtterAccess VIP
Posts: 1,899
Joined: 4-June 18
From: Somerset, UK


Thanks Peter.
That's all fairly standard procedure in terms of posting to a moderated area.
As a moderator at another forum, I'm conversant with the idea.

For info, I have a large number of example apps at My Website many of which have been posted at other forums.
I'm currently in the process of uploading a library of code samples to add to the website.
I'm also used to providing detailed documentation though I have to say the quality of your help files is always outstanding

Thanks again for your help

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 
riti90
post Sep 21 2018, 07:18 AM
Post#49



Posts: 14
Joined: 11-January 18



Hi Peter,

Sorry to disturb you again but I'd like to ask if you have any updates about the calendar?

Many thanks, smile.gif
Margarit
Go to the top of the page
 
Peter Hibbs
post Sep 21 2018, 08:09 AM
Post#50


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


Hi Margarit,

Yes I do (sorry for the delay, it took longer than I anticipated). Anyway, see the attached zip file with the modified database, User Manual and the pop-up calendar icon (in case you should need it but you probably won't).

As you are using the 64 bit version of Access you will probably need to sort out the API calls before you can test it properly. Some information on that is at the end of the User Manual.

I have added the 'Chamber' facilities, as requested, although I have still used the name 'Appointments' for the records. I guess you might want to change that word to something more appropriate like 'Booking' or whatever but I expect you will be translating everything into Polish anyway.

Let me know how you get on or if you find any bugs or problems.

Peter.
Attached File(s)
Attached File  Outlook_Calendar_V3o.zip ( 905.33K )Number of downloads: 98
 
Go to the top of the page
 
isladogs
post Sep 21 2018, 09:16 AM
Post#51


UtterAccess VIP
Posts: 1,899
Joined: 4-June 18
From: Somerset, UK


Hi Peter

I hope you don't mind but as I also have 64-bit Office, I've added conditional compiling to the two modules so it now works on both 32-bit & 64-bit
I've called it v3p but forgot to alter the app title which still reads v3o

I may steal the yearly calendar for my own apps. Thank you

Attached File  Outlook_Style_Calendar_V3p.zip ( 836.35K )Number of downloads: 108

This post has been edited by isladogs: Sep 21 2018, 09:17 AM

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 
Peter Hibbs
post Sep 21 2018, 10:19 AM
Post#52


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


Hi Colin,

OK, thanks, that could be useful for some people and yes, feel free to use the Yearly form or whatever else.

Peter.

P.S. For anyone downloading this demo, I forgot to hide the Header section on the Appointment Schedule form (but I expect you figured that out yourself!!).
Also you need to change the Public Const conDayLength = 3 value in module modCalendarCode to 1 or 2 (rather than 3 which I also forgot to restore).
Go to the top of the page
 
whybrow23
post Sep 25 2018, 07:46 AM
Post#53



Posts: 39
Joined: 17-July 18



This is great, thanks for sharing Peter.

Question, how easy if at all, would it be to have the colour of the chamber shown in each of the calendar views like it does on the monthly one.

So say I have 4 differnet chambers
1. confirmed - yellow
2. Possible - Blue
3. Change over 1 - Purple
4. Change over 2 - Pink

I then open the calendar in the year view and from that going by the colours, I can see when and where they are

Hope I've made sense :-)

Again, thanks again for this Peter

Go to the top of the page
 
Peter Hibbs
post Sep 25 2018, 01:24 PM
Post#54


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


Hi whybrow,

Well I think it would be possible by using the same technique as that used for the Monthly view bu the problem with the Weekly and Daily views is what it would look like if you had appointments that run over multiple time slots and even more of a problem would be if you allowed multiple appointments for the SAME time slots. If the appointments were limited on the Weekly mode to one appointment per time slot (as shown in the screen shot in post #1) then it would work OK but if you have multiple time slots for appointments and with the ditto signs enabled as well, it could look a bit of a mess. I don't think the issue will arise for the Yearly mode because it is not possible to have more than one colour per date so unless you have only one appointment per day you can't really colour code those date boxes.

Anyway, I will give it some thought and if I can come up with a good solution I will upload it here (but it could be a while as I am very busy with other projects at the moment).

As a matter of interest, how would you plan to use the calendar in light of my comments above?

Peter.
Go to the top of the page
 
riti90
post Sep 25 2018, 02:55 PM
Post#55



Posts: 14
Joined: 11-January 18



Hi,
I did a small change on Peter's code just for trials and the weekly mode looks like this.
Attached File  Weekly_View.JPG ( 157.42K )Number of downloads: 46


If it's of any help I could attach the file so you can have a look.

Regards,
Margarit
Go to the top of the page
 
whybrow23
post Sep 26 2018, 02:31 AM
Post#56



Posts: 39
Joined: 17-July 18



Hi Margarit

Thanks for geting back to me.

The whole database is great, but the bit I'm very interested in is the year view.

Only 1 appointment per day would also work for me.

So the idea abit like the attached, but in the format as per the database

with the 4 or more differnet chambers
1. confirmed - yellow
2. Possible - Blue
3. Change over 1 - Purple
4. Change over 2 - Pink

Many thanks
M
Attached File(s)
Attached File  Untitled.jpg ( 204.66K )Number of downloads: 27
 
Go to the top of the page
 
whybrow23
post Sep 27 2018, 02:23 AM
Post#57



Posts: 39
Joined: 17-July 18



Sorry, I was ment of said thanks Peter :-)

But also a thanks to Margarit also. the work you two have put into the DB is fantastic
Go to the top of the page
 
Peter Hibbs
post Sep 27 2018, 10:53 AM
Post#58


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


Hi whybrow,

OK, here is a new version with the Yearly mode date boxes colored in with the Chamber colors (I guess you will want to change the 'Chamber' labelling to 'Category'or whatever for your own purposes but I will leave that to you).

Changing the code for the color changes was relatively easy but it then made it necessary to change some other facilities. For example, on the previous version I colored the currently selected date box in blue but that would not work if you have an appointment set up for that date that is already colored blue so I have changed it slightly to fix that. When you click on any date on the Yearly calendar the date box border color is changed to black and made visible (note that the current date, i.e. today's date, still shows a red outline when it does not have the focus).

As before, you can double click on any date box and add a new appointment and when you close the pop-up form the calendar will color in that date box with the color of the categry. However, if the calendar is in '<<< Show All >>>' mode the boxes will all be colored grey because if you have more than one appointment for different categories on the same date, you cannot show the color for both categories. What would happen is that the date box will be colored with whichever appointment is processed last, usually the one entered last which would be very confusing for the users. To show the categories in the associated colors you need to select the relevant category (i.e. chamber) in the drop down box at the top of the form.

Hopefully this will do what you want but let me know if you find any bugs.

Peter.
Attached File(s)
Attached File  Outlook_Style_Calendar_V3o.zip ( 593.32K )Number of downloads: 79
 
Go to the top of the page
 
riti90
post Sep 27 2018, 11:46 AM
Post#59



Posts: 14
Joined: 11-January 18



Hi Peter/whybrow,

There is another model of Peter's Great Calendar. The Yearly View is different than the previous one but if you find it useful you can have a look.

For me Peter's last one work perfect and that's how I need it to work.

Attached File  Outlook_Style_Calendar_V3p_WIP04.zip ( 530.22K )Number of downloads: 120


Thank you,

Margarit
Go to the top of the page
 
Peter Hibbs
post Sep 27 2018, 01:19 PM
Post#60


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


Hi Margarit,

Thanks for the new version, very good.

When I get some time to spare I will update my version of the Weekly and Daily view with the Week code from your last version (if that is OK with you). You never know that someone might need those facilities in the future.

Peter.
Go to the top of the page
 
15 Pages V < 1 2 3 4 5 > » 


Custom Search


RSSSearch   Top   Lo-Fi    12th December 2019 - 04:51 PM