creating queries/reports from a form

[Eldalonde]

I was wondering if anyone knows how to get to designing a query or a report from a form. My intention is that the users will not be able to have access to building objects in a database, but if they need to create a new query or something, I would like to be able for them to access the create query design view.

I guess the question is: How do I bring the query design using code?

 

[VicRauch]

docmd.OpenQuery QueryNameHere, acViewDesign

 

[Eldalonde]

Ok, so I got that, but is there a way to create a new query instead of modifying an existing one?

 

[VicRauch]

dim qry as DAO.QueryDef
set qry = CurrentDB().CreateQueryDef("NameOfTheNewQuery", "SELECT * FROM YourTableName;")

That code will create a new query. You will need DAO referenced in your References for your VBA project. From the VBA editor, use Tools/References...

 

[Eldalonde]

I had to modify it a little for what I wanted... but it worked! Thanks!