How to Create a form that manipulates outlook

[thescottsman]

Morning All,

I'm in the middle of a project and I've hit a bit of a wall. I have created a database which allows me to hold our engineers training requirements, details, and a list of all our jobs on site.

I Want to be able to create a appointment calendar which lets me store data on what engineer goes to what job on what day, and update a outlook calendar with that information. From that, I'd like to be able to automatically update engineers on what job they are on, but that's for another time. At the moment I just need to know if its possible to update an outlook calendar from access and how to create a calendar in access in the first place.

Thanks for your help

 

[Minty]

You might want to look at this thread for some pointers and potential issues http://www.access-programmers.co.uk/forums/showthread.php?t=209552

 

[The_Doc_Man]

To really tweak and twiddle Outlook in VBA, you need to know how to manipulate Application Objects. The first "gotcha" is that you need to learn how to Get an object before you try to Create that object - because Outlook and Access sometimes grind against each other. You can have only one Outlook running on your system, unlike having more than one copy of Word or Excel as a separate process.

To learn how to deal with Outlook objects, particularly calendar objects, you actually need to go to Outlook Help and muddle about in the "Automation" topics to see the Common Object Model for the many strange objects in Outlook. If you learn the names of the objects in the model, though, it isn't that hard to manipulate them.

BTW, you cannot get information about Outlook object manipulation from Access Help so easily. Since about 2010, even if you had the off-line help files, they just don't cross over as well as they used to on earlier versions.