MS Access Multi Calendar Use in Same Database

[RockKandee]

Hi,

I am very new to MS Access. I hope to put my database on Sharepoint at a later date. Currently I am using a desktop MS Access 2013 database. I have been working with the calendar I found here....

http://bytes.com/topic/access/answer...ccess-calendar

Awesomeness!!!

I want to use more than one calendar in the same database each with a different table populating it. Is this possible?

I tried duplicating the modules and forms and changing the info accordingly, however, this is not working. It appears that the modules are remaining as one and creating errors when I change the name of the calendar form or populating table.

The reason I want separate calendars: I want to use the form pop up within the calendar and I have different forms for scheduling courses and events. Plus I would like to populate the calendar with reoccurring holidays and have one calendar that displays everything.

If there is a way to split the day blocks to allow 2 popup forms, that could possibly work.

Is there a thread anywhere about creating a report or form that could display one week of the calendar at a time?

I have been trying to make a few custom changes and I am encountering some difficulties. Maybe I can get into these questions later.

Any help would be greatly appreciated. Thanks for your time.

Kandee

[PPelle]

I just did this by making a copy of frmCalendar, no other change, and it works flawlessly. What errors are you seeing?

But you can't make the calendar popup, that will prevent the Form_Activate proc from running, where the populating is done. To fix this, just add PopulateCalendar to the Form_Open proc.

[zmbd]

RockKandee
Hello and welcome.
We're glad that the Calendar project was/is helpful and although there may be solutions to your questions, I am going to have to ask you to pick one to start with...

Forum rules usually restrict one question per thread.

As PPelle pointed out, you didn't state the error messages. When you do so, please, use the EXACT title, the EXACT number, and the EXACT text of the error message. Please do not truncate/paraphrase or omit any of this information.

We will also need to know which Operating system and what version of Office/Access you are using.

You will also need to he VERY patient at this point in time. THe expert that had/has a major hand in this particular application is currently involved with another major undertaking; therefore, I respectfully ask you to take a deep breath and keep in mind that the Bytes.com Experts and Moderators are unpaid volentiers and we try our best to lend a hand inbetween our obligations to work, family, and friends. (^-^)

Although it may seem like your thread gets lost, please resist the urge to bump-it...

-z

[ADezii]

I want to use more than one calendar in the same database each with a different table populating it. Is this possible?

Most definitely, it is.

I tried duplicating the modules and forms and changing the info accordingly, however, this is not working.

Do not attempt to duplicate the Standard Code Module mdlMain or the Class Module objDateInfo. Multiple Calendars (Forms) can share these Modules and you will get an Error if you duplicate them. The overwhelming majority of the Code is contained within 'Private' Sub-Routines and a single Function within the Calendar Form itself, and thusly is encapsulated within it. This is why you can have as many Calendar Forms with independent Data Sources as you like.

[RockKandee]

Thank you for the replies. Making a copy of just the form worked perfectly. I am so happy that I can use multiples.

Just to clarify for the future..... Would Windows 8 be considered an operating system? And could I get an example of how to say what version of access I am using. What did I miss?

"Currently I am using a desktop MS Access 2013 database."

I apologies for breaking the rules.


Thank you PPelle for the code to make the pop up feature work. That was going to be a future question.

This calendar is great. My thanks to Adezii for all of the time put into it and for sharing.