Adding the Workflow Toolbar Control to a Web Page

See Also

You can add the Workflow Toolbar control to your Web page to enable the following features for your user interface:

• A workflow menu bar that shows the workflow actions available for the records in the team solution. This toolbar is dynamically generated based on the workflow state-machine on the server.
  
  
• Ability to select and subscribe to an SQL publication to use the team solution offline.
  
  
• Automatic redirection of database connections to a local store when working offline.

The Workflow Toolbar control has properties, methods, and events that make it possible for you to display or hide toolbar options and use these features independently or together. For more information about using the toolbar control, see Workflow Toolbar Control.

Note   If your team solution includes offline support and you do not use the Workflow Toolbar control in your data access pages, you must create the offline redirection script manually. For more information, see Adding Code to a Data Access Page for Offline Redirection.

To use the Workflow Toolbar control in your user interface, you must consider the following requirements:

• For the toolbar to display the workflow actions on the data access page, the UniqueTable property must be set to the base table containing the workflow actions.

  Note   If your data access page is based on a table, the UniqueTable property may bind to dbo.[Tablename]. You must remove the “dbo.” and the brackets for the toolbar control to function properly.

• A field bound to the workflow state column must be included on the data access page in either the first section or the section specified in the toolbar’s RecordSource property. This field can be hidden.

To add the Workflow Toolbar control to a data access page

1. Open your team solution database as an Access project (*.asp).
   
   
2. Open your data access page in Design view.
   
   
3. If you have not already, set the UniqueTable property to the base table for the view you are using.
   
   
4. Verify that a field bound to and named for the workflow state column exists on the page. This field can be hidden.
   
   
5. Click in the top portion of the data access page.
   
   
6. From the Insert menu, select ActiveX Control, and double-click Microsoft Office Developer Workflow Toolbar.

   The toolbar control is added to the page and automatically binds to the workflow rules by inspecting the UniqueTable property on the data source control.

7. Save the page.
   
   
8. From the File menu, select Web Page Preview to see the toolbar.

For information on saving the data access page to your solution Web site, see Saving a Data Access Page to a Web.