Retrieve meeting date and time

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 <He....DeleteThis@discussions.microsoft.com> 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/library/aa210899(office.11).aspx

--JP

On Sep 5, 11:37 am, Henry <He....RemoveThis@discussions.microsoft.com> 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/library/aa210899(office.11).aspx
>
> --JP
>
> On Sep 5, 11:37 am, Henry <He....TakeThisOut@discussions.microsoft.com> 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] <sue... DeleteThis @outlookcode.com>
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/library/aa210899(office.11).aspx
>
> > --JP
>