Turn off Query Parm Prompts

[sal cifone]

Hey,

Is there any way to turn off the query parm prompts? I have a report
that must be printed for 53 different cities and the vba code loops
thru a table and passes the value to a select query. All works well
EXCEPT I see the Query Paramater dialogue box show. Any way to not
show this?

Sal

[Pieter Linden]

sa**************@adp.com (sal cifone) wrote in message news:<4b**************************@posting.google. com>...

Hey,

Is there any way to turn off the query parm prompts? I have a report
that must be printed for 53 different cities and the vba code loops
thru a table and passes the value to a select query. All works well
EXCEPT I see the Query Paramater dialogue box show. Any way to not
show this?

Sal

Sal,
how about removing the query parameters from the query altogether and
then passing the city to the WHERE clause in the OpenReport command?

DoCmd.OpenReport "MyReport", acViewPreview, , "[City]='" &
rst.Fields("City") & "'"

Then if you have the cities in a table, you could just open a
recordset of the cities you wanted, pass them to the OpenReport
method, print out the report, and go to the next city record and
repeat. (I think you have to open/close the report a zillion times...
not sure thought.)

HTH,
Pieter

[Marc]

sa**************@adp.com (sal cifone) wrote in message news:<4b**************************@posting.google. com>...

Hey,

Is there any way to turn off the query parm prompts? I have a report
that must be printed for 53 different cities and the vba code loops
thru a table and passes the value to a select query. All works well
EXCEPT I see the Query Paramater dialogue box show. Any way to not
show this?

Sal

When inspecting the parameter-list in the query-editor screen (menu
Query > parameters ...) are the some other parameters declared not
given when invoking the query ? just remove them there. They can be
declared earlier, but now not active anymore. When removed from the
the SQL-query they have to be removed too in this menu. Or are there
some field-references between []-brackets in the SQL statement that
cannot be resolved to a table-field in spite of the parameters given
when invoking the query ?

Marc

[Sal Cifone]

Marc,

I think from the responses I have been getting, my original question was
not too clear.

I have a select query that prompts for Region and Job Code. I have a
module which open a two tables and loops thru the region field and the
job code field for that region. It then exports this info into an excel
file for each region and creates a tab for each job code for the region.
Saves the file and continues to the next region in the table.

My issue is that I see the query parameter input boxes show and populate
with the region and job codes.

(I supplied a snipit of code in another reply)

I do not want to see these propmpt. Is there a way to "Not" show them?

Thanks for your help.

Sal
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!