Total Access Statistics is the most powerful data analysis program for Microsoft Access. It runs as an Access add-in and offers a wide range of statistical functions to analyze your data.
Can I run a Total Access Statistics scenario from a macro?
Yes, you can run a Total Access Statistics scenario from a macro. To do so, refer to the "Advanced Topics" chapter of the Total Access Statistics manual. You must understand how to prepare your database to reference the Total Access Statistics library, the definition of the TAS_Statistics function, and each of its parameters.
Create a macro and add a RunCode action. In the function name section, enter "=TAS_Statistics" and its parameters. For instance:
=TAS_Statistics(5, "", "", "", True)
where 5 is the scenario number, and True sets the MsgDisplay parameter (True displays progress info to the user, False hides it completely).