How to add code to standard form?

I'm an Access developer and have a program that exports/imports to/from the
Outlook calendar. The request I'm trying to accommodate is the ability to
double-click on the Location field in the Appointment form and go to a
particular contact in the Access database based on the string value in the
Location field.

I can open the form in design mode, but how do I access the
events/properties of the Location field? Can this be done? Other options?

Thanks in advance.

In article <17mdnYucvYB-0D3enZ2dnUVZ_v6dnZ2d@comcast.com>, Deko wrote:
> I can open the form in design mode, but how do I access the
> events/properties of the Location field? Can this be done? Other options?
>
Go to www.slipstick.com or www.outlook-code.com and look for Access related
code examples.

Hollis D. Paul [MVP - Outlook]
Hollis@outhousebythesound.com
Mukilteo, WA USA

Since Outlook forms don't fire any kind of double-click event, I'd suggest using a COM add-in to add a toolbar button with the functionality you want.

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


"deko" <deko@nospam.com> wrote in message news:17mdnYucvYB-0D3enZ2dnUVZ_v6dnZ2d@comcast.com...
> I'm an Access developer and have a program that exports/imports to/from the
> Outlook calendar. The request I'm trying to accommodate is the ability to
> double-click on the Location field in the Appointment form and go to a
> particular contact in the Access database based on the string value in the
> Location field.
>
> I can open the form in design mode, but how do I access the
> events/properties of the Location field? Can this be done? Other options?
>
> Thanks in advance.
>
>

That sounds like the way to go - no custom form to worry about.

But what about .NET? Must I use COM?



"Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message news:%
23vfxgZQAGHA.2156@TK2MSFTNGP11.phx.gbl...
Since Outlook forms don't fire any kind of double-click event, I'd suggest using
a COM add-in to add a toolbar button with the functionality you want.


"deko" <deko@nospam.com> wrote in message
news:17mdnYucvYB-0D3enZ2dnUVZ_v6dnZ2d@comcast.com...
> I'm an Access developer and have a program that exports/imports to/from the
> Outlook calendar. The request I'm trying to accommodate is the ability to
> double-click on the Location field in the Appointment form and go to a
> particular contact in the Access database based on the string value in the
> Location field.
>
> I can open the form in design mode, but how do I access the
> events/properties of the Location field? Can this be done? Other options?
>
> Thanks in advance.
>
>

You can use Visual Studio to build add-ins that use COM interop to interface with Outlook. If you are targeting only Outlook 2003, I'd recommend using Visual Studio 2005 Tools for Office (which is included in most of the VS 2005 SKUs).

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


"deko" <deko@nospam.com> wrote in message news:NoudnSEPjbUHkjzeRVn-jA@comcast.com...
> That sounds like the way to go - no custom form to worry about.
>
> But what about .NET? Must I use COM?
>
>
>
> "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message news:%
> 23vfxgZQAGHA.2156@TK2MSFTNGP11.phx.gbl...
> Since Outlook forms don't fire any kind of double-click event, I'd suggest using
> a COM add-in to add a toolbar button with the functionality you want.
>
>
> "deko" <deko@nospam.com> wrote in message
> news:17mdnYucvYB-0D3enZ2dnUVZ_v6dnZ2d@comcast.com...
>> I'm an Access developer and have a program that exports/imports to/from the
>> Outlook calendar. The request I'm trying to accommodate is the ability to
>> double-click on the Location field in the Appointment form and go to a
>> particular contact in the Access database based on the string value in the
>> Location field.
>>
>> I can open the form in design mode, but how do I access the
>> events/properties of the Location field? Can this be done? Other options?
>>
>> Thanks in advance.
>>
>>
>
>

Yes, Office 2003 only.

I've been looking for a reason to start playing with VSTO...

Thanks for the tip.


"Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message
news:uZBARmYAGHA.3048@TK2MSFTNGP15.phx.gbl...
You can use Visual Studio to build add-ins that use COM interop to interface
with Outlook. If you are targeting only Outlook 2003, I'd recommend using
Visual Studio 2005 Tools for Office (which is included in most of the VS
2005 SKUs).

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


"deko" <deko@nospam.com> wrote in message
news:NoudnSEPjbUHkjzeRVn-jA@comcast.com...
> That sounds like the way to go - no custom form to worry about.
>
> But what about .NET? Must I use COM?
>
>
>
> "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message
> news:%
> 23vfxgZQAGHA.2156@TK2MSFTNGP11.phx.gbl...
> Since Outlook forms don't fire any kind of double-click event, I'd suggest
> using
> a COM add-in to add a toolbar button with the functionality you want.
>
>
> "deko" <deko@nospam.com> wrote in message
> news:17mdnYucvYB-0D3enZ2dnUVZ_v6dnZ2d@comcast.com...
>> I'm an Access developer and have a program that exports/imports to/from
>> the
>> Outlook calendar. The request I'm trying to accommodate is the ability
>> to
>> double-click on the Location field in the Appointment form and go to a
>> particular contact in the Access database based on the string value in
>> the
>> Location field.
>>
>> I can open the form in design mode, but how do I access the
>> events/properties of the Location field? Can this be done? Other
>> options?
>>
>> Thanks in advance.
>>
>>
>
>