Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   BCM Linked Record (http://www.outlookbanter.com/outlook-vba/14530-bcm-linked-record.html)

Guy May 12th 06 03:12 PM

BCM Linked Record
 
Does anyone know what member of the TaskItem is used for the Linked Account or Business Contact? I don't mean the Contacts Link at the bottom of the task form which uses the Links property.

I'm trying to build a routine that will get the linked account or business contact and fill in the link property on a task by clicking a custom button on the task form.

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com



Sue Mosher [MVP-Outlook] May 12th 06 03:28 PM

BCM Linked Record
 
AFAIK, none. BCM uses its own database with relationships defined among the database tables. You'd have to reverse engineer it to make use of those relationships.

FWIW, it annoys me that BCM doesn't use the built-in Links collection in addition to the database tables.

--
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

"Guy" wrote in message news:NQ%8g.8860$Qq.1472@clgrps12...
Does anyone know what member of the TaskItem is used for the Linked Account or Business Contact? I don't mean the Contacts Link at the bottom of the task form which uses the Links property.

I'm trying to build a routine that will get the linked account or business contact and fill in the link property on a task by clicking a custom button on the task form.

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com



Guy May 12th 06 07:47 PM

BCM Linked Record
 
Do you know if they plan on any changes in version 3?

If they don't expose this stuff to VBA or severely change BCM to be
customized, I'm going to abandon it soon. I really like it but this aspect
of it really stinks.

PS - I love you Programming for Outlook book, Sue.

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com


"Sue Mosher [MVP-Outlook]" wrote in message
...
AFAIK, none. BCM uses its own database with relationships defined among the
database tables. You'd have to reverse engineer it to make use of those
relationships.

FWIW, it annoys me that BCM doesn't use the built-in Links collection in
addition to the database tables.

--
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

"Guy" wrote in message
news:NQ%8g.8860$Qq.1472@clgrps12...
Does anyone know what member of the TaskItem is used for the Linked Account
or Business Contact? I don't mean the Contacts Link at the bottom of the
task form which uses the Links property.

I'm trying to build a routine that will get the linked account or business
contact and fill in the link property on a task by clicking a custom button
on the task form.

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com




Guy May 12th 06 07:48 PM

BCM Linked Record
 
Sue, you got me thinking. Could you run a SQL Query from VBA to retrieve
this information from the BCM database?

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com


"Sue Mosher [MVP-Outlook]" wrote in message
...
AFAIK, none. BCM uses its own database with relationships defined among the
database tables. You'd have to reverse engineer it to make use of those
relationships.

FWIW, it annoys me that BCM doesn't use the built-in Links collection in
addition to the database tables.

--
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

"Guy" wrote in message
news:NQ%8g.8860$Qq.1472@clgrps12...
Does anyone know what member of the TaskItem is used for the Linked Account
or Business Contact? I don't mean the Contacts Link at the bottom of the
task form which uses the Links property.

I'm trying to build a routine that will get the linked account or business
contact and fill in the link property on a task by clicking a custom button
on the task form.

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com




Sue Mosher [MVP-Outlook] May 12th 06 08:17 PM

BCM Linked Record
 
Certainly, once you reverse-engineer the database to understand how it's all organized.

Glad you like the book! I'm starting to work on the Outlook 2007 edition.

I don't have any information to share on BCM v3. Presumably, it will be out with the Office 2007 Beta 2 fairly soon.

--
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

"Guy" wrote in message news:eU39g.8919$Qq.5766@clgrps12...
Sue, you got me thinking. Could you run a SQL Query from VBA to retrieve
this information from the BCM database?



"Sue Mosher [MVP-Outlook]" wrote in message
...
AFAIK, none. BCM uses its own database with relationships defined among the
database tables. You'd have to reverse engineer it to make use of those
relationships.

FWIW, it annoys me that BCM doesn't use the built-in Links collection in
addition to the database tables.

"Guy" wrote in message
news:NQ%8g.8860$Qq.1472@clgrps12...
Does anyone know what member of the TaskItem is used for the Linked Account
or Business Contact? I don't mean the Contacts Link at the bottom of the
task form which uses the Links property.

I'm trying to build a routine that will get the linked account or business
contact and fill in the link property on a task by clicking a custom button
on the task form.

--
Guy
Forefront Business Solutions
www.forefrontbusinesssolutions.com
www.forefrontbusiness.com





All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com