Access Macro -

[johnseito]

In Access Macro, when you OpenQuery, you actually run the Query ?

For example, you already created a Query, so why in Access Macros, do you have it script to OpenQuery, and then Close it again with CloseWindow ?
Is it to open the query and update it ?



I can understand why there is CopyObject, because you want to copy the source to a new table and you have these two table set up.

I don't get why there is OpenQuery (example read only) and then closing it again. Is it to update the query, sorry for reiterating it.

Thanks !!

[ItsMe]

I do not know why, I never use the Open Query method because, AFAIK, it is not available during RunTime.

[johnseito]

Ok thanks for sharing !! I wonder if we don't use OpenQuery and CloseWindow, would it still work as if we did. :-)

Trying to do automation with Access Macros.

Why Access macros allow us to use OpenQuery, then CloseWindow again. Doesn't make much sense to me, unless I think it open the query to update it, and then close it again. :-)

[ItsMe]

It has been a couple months but, I remember seeing a DB that used the RunSQL method from a macro. In VBA, you can use the name of a query object with this method so I would imagine it would be the same for a saved macro object.

Here is some reference.
http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

[June7]

I suppose could have code open query, export to Excel or as attachment to email, then close it. I've only had need to program this once.

Never used CloseWindow method.

[hapm]

OpenQuery isn't very usefull for normal SELECT querys. But it gets very handy for DELETE and UPDATE, especially in combination with defined parameters for the query. The macro designer allows you to fill in the parameters in this case, what allows you to write UPDATE and DELETE queries independent from the place, you are using them (no direct references to form fields for ex.). UPDATE and DELETE queries are executed as you would double click them from the query list. If you don't want the warning methods, you will need to disable warnings first.