creating Queries within a module and hiding them

[zevw]

I am creating a query within a module and I would like to set the attribute as hidden as you would do to a regular query in the queries tab, when clicking on properties and then placing a check in hidden. How can I do that within a module. I tried "queryname.hide" it doesn't work, I tried "queryname.visible = False" it also does not work. Smart people out there I need a solution.

 

[Cagliostro]

I can't understand. You can execute every sql strings from a VBA module as
DoCmd.RuSQL "drop table xxx" John Fill

ivfmd@mail.md

 

[CPUburn]

hi y'all,

john, I can't agree with you: suppose I want to make up a complex report based on a bunch of tables, which i cannot put into one query, then I create a partial query which i join with the other tables needed. Problem seems to be indeed there's no way to hide a query in code.

Question is now: why would you want to hide the query?? is it a temporary one (eg as recordsource for a report/form...) , then create it and delete it as soon as you no longer need it, if else, depends on the situation. Could you give us some more info?

grts

cpu-burn

 

[zevw]

Hi Guys

I posted my question on Access Modules (VBA Coding) Forum the next day, and
I got some real good ideas. Check it out

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/27/pid/181/qid/103631

 

[HenryAnthony]

zevw,

I have searched help for hide query and can find no reference to a property or methods. I think you can't do it. As others have written, why would you want to do this. In any app I have written I hide the database window from users. The less they see the better. Also, design permissions are not allowed, they would just screw things up. Just guessing, but I think your problem lies more in reports that are based on querydefs that you manipulate through code.

I don't mean to be negative, I just think, that in your best interest, you are barking up the wrong tree. Please, if anyone can, prove me wrong and find a solution to this problem.

Best regards,

Henr¥

 

[Cagliostro]

I can't understand, why to hide a query? You can set database password. ODBC and COM has possibilities to run everything from other programs. Which code you do not want to see others, you just can put in a text file anr run it dinamically. Also you can set right to different users to see/open/run/edit quieries. What else do you need? John Fill

ivfmd@mail.md