Re: Query prompts twice for same parameters

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 03/21/05 

Date: Mon, 21 Mar 2005 12:50:05 -0600

Try this link http://www.fontstuff.com/access/acctut08.htm 

-- 
Duane Hookom
MS Access MVP
"Tim" <Tim@discussions.microsoft.com> wrote in message 
news:0BAD32AB-013A-4205-ACBB-F94DDB3ECE54@microsoft.com...
>I am not very familiar with forms, just started learning about them.
> I will try your suggestion though.
> Any suggestions or ideas will be very much appreciated.
>
> Thank you,
> Tim
>
> "Duane Hookom" wrote:
>
>> Don't know why you get the multiple prompts. Have you considered upping 
>> the
>> user experience by using controls on a form rather than parameter 
>> prompts?
>>
>> -- 
>> Duane Hookom
>> MS Access MVP
>> --
>>
>> "Tim" <Tim@discussions.microsoft.com> wrote in message
>> news:B6D0A32D-665F-4720-819F-8D9387DBF570@microsoft.com...
>> > In Access 2000 (SP3), running in Windows 2000 Professional SP4) I 
>> > create
>> > and
>> > save a query with user entered parameters.  This is for a single table
>> > using
>> > the, below, SELECT query.  At this  point the query runs fine.
>> > Sometimes, not always, cannot figure out why, if I make a change in the
>> > query (e.g. change the which of two fields appears first, or change the
>> > prompt from entering a single date to a between start date and end 
>> > date)
>> > the
>> > query starts asking for the user prompt twice.
>> > The first entry is ignored.  Whenever the prompts appear twice, if I 
>> > enter
>> > different values for the two prompts only the value from the second 
>> > prompt
>> > is
>> > used in executing the query.
>> > The query on which this scenario occured, for both conditions listed:
>> > SELECT DISTINCT Table1.[Serv Nbr] AS [SO #], Table1.EquipID AS SN,
>> > Table1.[Cust Nbr] AS [Customer #], Table1.[Cust Sortname] AS [Customer
>> > Name],
>> > Table1.[Close Dt] AS [Closed Date], Table1.[Tech Sortname] AS [Tech 
>> > Name],
>> > Table1.[Problem Cd]
>> > FROM Table1
>> > WHERE (((Table1.[Closed Date]) Between [Start Date - m/d/yyyy] And [End
>> > Date
>> > - m/d/yyyy]))
>> >
>> > There have been a number of discussions on this issue where the sort 
>> > order
>> > was the reason, but there is no sort on this query.
>> > Also, the query will run fine when I open Access then, when I change 
>> > the
>> > order of appearance for two fields, it will start prompting twice.  I 
>> > will
>> > close Access, restart it and the query will work fine.
>> > Any ideas?
>>
>>
>>

Relevant Pages

  • Re: Beginner query help please
    ... MS Access MVP ... Duane Hookom wrote: ... I've noticed that if you select all the query output (in this ... Controls in most query solutions would not be ignored. ...
    (microsoft.public.access.queries)
  • Re: Beginner query help please
    ... MS Access MVP ... I've noticed that if you select all the query output (in this case ... Duane Hookom wrote: ... Controls in most query solutions would not be ignored. ...
    (microsoft.public.access.queries)
  • Re: Formula will not work with mail merge
    ... There is code that does this in the Query By Form ... > How do I push the records to a separate Word Merge format file? ... >> Duane Hookom ... >> MS Access MVP ...
    (microsoft.public.access.queries)
  • Re: Crosstab Report
    ... MS Access MVP ... I try to write the report my headings/totals crash. ... "Duane Hookom" wrote: ... some of the information you posted to the query and found it very ...
    (microsoft.public.access.reports)
  • Re: Refer to a form in a pass-through query
    ... MS Access MVP ... Duane - you mentioned that I need to modify the SQL property of the p-t ... "Duane Hookom" wrote: ... The name of the query is PKLQ. ...
    (microsoft.public.access.queries)