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.
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.
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.
I have no idea how to "pipe the data over to Microsoft Outlook's calendar."
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.
Thank you so much. I will check that out.
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.