Re: Why does my parameter query repeat?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Viescas (JohnV_at_nomail.please)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 15:55:08 -0600

This behavior will happen sometimes when you use a parameter query in a
report - many reports pass through the data more than once and, therefore,
run the query more than once.

It should not happen in a query where you explicitly declare the parameters.
Choose Parameters from the Query menu or include a PARAMETERS clause at the
beginning of the SQL. It's a good idea to always declare parameters. In
some cases (e.g. a Crosstab query), the query won't run unless you declare
the parameters. 

-- 
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
"gsmith4000@yahoo.com" <anonymous@discussions.microsoft.com> wrote in
message news:d74a01c40ab4$7c1134f0$a401280a@phx.gbl...
> Hello--
>
> Why would a parameter query repeat the same parameters
> twice? Two different queries are having this same problem.
> It'll prompt the user for Tracking Number, then Employee.
> After the user types in the values, it then prompts them
> all over again. Aggravating? You bet!
>
> The only way I've found to "fix" this problem is to delete
> the offending query and start over.
>
> There must be a better way... Thanks as always.
>
> --Gary

Relevant Pages

  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Query/Date Question
    ... declare them as such. ... of regional date format differences. ... I have created a report, rptTestCount, from a right join query, qryTestCount ...
    (microsoft.public.access.queries)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)
  • RE: subtraction
    ... You can also manually check the Microsoft Access executable version number ... I'm using access 2000 and windows XP ... >>> The query is too complex to be opened in the QBE grid. ... >>> as a Record Source for either a report or a form, so I'm not sure why you are ...
    (microsoft.public.access.reports)