Share via

How to create a calendar in MS Access that will display appointments in a table.

Anonymous
2013-06-14T18:45:00+00:00

I have a table in MS Access 2007 which contains medical appointments.  I am trying to find a way to display these appointments in a daily calendar format.  I am currently exporting the appointments out of Access and importing them into Outlook.  The problem with this is that it is not real time.  The people viewing these appointments need to see them in the calendar immediately and not wait for an export/import funtion to be done.  Various individuals are scheduling at the same time and need to see any appointments others have entered immediately.  Can anyone help me?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Duane Hookom 26,820 Reputation points Volunteer Moderator
    2013-06-14T19:16:18+00:00

    Consider the various reports in a sample mdb file at http://www.access.hookom.net/Samples.htm.

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2013-06-17T17:57:54+00:00

    Thank you for your response.  I looked at the calendar examples and am still confused.  I don't know very much about writing the code needed.   I think that Daily Schedule is going to be what I need.  Here is what I have...

    I have a query that pulls information from various tables.  The following fields are in the query.

    Activities:StartDate

    Activities:StartTime

    Activities:AppointmentLocation

    Students:StudentName

    Students:StudentNotes

    I currently export the information in my query to excel and import to Outlook.  This process doesn't allow real time data so I am trying to set them up a calendar view in Access similar to that in Outlook with the Date at the top and the times down the side and each appointment blocked out for it's appropriate start and end times. I tried to figure out your Daily Schedule because I think that type of report would work but just can't seem to figure out how to set it up.  Any help would be appreciated.

    1 person found this answer helpful.
    0 comments
  3. Duane Hookom 26,820 Reputation points Volunteer Moderator
    2013-06-18T13:14:27+00:00

    This isn't something that can easily be explained without writing a chapter of a book. Actually Arvin Meyer and Doug Steele's "Access Solutions - Tips, Tricks, and Secrets from Microsoft MVPs" TIP: 22.

    http://www.amazon.com/Access-Solutions-Tricks-Secrets-Microsoft/dp/0470591684

    There are a couple keys. Set up the detail section and the date footer to be the same height (typically just under a page). There is a fair amount of code that just moves and re-sizes a control to make sure it displays properly.

    The line:

    Me.MoveLayout = False

    makes sure every record from a date is render on top of the date footer.

    0 comments