Re: Query by form

I am now running a chain of 6 queries on queries from a form.
Everything works welland the results are all displayed in the final
query window. My question is whether there is a way to run the first 5
queries without having the query windows pop open. Right now I set the
first 5 queries to run and then close after the next query has used the
results of the prior query, however, the user will then still see the
first 5 windows flash open then close. I would prefer to simply have
only the results window for the 6th query pop open. Please let me know
if there is some setting that would make this possible.

Thanks,

Tom



Bob Quintal wrote:
"Tom" <Thomas.T.Holman@xxxxxxxxx> wrote in
news:1151683811.537481.234450@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

Bob,

I tried using that code...but then none of the choices (ex.
Male,
Female) are displayed in the combo boxes on the form, just
blank
spaces/lines. Any ideas? Thanks again.

Tom

Forget the Lizard, turn it off.

Set the following properties for the gender combobox as follows.
From the fromat tab
Column Count: 1
Column heads: No
List Rows: 2
Column Widths: 1";

from the Data tab.
Row source type: table/query
Row Source: "SELECT DISTINCT [Gender] from RecruitingSurvey
ORDER BY [Gender];"
Bound column: 1

the other properties: read the help, set as desired.

set the other Combobozes similarly.




Bob Quintal wrote:
"Tom" <Thomas.T.Holman@xxxxxxxxx> wrote in
news:1151614388.827652.112630@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

In the design view of the recruiting survey for the gender
control combo box, my SQL code is:

SELECT DISTINCT RecruitingSurvey.ID,
RecruitingSurvey.Gender
FROM RecruitingSurvey ORDER BY [Gender];

The code for the rest of the drop downs is parallel in
structure...

You do not want the recruitingSurvey.ID in the rowsource for
your ComboBox. This is why you are getting the duplicates.

SELECT DISTINCT RecruitingSurvey.Gender
FROM RecruitingSurvey ORDER BY [Gender];

Is all you want. I know the Combobox Lizard wants to put the
Id
there. If it were a Wizard it would be smart enough to know
that
it's inappropriate.

Q


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com





--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

.

Relevant Pages

  • Re: multiple SQL queries
    ... I want to run the queries automatically. ... I've written a long SQL script ... What I'm doing now is opening a query window in SQL mode, ...
    (microsoft.public.access.queries)
  • Re: multiple SQL queries
    ... This is generic code for running queries in VBA code: ... change the actual SQL statement for each ... > don't want to use a macro where I'd have to use OpenQuery, which means I'd> have to save each query individually and then put each one into a macro. ... > What I'm doing now is opening a query window in SQL mode, copying the query> text from Word, pasting it into the query window, running the query, then> going on the next query in Word. ...
    (microsoft.public.access.queries)
  • Re: Query by form
    ... final query window. ... Right now I set the first 5 queries to run and then ... it should automatically execute ...
    (comp.databases.ms-access)
  • Combo Box to return all queries in database.
    ... I developed a query that returns all queries in my database.- eg. ... What I want to do is create a combobox in a form that populates all queries ... Private Sub Combo69_AfterUpdate ...
    (microsoft.public.access.formscoding)
  • Re: Parameters removed - still get prompted for them
    ... If the query works correctly from the Query window without asking for ... This behavior in queries can be really weird, ... I agree in the dynamic creation of the SQL string via code. ...
    (microsoft.public.access.queries)