Prev: Access 2007
Next: I am trying to get access to display leading zeros and auto numbe
From: PeterM on 30 Mar 2010 16:22
I've searched thru this forum and can't find exactly the issue I need to
resolve. I have developed a calendar in AC2003. I have developed a process
to export the calendar entry from access to the outlook calendar which works
great. My user is now requesting the ability to view (or thru VBA) the
entries in the Outlook calendar from within access? Unfortunately my
database has no way to know if an entry in the access database already exists
in the Outlook calendar. Is there a way to determine that?

Thanks for your time.
From: PieterLinden via AccessMonster.com on 30 Mar 2010 16:37
PeterM wrote:
>I've searched thru this forum and can't find exactly the issue I need to
>resolve. I have developed a calendar in AC2003. I have developed a process
>to export the calendar entry from access to the outlook calendar which works
>great. My user is now requesting the ability to view (or thru VBA) the
>entries in the Outlook calendar from within access? Unfortunately my
>database has no way to know if an entry in the access database already exists
>in the Outlook calendar. Is there a way to determine that?
>
>Thanks for your time.
You can attach/query most outlook objects from within Access. The quickest
way to see if this will work for you is to
File, Get External Data, Link, then change the source to Outlook... then you
can go to the Calendar and you'll get all the items in the calendar. Then it
will query just like an Access table.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access/201003/1

From: PeterM on 30 Mar 2010 18:12
Pieter...

Thanks for the information. I tried that successfully and did connect to my
calendar however, when I look at the outlook calendar it's missing the date
of the event. It has almost everything else, but no date which I need to
check for duplicates with my access database.

I used both Outlook() and Exchange() as the type for the table link and got
the same results.

What am I missing?

Thanks

"PieterLinden via AccessMonster.com" wrote:

> PeterM wrote:
> >I've searched thru this forum and can't find exactly the issue I need to
> >resolve. I have developed a calendar in AC2003. I have developed a process
> >to export the calendar entry from access to the outlook calendar which works
> >great. My user is now requesting the ability to view (or thru VBA) the
> >entries in the Outlook calendar from within access? Unfortunately my
> >database has no way to know if an entry in the access database already exists
> >in the Outlook calendar. Is there a way to determine that?
> >
> >Thanks for your time.
> You can attach/query most outlook objects from within Access. The quickest
> way to see if this will work for you is to
> File, Get External Data, Link, then change the source to Outlook... then you
> can go to the Calendar and you'll get all the items in the calendar. Then it
> will query just like an Access table.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access/201003/1
>
> .
>
From: Risse on 2 Apr 2010 02:42

"PeterM" <PeterM(a)discussions.microsoft.com> kirjoitti
viestiss�:85593D7B-5EBB-49DA-90B8-76983AB25090(a)microsoft.com...
> I've searched thru this forum and can't find exactly the issue I need to
> resolve. I have developed a calendar in AC2003. I have developed a
> process
> to export the calendar entry from access to the outlook calendar which
> works
> great. My user is now requesting the ability to view (or thru VBA) the
> entries in the Outlook calendar from within access? Unfortunately my
> database has no way to know if an entry in the access database already
> exists
> in the Outlook calendar. Is there a way to determine that?
>
> Thanks for your time.


 | 
Pages: 1
Prev: Access 2007
Next: I am trying to get access to display leading zeros and auto numbe