Solved

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

Posted on 2014-09-29
2
150 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Get the ms access version 4 34
Access VBA Form - Filter Multiple and/or 7 36
Loop within Select Case 3 26
Access checkbox 2 9
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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.

746 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

13 Experts available now in Live!

Get 1:1 Help Now