Retrieve meeting date and time

  • Thread starter Thread starter Henry
  • Start date Start date
H

Henry

I use Access 2003 to link to Outlook Calendar. The fields I can read for
example are "Subject", "Sender Name", ... But I want to get the "Start time"
and "End time" so I can build a database to record the schedule for the
events on my group calendar. I don't want to create my own group forms as we
use the same MS calendar form for different groups. Is there any way I can
get to these information?

Your ideas are appreciated.

Thanks,
Henry
 
If you can already read calendar properties such as Subject and
Sender, check out StartDate and EndDate, I believe those are the
properties you need for the AppointmentItem object (or Start and End,
can't recall at the moment).

HTH,
JP
 
The linked table approach has major limitations, including the inability to
show even all the reasonably important fields. While articles have been
written on how to expand on this technique's obvious features, I've never
been able to duplicate the results. See
http://www.outlookcode.com/article.aspx?ID=25 .

That page will also give you other ideas on how to work with databases and
Outlook together. Most of the time, from the Access side, you'll need to
write code to do Outlook automation.
 
Thanks Sue, JP. I checked the properties again and there are only "Received",
"Modified", and "Created". I guess I will try Sue's advise in my spare time.
If it works, I will post it and Sue has to knight me.

Thanks,
Henry Nguyen
 
JP, Henry has apparently used a feature in Access that allows an Outlook
folder to appear as an Access table, through a special linking mechanism. In
such a table, only a subset of the Outlook fields are available. That's why
it's not very useful. Try it and see for yourself how frustrating it is.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
 
Gotcha, there's a feature where you can create a "link table" to
external data. For example, an SQL database owned by another
department in your company, where they won't give you the raw data but
they'll let you run queries on it (I'm paraphrasing Helen Feddema
here). You can link to it and do some primitive stuff with the data
without actually housing it inside Access.

Thx,
JP
 
Back
Top