Execute a query

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

Guest

We have recently converted a database from Lotus Approach to MS Access. We
are trying to create queries in order to search 6/7 fields. We see that we
can create queries using the wizard, but cannot figure out how to execute the
query. Based on what the built in help suggests, we are to click on the "!"
button however, it is not displayed and we cannot seem to be able to add it
to the tool bar.
Please help!
 
Gregg said:
We have recently converted a database from Lotus Approach to MS
Access. We are trying to create queries in order to search 6/7
fields. We see that we can create queries using the wizard, but
cannot figure out how to execute the query. Based on what the built
in help suggests, we are to click on the "!" button however, it is
not displayed and we cannot seem to be able to add it to the tool bar.
Please help!
Click to expand...

Are these SELECT queries or Action queries (Update or Append)? For either type
if you want to open them (SELECT) or run them (Action) just double-click them in
the db window. If you have them open in design view you would use the [ ! ]
toolbar button for action queries and just switch to datasheet view for a select
query. In VBA code...

DoCmd.OpenQuery "SelectQueryName"
CurrentDB.Execute "ActionQueryName", dbFailOnError
 
On Mon, 27 Jun 2005 16:59:02 -0700, Gregg de Boisblanc <Gregg de
We
are trying to create queries in order to search 6/7 fields. We see that we
can create queries using the wizard, but cannot figure out how to execute the
query.
Click to expand...

You don't need to "execute" a search query (an Action query, such as
an Append query to add new records or an Update query to change
existing ones, is a different story).

A search query can be opened by doubleclicking, or (better) you can
base a Form on the query (just as you would base a form on a table) to
display data onscreen; or base a Report on the same query, for
printing.

John W. Vinson[MVP]
 
Back
Top