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

On Sep 4, 2:47*pm, Henry wrote:
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

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.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Henry" wrote:

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?

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" wrote:

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

On Sep 4, 2:47 pm, Henry wrote:
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

I'm confused, I thought you are trying to read appointments in
Outlook? Here is a list of all the properties you can read, including
Start and End which represents the start date/time and end date/time
for a given appointment or meeting.

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

--JP

On Sep 5, 11:37*am, Henry wrote:
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" wrote:
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

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




"JP" wrote:

I'm confused, I thought you are trying to read appointments in
Outlook? Here is a list of all the properties you can read, including
Start and End which represents the start date/time and end date/time
for a given appointment or meeting.

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

--JP

On Sep 5, 11:37 am, Henry wrote:
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.

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


On Sep 9, 10:02 pm, Sue Mosher [MVP-Outlook]
wrote:
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

"JP" wrote:
I'm confused, I thought you are trying to read appointments in
Outlook? Here is a list of all the properties you can read, including
Start and End which represents the start date/time and end date/time
for a given appointment or meeting.

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

--JP