I would like to be able to create an event in Outlook Calendar from VBA in
Access using late binding.

Can someone point me to sample code somewhere that would help me get
started?

Thanks for any suggestions.

Am Tue, 6 Sep 2005 23:36:28 -0400 schrieb Randy Harris:



> I would like to be able to create an event in Outlook Calendar from VBA in
> Access using late binding.
>
> Can someone point me to sample code somewhere that would help me get
> started?
>
> Thanks for any suggestions.

Late binding means that all objects are declared as Object. E.g. instead of
Dim oTask As Outlook.TaskItem
you need to write
Dim oTask As Object

I´d suggest that you add a reference on Outlook to your Access project. Then
you can use the Object Browser, it helps you finding functions, the help for
them, samples etc. E.g., you´re looking for the CreateItem function.

In the end you can remove that reference.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook

"Michael Bauer" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Am Tue, 6 Sep 2005 23:36:28 -0400 schrieb Randy Harris:
>
>
>
> > I would like to be able to create an event in Outlook Calendar from VBA
in
> > Access using late binding.
> >
> > Can someone point me to sample code somewhere that would help me get
> > started?
> >
> > Thanks for any suggestions.
>
> Late binding means that all objects are declared as Object. E.g. instead
of
> Dim oTask As Outlook.TaskItem
> you need to write
> Dim oTask As Object
>
> I´d suggest that you add a reference on Outlook to your Access project.
Then
> you can use the Object Browser, it helps you finding functions, the help
for
> them, samples etc. E.g., you´re looking for the CreateItem function.
>
> In the end you can remove that reference.
>
> --
> Viele Gruesse / Best regards
> Michael Bauer - MVP Outlook

I did as you suggested, set the reference, then got the code working. I was
subsequently able to change it to late binding. Thank you for the help.