A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

BCM Linked Record



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old May 12th 06, 03:12 PM posted to microsoft.public.outlook.program_vba
Guy
external usenet poster
 
Posts: 12
Default 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


  #2  
Old May 12th 06, 03:28 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default 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


  #3  
Old May 12th 06, 07:47 PM posted to microsoft.public.outlook.program_vba
Guy
external usenet poster
 
Posts: 12
Default 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



  #4  
Old May 12th 06, 07:48 PM posted to microsoft.public.outlook.program_vba
Guy
external usenet poster
 
Posts: 12
Default 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



  #5  
Old May 12th 06, 08:17 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default 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



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
import access odbc linked table to outlook Jeff Outlook - Using Contacts 6 May 12th 06 04:51 PM
Button linked to a file in Calendar? John Outlook and VBA 3 March 21st 06 06:58 PM
Delete Record Roy T Outlook - Calandaring 4 March 16th 06 03:15 PM
Forms linked to access Lai Outlook - Using Forms 3 February 27th 06 11:25 PM
copy a record to another folder Bobbi Z Outlook - Using Contacts 3 February 10th 06 09:45 PM


All times are GMT +1. The time now is 11:17 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.