How to create a query in a macro

[jerryc1]

I want to create a query using a macro or hide the query from view in the
database window

 

[rtviper]

Right Click on the qry and set the property to Hidden

 

[rtviper]

Hidden or not they still run when called from a function or code or macro

 

[Steve Schapel]

Jerry,

In general, the principle to follow here is to not allow the users of
your application to have access to the Database Window, and as such
whether a query is visible or not is irrelevant.