Open/Close Query Design from Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I really have several questions that are related to accessing and
manipulating queries.
1. I would like my user to be able to
(a) open the Query Design window from a modal form,
(b) have the form become invisible while the user is creating the query,
(c) have the query saved with a distinctive name, e.g. beginning
with the letters "qryLst" for example, and
(d) have the original form re-opened when the query closes.

This is somewhat more advanced programming than I have tried to date.

I would appreciate any guidance that is available. I have checked various
lists but can find nothing similar to whatb I have outlined above.
 
The most likely reason why you haven't been able to find anything
similar in your searches is, it's not common practice - and for good
reasons too. Why would you want users to mess with query designs? In an
ideal situation a user has an .mde front end, specifically so they are
not allowed to play around with any object's design. Instead, the user
interface allows the user to select/enter parameters for saved queries
on forms. Only in one extreme case did I ever have to go into query
design based on user selections (I had to save a crosstab with varying
fields) but even then did it all through code. My point is, there must
be a better way to do what you want, if you care to explain your situation.

HTH,
Nikos
 
Good points!

What I'm interested in accomplishing is to create a "build new query"
situation where the user can develop a specific query which would involved
linking two (or more) tables , save it and reuse it as the occasion. The
alternative would seem to me to be to create a 'build sql" module for myself.

This may be the better but more labourious approach and I'm inherently lazy.
 
Back
Top