Query Dialog Window

[box2003]

Is there a method for opening this dialog window using programming code
within an Access DB? I have a form that I want to allow a user to open this
dialog window to permit users to build a query. If there is a better way of
accomplishing something like this, I am open to that also.

The end user application is a Access DB in the Access Runtime environment,
version Access 2003.

Thank you.

 

[Amy Blankenship]

What is the purpose of having the user design the query from a form?

 

[box2003]

The form is actually a switchboard type of form that will allow a user the
ability to open the query dialog window so they can use point and click
method of building a query.

 

[Duane Hookom]

There is a fairly complete query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane which
allows users to create their own query/reports without having to understand
your tables and relationships. They can select descriptive field names, set
sorting, criteria, grouping, etc. Results are a couple clicks from sending
to CSV, text, Word Table, Word Merge, Excel, HTML, graph,...