Hi All
I need to be able to let a user create a new query in a form. So I want the user to be able to click a command button and see the Create new Query Dialog Box.I have tried several runcommand options and cannot get it working
Thanks

__________________
Brendan Bartley

I'm sorry, but I have to ask WHY do you need to let a user create a new query in your program? If they need to do their own queries then it should be done from a separate linked database and they can go into the QBE grid from there.

Also, this should be a split database (frontend on user's machine and backend on the file server).

You can, however, with a lot of coding create a form which would let users select the tables and criteria and you build the query on the fly which then can be viewed. However, this should not be saved in the database (unless you save the SQL string in a table somewhere and then pull it out for them).

So what is it that you are really trying to do for the user and what would be the problem of them having a linked database where they can create all the queries they want?

__________________
Thanks,

Bob Larson
Access MVP (2008-2010, 2011)
Free Access tutorials, samples, tools

I also just want to say - I'm not trying to be difficult just for the sake of being difficult. Letting users create objects within a database is risky, not only from a standpoint of them screwing something up, but also maintainability. How do you maintain separate frontends for everyone who creates their own queries - and then how do you merge everyones frontends together so that they don't lose their stuff?

The answer may seem to be "just use a single shared frontend" which on the surface looks like a good solution. But, you don't want that for multiple users because that is a sure fire way to end up with a corrupt database and losing everything.

So, anyway, hopefully that helps with some of the "why" I posted what I did.

__________________
Thanks,

Bob Larson
Access MVP (2008-2010, 2011)
Free Access tutorials, samples, tools