[X]My Assistant

[Peter Hibbs]

The attached A2003 database file demonstrates a calendar form which is designed to simulate (as much as possible) the Calendar facilities in MS Outlook.
It can be used in three modes, Monthly, Weekly (see screen shots below) and Daily and allows users to enter appointments in any mode and to be able to easily switch between modes at any time.
It also has facilities to export appointments to or import appointments from MS Outlook, find scheduled appointments, print a monthly calendar, etc and it can be easily configured for different appointment time slot periods, different formats and so on.
A comprehensive PDF document file is included to show how to set up the system in an existing database project and how to configure the code for your different requirements.
It has been tested on Windows XP and Windows 7 and Access 2003/2007 (but not A2010).
If any bugs found please let me know and thanks to various UA members that have suggested amendments to version 1 which had been posted to this forum earlier.
Peter Hibbs.
(previous file download count: 879, replaced with Version3)
 Calendar_V3.zip ( 771.84K )Number of downloads: 3366

Access 2010 64 bit version (in post #2 below)

This post has been edited by jleach: Sep 7 2012, 10:14 AM - Reason for edit: Replaced previous with Version3
Additionally edited by Cybercow: Dec 22 2012, 12:36 AM - Reason for edit: Added link to post #2 below for Access 2010 64 bit version

Attached File(s)

 Calendar_Month.png ( 67.77K )Number of downloads: 3322
 Calendar_Week.png ( 67.66K )Number of downloads: 2302

 

[dlathem]

Hello again,
just wanted to leave a note for anyone that is using this on a 64-bit office 2010 system. I was running into an error "Please review and update Declare statements and then mark them with the PtrSafe attribute". I found that if you put PtrSafe right after the Declare statement it will eliminate this error.
And here's the 64 bit Access 2010 version tested and working! < (will work ONLY in the 64 bit version of Access 2010)

Attached File(s)

 64bit_2010_working_version.zip ( 874.42K )Number of downloads: 1540

 

[Peter Hibbs]

Hi dlathem,
Thanks for the Calendar update for 64 bit Access, I am sure it will be useful for some users.
I haven't got this version myself but looking at your amendments it seems that it is only the API calls that need to be changed for use with the 64 bit version of Access. I am thinking that we could just add those declarations to the 32 bit version and then Rem them out so that anyone wanting to use the calendar with the 64 bit version could just un-Rem them or maybe there is some way for the start up code to detect which version of Access is being used and enable the appropriate declaration code automatically (or is it more complicated than that?). I will have to think about it some more.
If you have any thoughts on this then please let us know.
Peter Hibbs.

[DatabaseMN]

Peter, I have worked with your calendar in the past and it is a very nice tool.

I have wondered about why each time I open it or switch views, there is a rapid series of flickering. Is this just my machine or has this come up before?

Have been meaning to ask over the past couple years, but finally got around to it.

Thanks again!!

Dana

[Peter Hibbs]

Hi Dana and thanks,

Yes, it is a nuisance. I am pretty sure it is because of the Conditional Formatting on the date fields and I don't think there is any way of eliminating it and I have tried various methods (unless anyone else knows differently).

Peter Hibbs.

[jenotc]

I get error message.

Could anyone help on that?

Error message says:

Syntax error in date in query expression `#2015.1.7 10:00`.

Thanks

Attached File(s)

 Error.jpg ( 42.38K )Number of downloads: 65

 

[Peter Hibbs]

Hi jenotc,

This is because your date format is different than the UK or US. Try the attached version below to see if that fixes the problem.

Peter Hibbs.

Attached File(s)

 Outlook_Style_Calendar_V3a.zip ( 234.19K )Number of downloads: 708

 

[EvilBert]

Hi Peter,

Thanks again for posting this awesome calendar.

I have one question.

I've embedded the frmCalendarMain into another form (so now it's a subform), and everything works great except when clicking on day in the calendar. I get an error on; Call Forms("frmCalendarMain").CheckMode. Because my form structure is now "frmSwitchboard!frmCalendarMain" the reference doesn't work anymore.

I've tried changing the reference to point it to the right place, but not having any luck so far. Maybe I'm overlooking something obvious.

Can you advise how I need to change this to reflect that frmCalendarMain is now a subform in my frmSwitchboard form?

Thanks in advance.

Kind regards,
Michael.

[Peter Hibbs]

Hi Michael,

Hmmm.. good question. Probably like you I tried changing the reference to the parent form by adding the name to the reference but I could not get it to work, maybe there is a limit on the number of forms a CALL function can be nested.

Anyway, the way round it is to move the CheckMode sub-routine to a Code Module (I used modCalendarCode) and then pass the main form object reference to the sub-routine so that the various commands in the sub-routine can make the required changes. Actually I think this is a better way of doing it as I never liked calling a form's sub-routine form another form.

For the calls from the main form (frmCalendarMain) you can just use the Me parameter and for the calls from the three sub-forms you can use Me.Parent. In the sub-routine itself you would simply replace the Me words with frm which is the alias used for the calling form. I have made the required mods in the demo file below so that you can see how it is done. To find the updates just search the VBA code for ### which I used to mark the changes made. One other change you may need to make is to make sure the Name property of the main sub-form (which was the original main form but is now a subform) is set to frmCalendarMain, otherwise the report title does not work (if you are using the report option).

HTH

Peter.

Attached File(s)

 Outlook_Style_Calendar_V3c.zip ( 165.91K )Number of downloads: 971

 

[robertocm]

Dear Peter,

Many Thanks for your calendar and also for the detailed guide 'Outlook Calendar Demo Manual'

Let my just show my gratitude sharing a little 'exercise' of adapting some of your code to an excel week calendar connected to an Access table (instead of the original Access form).

I have used the attached files to try to learn something about date and time queries, crosstab queries and ADO
from my beginner perspective
don't expect any comparable tool

Kind Regards

 excel_week_calendar.zip ( 74.09K )Number of downloads: 352

[Peter Hibbs]

Hi Robertocm,

OK, interesting idea, perhaps someone will find it useful.

Peter Hibbs.

[frm]

Hello Mr. Peter Hibbs,

I saw his work and I found it excellent.

I wanted to ask if was foreseen add in the database the appointment recurrence management,

that is the repetition of the appointment:

Daily
Weekly
Monthly
Annual

as expected in Outlook 2007.

[Peter Hibbs]

Hi frm,

I have added a 'recurrence' facility to this demo. Have a look at the new version in Post #7 HERE.

Peter Hibbs.

[Peter Hibbs]

Hi frm,

OK, try this version which may or may not work but I have an idea what the problem might be. We shall see!

Peter.

Attached File(s)

 Outlook_Style_Calendar_V3i.zip ( 342.46K )Number of downloads: 263

 

[frm]

Hi,

I sent a post today on this Topic but I do not find it, as I do not find the other two pages of this topic either.

May I know, please, why?

Thank you

[doctor9]

frm,

Please check your New Messages. I have moved your discussion so it's in the appropriate forum. You can find your most recent posts by clicking on the "My Discussions" hyperlink in the upper right corner of the page.

Dennis
UA Editor

[frm]

Hi Mr Dennis

Thanks for the explanation.

A question.
When the Topics are inserted in the appropriate forum: "My Discussions"?

[doctor9]

frm,

Yes, it's in the group of hyperlinks in the upper right corner. I've highlighted it in the attachment.

Hope this helps,

Dennis

Attached File(s)

 MyDiscussionsLink.jpg ( 27.64K )Number of downloads: 36

 

[dulcmr7]

Hello Peter.
I am new here and basically signed up because of this great calendar example. Thank you very much for your work on this and making it available to the masses!
I have adapted your work to my project and all is working with the exception of 2 things (so far).

1) This is more of an annoyance than anything and I can easily work around it if needed. If I have the calendar on my primary screen everything works as it should, but if I have it on a second or third screen the date search button (right next to the "Monthly" button in the top right corner) doesn't work and gives an error "An expression you entered is the wrong data type for one of the arguments". I am guessing because it is trying to get the coordinate location, but it is getting confused with the multiple monitors. I am guessing either the Sub btnStartDate_Click or the Function FetchFormCoods needs to modified, but I am not sure how. Are you able to let me know what needs to be changed?

2) Because of a multi-user environment, I will have several instances where there are multiple appointments for the same time slots with each person's appointment on a separate line. I have been trying to figure out how to get the Month, Week, and Day calendars to each expand/grow if there are more appointments than space available so we can see everything. I realize the entire row will need to grow even if only one day has the extra rows, but that is acceptable. I have been changing several setting to Can Grow, but have not had luck with this yet. Any thoughts?

Thanks again!

[dulcmr7]

Peter,
While I'm at it, I've also had a request to bypass the weekends in the calendar view so that it basically just shows a work week. I am scouring through the code right now to see if I can interpret it enough to figure it out. I have my doubts I will be able to get it by myself, though.
Thanks for any help or insight you could provide.