Launch Query Builder from a Command Button

[pcampos]

Hi there...

I am proabbly missing something very simple but I would like to put in my form a button that when clicked will launch the query builder wizard so that the end user can build their own queries?

part two: I would like the above to be done but not allow the end user to save their query?

Thanks

 

[John Big Booty]

Perhaps the sample posted here is what you are looking for?

 

[boblarson]

One thing -

It is a very, very bad idea to have users building their own queries within your database. You should provide them a side application to do that. The reasons?

1. The database should be split, meaning a backend on the server which consists of tables only. The frontend is a COPY and on each user's computer. You develop on a master copy of the frontend and replace it for users when you release new changes (you can use an auto updater to do that and I have one free on my website).

2. If you do have it set up properly FE/BE and then when replacing the frontend you would blow away their user defined queries. So, that wouldn't be good.

3. But if they have their own "side database" where they can build away - that doesn't have to be replaced. It can just be linked to the data in your database and then they can use it for building their own queries.