Results 1 to 6 of 6
  1. #1
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    126

    Format a report to look like a monthly calendar

    I am thinking about writing an Access db for our team to assign tasks to team members with due dates. I would like to generate a report that looks like a standard monthly calendar, but can't think how you would do that.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,062
    thats tough since many items could occur in 1 day ,thus not fitting in any readable format.
    but you could use what is already there, pipe the data over to Microsoft Outlook's calendar. Let IT do the work.

  3. #3
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    126
    I have no idea how to "pipe the data over to Microsoft Outlook's calendar."

  4. #4
    NTC is offline VIP
    Windows 10 Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    I have gone so far as to formally request an embedded Calendar form/report as part of the Access feature set - - but Microsoft gets lots of suggestions and I tend to doubt we will ever see this feature. There are some add-ins one can find/buy that offer this. It is not do-able for the average developer and surprisingly complex for an advanced programmer. We humans take the calendar for granted but it's a real pain - even the Mayans gave up after awhile. The add-ins - some free and some at a relatively minor $ will vary by their features as to what display size etc and how info is entered.... but if you want a calendar entirely within the Access User Interface - this is the way to go.

    Linking your data to Outlook is what is suggested by 256. Go to an Outlook forum and post that question on how to link to Access. It is of course then in Outlook and not within the Access User Interface.

  5. #5
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    126
    Thank you so much. I will check that out.

  6. #6
    NTC is offline VIP
    Windows 10 Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    Let me add another alternative: the Microsoft Power BI product has a calendar visual. This is can be a complex product to learn all of its features. But for just that feature it might be a viable approach if one wants Access data on a Calendar dashboard via a browser.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 15
    Last Post: 09-01-2015, 12:20 PM
  2. Monthly Report
    By mhockey88 in forum Reports
    Replies: 3
    Last Post: 07-16-2014, 11:26 AM
  3. creating monthly report
    By kyeiframseth in forum Access
    Replies: 1
    Last Post: 04-04-2013, 06:52 AM
  4. Replies: 6
    Last Post: 11-10-2012, 09:49 PM
  5. Query + monthly report
    By tareksul in forum Reports
    Replies: 3
    Last Post: 12-19-2010, 01:09 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums