Solved

Scheduling tasks in a Calendar in Access 2007

Posted on 2011-09-07
5
233 Views
Last Modified: 2012-05-12
Hello,

Does anyone have any suggestions on having a calendar form and linking tasks to days? I'm looking for a nice calendar view that takes up the screen, and then the user could interact with the calendar to view different tasks on the day they clicked.

How would I go about developing this? Is there a 3rd party control, or example online somewhere?

Thanks...
0
Comment
Question by:michael1174
  • 2
5 Comments
 
LVL 77

Assisted Solution

by:peter57r
peter57r earned 250 total points
ID: 36495857
I think this is called re-inventing the wheel.

Outlook does it better than you can ever hope to.
0
 
LVL 2

Author Comment

by:michael1174
ID: 36496014
Ok, but how would I integrate this within several outlook clients?  When updating outlook through automation, does it update everyones calendar so other people can see?  

I'm familiar with only in the sense of outlook I run from my pc, but am lost at multiple users pcs using outlook and updating it....

0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
ID: 36496787
While you can certainly create a calendar control, Select a day and add/edit "Tasks"
It won't be as Graphically Interactive as Outlook.

The would basically be a One to many situation
One Day, Many Tasks.
Any basic form you create would reflect this very basic relationship.
In other words, you won't get a "Full Screen/Interactive" calendar, ...unless you do a fair amount of custom programming.

I am sure there may be something out there that does this, but customizing it for your specific application  will be another story entirely.

To be fair, there are other alternatives to Outlook
http://www.chaossoftware.com/chaos.aspx
http://www.effexis.com/achieve/planner.htm
...etc (I am sure you can Google for more...)

But here again, customizing them to work with separate "Clients" is another story.

So, based on all of this, I too would recommend going with Outlook.
As difficult as it might be to get Outlook to work with your clients, this would probably me many times more complex in any other program (if it was possible at all)

Click the "Request Attention" link and ask that the Outlook zone be added to this Question.

In the mean time check out this site form some insight:
http://www.outlookcode.com/

JeffCoachman
0
 
LVL 2

Author Closing Comment

by:michael1174
ID: 36524407
Thanks for your input.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you don't know how to downgrade, my instructions below should be helpful.
Finding original email is quite difficult due to their duplicates. From this article, you will come to know why multiple duplicates of same emails appear and how to delete duplicate emails from Outlook securely and instantly while vital emails remai…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question