Solved

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

Posted on 2014-09-29
2
162 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 36

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

730 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