VBA Programmatic Interface

Total Access Statistics includes a programmatic interface for Access VBA programmers who want to incorporate statistical functions directly into Access applications. The Code Generator even provides the code you need.

Options allow you to "hide" Total Access Statistics so your users don't realize how you implemented such complex formulas! Total Access Statistics includes a runtime library and royalty-free distribution license to distribute your applications economically to non-Total Access Statistics owners. See the License Agreement for details.

Total Access Statistics Wizard even includes a Code Generator, which writes the code you need to add statistical analysis and probability calculations to your applications.

Statistics Function

Total Access Statistics includes a special VBA function (TAS_Statistics) to add to your code:

• Create the scenario in the database with the data to analyze
• Determine the scenario number of the scenario desired
• Reference the royalty-free Total Access Statistics runtime library
• Invoke the Total Access Statistics function with the scenario number

When you execute this function, it returns a value of TRUE or FALSE depending on whether the analysis succeeded. You can optionally hide Total Access Statistics from your users while it's running, and simply show the results in your form or report.