Solved

What's the best approach to create a calendar screen and populate it with items?

Posted on 2014-09-29
2
154 Views
Last Modified: 2014-10-31
I'm creating a full-screen calendar which will show multiple items per day. The client wants these items colour-coded based on importance. My initial thought was to create a text box for each square of the calendar, but I don't think I can put different colours in one text box. Also, I realized that then it would be problematic to have Access respond differently to whichever item was clicked on.

My new idea is to create a grid of lines to form the calendar squares and then put multiple labels in each square of the calendar. Then I can colour the text of each label appropriately and respond to individual clicks.

Can anyone suggest a better approach?

Thanks in advance.

James
0
Comment
Question by:jrmcanada2
2 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40350925
Tony Toews has a lot of ideas here:

http://www.granite.ab.ca/access/calendars.htm

For my money, the Calendar Forms are the best way to go about doing this, and especially the ones created with native Access controls.

Note, however, that this rarely looks as good as the stuff in Outlook and such. If you need that sort of functionality, you'd have to move to .NET and use one of the control suites to simulate that.
0
 
LVL 34

Expert Comment

by:PatHartman
ID: 40351070
I agree with Scott.  Access isn't designed to have forms that are rendered on the fly.  You can do a lot from Access to automate Outlook and Project and you might get better results if you collected the data in Access and populated the tasks in Outlook or Project and then let those apps handle the "reporting" aspect.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

867 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now