How to create an enduser query form

E

ettropics

Newcomer
Joined
Feb 20, 2003
Messages
8
I would like the endusers to be able to click a button and create his/her own queries using a windows form.

The endusers are used to being able to create queries on the fly in an Access database that we are moving away from. And the new database is in SQL and VB.net.

Any ideas on how to accomplish this query form?

TIA
 
Most of this can be done with great ease if they will create the query based on one table, but if you want them to build on multiple tables using Joins, it won't be so simple.
 
This will need to be done where they can query multiple tables. Is this something that can be done through Crystal Reports? I am unfamiliar with this so please bear with me.

Thanks for your input
 
You said ... the endusers to be able to click a button and create his/her own queries using a windows form. "

Will you provide Field names (in a ComboBox) and a textbox where they can enter a value, or something like that?

I may have miss-understood, can you explain.
 
enduser query form

If it is possible, I would like for them to be able to click a button on the main form that will open up a query form ...

basically after that I would like to make it as simple as possible. Something along the lines of creating a query in Access, where they can choose the tables and create the query from there involving joins, etc.

combo boxes for selecting tables
combo boxes for selecting fields
ability to join tables, etc.

I am starting at ground zero, so any suggestions, etc. are welcome.

Thank you...
 
Back
Top