Running Total Access Stats Queries in A Macro

[Elisha]

I'm using Access 2000 and have written several queries in the Total Access Statistics 2000 Add-in. Is there any way to run these in a macro? I don't see any predefined. I was told that you can probably write a VBA macro (module in Access) to do this and then RunCode from Access. Anyone know if this works and/or have any samples? Thanks.

 

[mdmilner]

You probably want OpenQuery or RunSQL to do this via Macros.
VBA/Macros can be quite similar. Many VBA methods are in actuality Macro commands.

As a suggestion, setup a command as a Macro and then use the Conversion utilty under the Tools Menu to convert it to VBA. Take a look, figure out how it works, and learn from there.

Mike

 

[Elisha]

Anyone else? Thanks.

 

[bat17]

What have you tried and what results did you get?

Peter

 

[Elisha]

Nothing so far. I don't really know VBA at all - know more how to change other peoples' macros though. I have no idea how VBA would even call the Total Access Stats queries.

 

[bat17]

I have no Idea what Total Access Stats queries are but to open a query and show its data you use a command like
DoCmd.OpenQuery "qryShowData"
where "qryShowData" is the name of the query.
This code would go behind the click event of a button on a form for example.

If you want you can create the buttun using the wizard and that will take you through it step by step.

If you want to do something other than just open the query datasheet then you will have to give us a bit more detail of what you need.

Peter