Open Outlook Calendar from Access

[Sylvie]

Hello All
From a command button on Access, how can you open Outlook Calendar for the
user to be able to add an appointment and if possible return the Date and
time of the appointment on a text box on the current form. I'm using
Access2007.
Thank you so much.

 

[Beetle]

There is no simple, built in way to do what you want. It's going to require
some programming on your part. Simply opening Outlook isn't that
difficult, but transferring data between the two is more complicated.
Outlook stores it's data in one table (aka a "flat file" structure), whereas
Access uses the relational model (multiple related tables).

So, the question is, how comfortable are you with programming in
the VBA environment?

 

[SylvieB]

I don't know much about VBA, although i'd like to learn (still looking for a
good book to learn). If i go only with opening Outlook calendar, what code do
I need to write? Thank you

 

[Beetle]

Here is a link to an article about creating an Outlook appointment
from Access. It assumes that you would be entering the appointment
data in Access and then just adding it to Outlook programmatically, so
the appointment data would need to be stored in an Access table.

Even if that is not what you want to do, the article should give you some
useful information regarding working with Outlook from within Access.

 

[Beetle]

Oops, forgot to post tha actual link. Here it is;

http://accesstips.wordpress.com/200...k-adding-custom-data-to-your-outlook-calenda/