A Microsoft Office (Excel, Word) forum. OfficeFrustration

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 » OfficeFrustration forum » Microsoft Outlook » Contacts
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

viewing database info in custom contact form



 
 
Thread Tools Display Modes
  #1  
Old June 15th, 2004, 06:02 PM
Mike Abrahamson
external usenet poster
 
Posts: n/a
Default viewing database info in custom contact form

I have a public contacts folder in OL2003 and EX2003/2000. I am designing a
custom form as the default for this folder that will include several custom
fields, one of which will be an "Entity ID" field. This field will contain
a unique number for many of the contacts in the public folder but not all.
Some of the contacts won't have any data in this field at all - but may have
a unique Entity ID assigned in the future.

I also am building an Access database that will contain all of these
contacts, along with sales and other info. I would like to link the Outlook
contacts with their database records somehow (using the Entity ID number),
either by creating a multipage tab control in the custom contact form to
show various items from the database or using SharePoint Services to
accomplish the same goal.

Is there a way to show external Access or Excel data in an Outlook form
linked in this way or will I have to figure out a way to use SharePoint
instead? Can anyone point out the pros/cons of such an approach if it is
possible to use the custom form to display this database info?

Thanks,
Mike Abrahamson


  #2  
Old June 15th, 2004, 06:08 PM
Mike Abrahamson
external usenet poster
 
Posts: n/a
Default viewing database info in custom contact form

Sorry that I posted this in the wrong group. I won't cross-post but it
belongs in the microsoft.public.outlook.program_forms group.

Apologies!
Mike


"Mike Abrahamson" wrote in message
...
I have a public contacts folder in OL2003 and EX2003/2000. I am designing

a
custom form as the default for this folder that will include several

custom
fields, one of which will be an "Entity ID" field. This field will

contain
a unique number for many of the contacts in the public folder but not all.
Some of the contacts won't have any data in this field at all - but may

have
a unique Entity ID assigned in the future.

I also am building an Access database that will contain all of these
contacts, along with sales and other info. I would like to link the

Outlook
contacts with their database records somehow (using the Entity ID number),
either by creating a multipage tab control in the custom contact form to
show various items from the database or using SharePoint Services to
accomplish the same goal.

Is there a way to show external Access or Excel data in an Outlook form
linked in this way or will I have to figure out a way to use SharePoint
instead? Can anyone point out the pros/cons of such an approach if it is
possible to use the custom form to display this database info?

Thanks,
Mike Abrahamson




  #3  
Old June 15th, 2004, 06:20 PM
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: n/a
Default viewing database info in custom contact form

You would have to write code to connect to the database and display record
date in controls that you'd add to the form. See
http://www.outlookcode.com/d/database.htm . For Windows SharePoint Services
data, you'd use WebDAV, not ADO.

FYI, there is a separate newsgroup for Outlook forms issues --
microsoft.public.outlook.program_forms.

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


"Mike Abrahamson" wrote in message
...
I have a public contacts folder in OL2003 and EX2003/2000. I am designing

a
custom form as the default for this folder that will include several

custom
fields, one of which will be an "Entity ID" field. This field will

contain
a unique number for many of the contacts in the public folder but not all.
Some of the contacts won't have any data in this field at all - but may

have
a unique Entity ID assigned in the future.

I also am building an Access database that will contain all of these
contacts, along with sales and other info. I would like to link the

Outlook
contacts with their database records somehow (using the Entity ID number),
either by creating a multipage tab control in the custom contact form to
show various items from the database or using SharePoint Services to
accomplish the same goal.

Is there a way to show external Access or Excel data in an Outlook form
linked in this way or will I have to figure out a way to use SharePoint
instead? Can anyone point out the pros/cons of such an approach if it is
possible to use the custom form to display this database info?

Thanks,
Mike Abrahamson




 




Thread Tools
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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:52 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.