Hen

This procedure create; an Access table linked to the Outiook Contact; folder,

Requirements:

Access, Excel, or Word 2000 or Greater Microsoft Outlook9,0 Object Library or higher Reference checked d jiÇ' Toolbox [Jjj] Code Librarian

LinkExchangefoldec |

Function LinkEHchangeE'oider (strTabieName) As Boolean

This procedure creates an Access tahle linked to the Outlook Contf^ts folder l':l in dbsDatabase As DAO.Database Dim tdfTable As DAO TableDef Dim strConnect As String

Const TABLE,EXISTS = 3012

On Error GoTo Link_Err

1 Set a reference to the current database. Set dbsDatabase « CurrentDb

1 Build the connection string.

strConnect = "Exchange 4 0.HAFILEVEL=" & GetMaiIbosNai & "|;TABLETYFE^O;" & "DATABASE=" & dbsDatabase.Nai

Create a TableDef object. The name specified for thf TableDev object is displayed as the name of the ixn) in the Database Kxndow. Set tdfTable = dbsDatabase.CreateTableDef(strTableNamf

With tdfTable

.Connect = strConnect SourceTableHame = strTabieName End With

Done

Figure 2.12 - The Code Librarian in Office XP Developer contains procedures for use in Outlook, Exchange, and other Office applicatbns.

Office XP Developer also includes several extrinsic ActiveX controls that you can add to your Outlook forms and distribute with your solution. Noteworthy is the DTPicker control that duplicates the functionality of the drop-down calendar control on Outlook appointment and task items.

When it comes to collaboration, other noteworthy Office XP Developer additions include the Exchange Workflow Designer and the Digital Dashboard project. The Exchange Workflow Designer (shown in Figure 2-13) provides a graphical design surface that lets you create simple workflows in a drag-and-drop environ ment. More complex workflows will require you to write code with the Workflow Designer Code Editor. Be aware that you can design workflows with Office XP Developer only on Exchange 2000 Server. Unlike the cumbersome Routing Objects on Exchange 5.5, workflows in Exchange 2000 are based on synchronous events and offer much greater control over process objects and state transitions.

When it comes to collaboration, other noteworthy Office XP Developer additions include the Exchange Workflow Designer and the Digital Dashboard project. The Exchange Workflow Designer (shown in Figure 2-13) provides a graphical design surface that lets you create simple workflows in a drag-and-drop environ ment. More complex workflows will require you to write code with the Workflow Designer Code Editor. Be aware that you can design workflows with Office XP Developer only on Exchange 2000 Server. Unlike the cumbersome Routing Objects on Exchange 5.5, workflows in Exchange 2000 are based on synchronous events and offer much greater control over process objects and state transitions.

Vba Designer Control

Was this article helpful?

0 0

Post a comment