Stephen Rutz                                                 
Baltimore, MD


Anyone having questions or would like to collaborate on a workflow application may contact me by phone or email.
Documented Workflow Applications: MS-Access 2000 Version Internet Version
Basic recipe' for creating a workflow application:
  • Create a table with all users identified. Include a field for the user's windows logon.
  • Create a table that contains the conditions for notifying a user by email.
  • Create a table of default routing records that are inserted into a routing table when conditions in the condition table are found to be true.
  • Arrange for Outlook to send email to the next recipient in the routing as each person reviews the document and clicks a Yes box which records his windows logon and time stamp - the user's signature. The email should contain a hyperlink to the document to be reviewed. The email could contain an html button that opens a MS-Access Form or Windows form.
  • Assign tasks to users using their windows logon. Have the task list appear when the user opens a software application. The Windows GetUserName API is used to create the task list from the open task assignments.

  • Possible Workflow Scenario
  • Employees are selected for document review based on project details such as location, cost, product type or other identifying information that would enable selection of specific personnel. For instance a manager may want to review and approve all documents having project costs that exceed a certain amount.
  • As each employee reviews the document his Windows Logon ID is used as an identifying ‘signature’. The signature is recorded along with the date and time, providing a history of when, and who reviewed a document.
  • Subsequent employees in the routing are notified by email of their “turn” to review a document. The email contains a link to the document so that it opens immediately.

  • Documented Workflow Applications: MS-Access Version Internet Version

    Slice and Dice Reporting System
    1. See what's been sold! See sales data summarized:
          By Product, Customer, Salesman
          By Salesman, Customer, Product

    2. Filter and Sort data using a user friendly dialog.
    3. Summary Reporting / Slice and Dice Reporting Dialog
       4. (Free Download: MS-Access 2000 Reporting System)

    White Paper: An application that utilizes Forms within eMail

    Steve Rutz