If I am reading your problem correctly- it sounds like you want to
display notes in a calendar format - like a calendar you hang on a wall
and write notes in the respective day box - or like the calendar in
Outlook. If this is what you are looking for - you can either use the
Outlook calendar or if not everyone (or anyone) has Outlook then you
have to build your own calendar. You can have one form which uses
textboxes for the calendar entries and another form to display the
entries but use labels instead of textboxes so the data cannot be
changed in the viewing state.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

I am trying to create a database to track heavy equipment for building
roads, like Dozers, Excavators, etc., and I would like to display a
calendar / timeline to view the current and fuiture schedule to a
piece of equipment. For example: Excavator A3, will be in Chicago
July 23-29, then the same Excavator will be in Denver from July 30-Aug
10. Dozer B7 will be in Dever from July 15-Aug 1, then Dozer B7 will
be in Chicago from Aug 2 - Aug. 18.

I have a form that uses the Access calendar control to input the
equipment name, location, start date and end date into a table. I
can't figure out a way to then show a calendar visually with the weeks/
monthly and the location of each piece of equipment for those days
showing on the calendar. I can make a report and group by dates but I
would like to be able to show the information in a calendar type view.

To begin, you need to revcise your table structure .........

TblEquipment
EquipmentID
EquipmentName

TblLocation
LocationID
Location

TblEquipmentSchedule
EquipmentScheduleID
EquipmentID
LocationID
StartDate
EndDate


Steve
santus (AT) penn (DOT) com



"RCGUA" <stv.nelson1 (AT) gmail (DOT) com> wrote

"Steve" <stupidity_available_at_very_reasonable_rates (AT) contactme (DOT) com> wrote
in message news:MIydnW_ur7iW-s_XnZ2dnUVZ_qqdnZ2d (AT) earthlink (DOT) com...
How do you know what the OP's table structure is?

"RCGUA" <stv.nelson1 (AT) gmail (DOT) com> wrote

Check out Allen Browne. allen (AT) allenbrowne (DOT) com
He has a Calendar form which can be modified to do what you want.

On Jul 7, 8:39*am, "paii, Ron" <n... (AT) no (DOT) com> wrote:
Thank you all for all your help. This is why I always suggest that
people use Access, because of the great support from experts like
yourselves. I looked at some of the suggestions and I found one that
I think I can alter and make it work, Duane Hookom's, Hook'D on
Access, Calendar Reports sample which has a gantt type report (sample)
which displays time bars across longer periods of time.
http://www.access.hookom.net/Samples...darReports.zip

The two links below have an awesome amount of information about
calendars, thanks for those links they are very, very helpful.
http://www.accessmvp.com/JConrad/acc...calendars.html
http://www.granite.ab.ca/access/calendars.htm

RCGUA <stv.nelson1 (AT) gmail (DOT) com> wrote:

Thanks for your kind words.

Tony (Author of the site in the second link)
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/