[AccessD] Interesting VBA problem

Mark Simms marksimms at verizon.net
Wed Oct 16 09:11:19 CDT 2013


That doesn't help me at all. It works fine with early binding.
How to code for late binding when Object and EventObject won't work
WithEvents.

Right now I'm masquerading the object as a access.customcontrol, but I don't
think that's gonna work.


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of jack drawbridge
> Sent: Wednesday, October 16, 2013 9:00 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Interesting VBA problem
>
> Mark,
>
> I don;'t do much with 2010 and haven't worked at all with Outlook and
> Sync
> Object. But, I'm sitting here and googled looking for examples. I found
> thid link, which you may have seen already. Any, hoping this is useful.
> Jack
> http://msdn.microsoft.com/en-us/library/ff865672%28v=office.14%29.aspx
>
>
> On Wed, Oct 16, 2013 at 8:45 AM, Mark Simms <marksimms at verizon.net>
> wrote:
>
> > I've got an AC2010 app that must use late-binding.
> > I'm an instantiating an Outlook session.
> > However, I need to reference a SyncObject WithEvents.
> > However, what do I Dim it as ?
> > Private oSync WithEvents as Outlook.SyncObject
> >
> > Tried Private oSync WithEvents as EventObject
> > By the compiler complained !
> >
> > Dim oSync as Access.CustomControl
> >
> > That worked, but the call back will probably fail, correct ?
> >
> > Someone said it might work if I:
> > Set oSync = CreateObject("Outlook.SyncObject")
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com




More information about the AccessD mailing list