Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Calendar

Posted on 2015-02-21
2
Medium Priority
?
145 Views
Last Modified: 2015-03-06
Does anybody know of a way to display data in a table on a form that looks like a calendar?

If the data in the table looks like:

Date                      Name
1/30/2015            John
1/20/2015            Bill
2/20/2015            Tony
2/15/2015            Steve
3/28/2015            Joe

Then the calendar (form) would look like:

February
1              2              3              4              5              6              7
8              9              10           11           12           13            14
15Stev    16           17           18           19            20Tony    21          
22           23           24           25           26            27             28

And then you could toggle between months.  To show the different events in the table.

It'd be nice if it could look like an Outlook calendar.

--Steve
0
Comment
Question by:SteveL13
[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 29

Accepted Solution

by:
IrogSinta earned 2000 total points
ID: 40623359
Did you just want to display the data onto a calendar or did you want it to have more interactions such as single-clicking or double-clicking on an empty date or on an event to edit it?  

If it's just for viewing then check out this thread and see if the zip file posted there by Peter would work for you:
http://www.experts-exchange.com/Microsoft/Development/Q_27861961.html

If you wanted it more interactive then let me know.

Ron
0
 

Author Comment

by:SteveL13
ID: 40623391
Is a great start.  Would be nice if you could click on the event and have the form open for edit.  Or double-click in the white area on a date and have the form open for new record.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

704 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