Query Dialog Window

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

box2003 - 26 Feb 2006 13:48 GMT

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.

Reply to this Message

Amy Blankenship - 26 Feb 2006 15:27 GMT

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

> 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
[quoted text clipped - 7 lines]
>
> Thank you.

Reply to this Message

box2003 - 26 Feb 2006 15:49 GMT

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.

> What is the purpose of having the user design the query from a form?
>
[quoted text clipped - 9 lines]
> >
> > Thank you.

Reply to this Message

Duane Hookom - 26 Feb 2006 16:06 GMT

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,...

Signature

Duane Hookom
MS Access MVP
--

> 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
[quoted text clipped - 7 lines]
>
> Thank you.

Reply to this Message