MOD2000: Unable to Add a Record When You Set LockFieldsBeforeEdit Property of Workflow Toolbar Control at Run Time (249351)



The information in this article applies to:

  • Microsoft Office 2000 Developer

This article was previously published under Q249351

SYMPTOMS

You are unable to add a record to the workflow main table by clicking the New Workflow Toolbar Control button.

CAUSE

You have set the LockFieldsBeforeEdit property of the Workflow Toolbar Control at run time.

RESOLUTION

Set the LockFieldsBeforeEdit property only at design time.

STATUS

This is a known issue with Access Workflow Designer.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. On a computer that has the developer components installed, register a database in Access Workflow Designer.
  2. Add a main table, and then add workflow to the main table.
  3. Create a page. Be sure to select the appropriate fields (including the modStateID field) from the associated view. Set the UniqueTable property of the page header to the base table (on the Data tab).
  4. Click the page header. Insert the Workflow Toolbar Control.
  5. Right-click an empty spot of the page, and then on the shortcut menu, click Microsoft Script Editor.
  6. In the Script Outline window, expand the ActiveXCtl0 item (ActiveXCtl0 is the default name for the Workflow Toolbar Control. If this is not the Workflow Toolbar Control's name, expand the item under the appropriate object name.)
  7. Double-click the Click Action. Type ActiveXCtl0.LockFieldsBeforeEdit = False.
  8. Save the script, and then quit the Script Editor.
  9. Save the page in the database, and then save it to the Web folder.
  10. On a computer with the client components installed, browse to the page that you saved in the Step 9.
  11. Click the New button on the Workflow Toolbar Control. Note that you cannot add a new record.
  12. On the development computer, open the page, and then comment out the line of code that you added in Step 7. The line of code should now look as follows:

    'ActiveXCtl0.LockFieldsBeforeEdit = False

  13. Save the script, and then quit the Script Editor.
  14. Save the page.
  15. On a computer that has the client components installed, browse to the page.
  16. Click the New button on the Workflow Toolbar Control. Note that you can now add a new record.

Modification Type:MajorLast Reviewed:7/31/2001
Keywords:kbbug kbWorkFlowDesigner KB249351