Query Related Questions

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

Guest

I really have several questions that are related to accessing and
manipulating queries. There are (in no particular sequence):

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.

2. I would also like to access (Read/Write) the "Description" property of a
query as displayed in the query list. I would use this property to fill a
list box with appropriate queries which the user can access.

I would appreciate any guidance that is available. I have checked various
lists but can find nothing similar to whatb I have outlined above.
 
All of it requires VBA coding. If you are familiar with it, then try
looking for information in the help file about the OpenQuery method, and the
QueryDef object.

The formscoding newsgroup is better suited for VBA questions, too.
 
Back
Top