Microsoft Office Forums


Reply
Thread Tools Display Modes

why does query ask for input criteria twice

 
 
Vanessa
Guest
Posts: n/a
 
      06-13-2006, 11:44 PM
I have a query with a criteria that contains

like "*" & [Enter Venue] & "*"

When the query is run, the prompt to 'enter venue' is repeated after the
information has been entered - how can I stop this?
 
Reply With Quote
 
 
 
 
Jeff Boyce
Guest
Posts: n/a
 
      06-14-2006, 12:01 AM
Vanessa

The most common reason this happens is because there's a spelling mistake
somewhere, and Access is actually asking two separate questions/prompts.

What happens if you re-create the query from scratch and use the criterion
you described?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Vanessa" <Vanessa @discussions.microsoft.com> wrote in message
news:EEC8E9C6-CF7E-4C4A-B4BE-(E-Mail Removed)...
>I have a query with a criteria that contains
>
> like "*" & [Enter Venue] & "*"
>
> When the query is run, the prompt to 'enter venue' is repeated after the
> information has been entered - how can I stop this?



 
Reply With Quote
 
 
 
 
Gary Walter
Guest
Posts: n/a
 
      06-14-2006, 09:29 AM

"Vanessa" wrote:
>I have a query with a criteria that contains
>
> like "*" & [Enter Venue] & "*"
>
> When the query is run, the prompt to 'enter venue' is repeated after the
> information has been entered - how can I stop this?


In addition to Jeff's sage advice...

You might double-check whether you have
applied some sorting while viewing the results
previously, then saved the query.

When you view the results of your query,
go to top menu and in "Records" dropdown,
click on "Remove Filter/Sort"

The query was prompting you first when
executing the query, then a second time
when it tried to apply this "external" sort.



 
Reply With Quote
 
Jeff Boyce
Guest
Posts: n/a
 
      06-14-2006, 03:51 PM
Gary

?!"sage" -- doesn't that imply grey and grizzled?

<G>Jeff

"Gary Walter" <(E-Mail Removed)> wrote in message
news:O%(E-Mail Removed)...
>
> "Vanessa" wrote:
>>I have a query with a criteria that contains
>>
>> like "*" & [Enter Venue] & "*"
>>
>> When the query is run, the prompt to 'enter venue' is repeated after the
>> information has been entered - how can I stop this?

>
> In addition to Jeff's sage advice...
>
> You might double-check whether you have
> applied some sorting while viewing the results
> previously, then saved the query.
>
> When you view the results of your query,
> go to top menu and in "Records" dropdown,
> click on "Remove Filter/Sort"
>
> The query was prompting you first when
> executing the query, then a second time
> when it tried to apply this "external" sort.
>
>
>



 
Reply With Quote
 
Duane Hookom
Guest
Posts: n/a
 
      06-14-2006, 04:02 PM
Yep...

--
Duane Hookom
MS Access MVP

"Jeff Boyce" <(E-Mail Removed)> wrote in message
news:u%(E-Mail Removed)...
> Gary
>
> ?!"sage" -- doesn't that imply grey and grizzled?
>
> <G>Jeff
>
> "Gary Walter" <(E-Mail Removed)> wrote in message
> news:O%(E-Mail Removed)...
>>
>> "Vanessa" wrote:
>>>I have a query with a criteria that contains
>>>
>>> like "*" & [Enter Venue] & "*"
>>>
>>> When the query is run, the prompt to 'enter venue' is repeated after the
>>> information has been entered - how can I stop this?

>>
>> In addition to Jeff's sage advice...
>>
>> You might double-check whether you have
>> applied some sorting while viewing the results
>> previously, then saved the query.
>>
>> When you view the results of your query,
>> go to top menu and in "Records" dropdown,
>> click on "Remove Filter/Sort"
>>
>> The query was prompting you first when
>> executing the query, then a second time
>> when it tried to apply this "external" sort.
>>
>>
>>

>
>



 
Reply With Quote
 
Gary Walter
Guest
Posts: n/a
 
      06-14-2006, 09:20 PM
I defer to Duane. 8-)

Actually, if that's what it means,
I'm probably "sager" than either of you...
(had first grey hair in junior high school)

I had to leave Colorado for fear of
being taken for a grizzly and shot.

Well, that last part is not true....
I look more like a silverback gorilla
than a grizzly...

"Jeff Boyce" wrote:
> Gary
>
> ?!"sage" -- doesn't that imply grey and grizzled?
>
> <G>Jeff
>
> "Gary Walter" <(E-Mail Removed)> wrote in message
> news:O%(E-Mail Removed)...
>>
>> "Vanessa" wrote:
>>>I have a query with a criteria that contains
>>>
>>> like "*" & [Enter Venue] & "*"
>>>
>>> When the query is run, the prompt to 'enter venue' is repeated after the
>>> information has been entered - how can I stop this?

>>
>> In addition to Jeff's sage advice...
>>
>> You might double-check whether you have
>> applied some sorting while viewing the results
>> previously, then saved the query.
>>
>> When you view the results of your query,
>> go to top menu and in "Records" dropdown,
>> click on "Remove Filter/Sort"
>>
>> The query was prompting you first when
>> executing the query, then a second time
>> when it tried to apply this "external" sort.
>>
>>
>>

>
>



 
Reply With Quote
 
Gary Walter
Guest
Posts: n/a
 
      06-14-2006, 09:39 PM
It seems like just yesterday those long
difficult sessions as Diane Fossey taught
me how to sign...

then the big, beaming smile on her
face when I signed asking if she could
teach me MS Access...

>I defer to Duane. 8-)
>
> Actually, if that's what it means,
> I'm probably "sager" than either of you...
> (had first grey hair in junior high school)
>
> I had to leave Colorado for fear of
> being taken for a grizzly and shot.
>
> Well, that last part is not true....
> I look more like a silverback gorilla
> than a grizzly...
>
> "Jeff Boyce" wrote:
>> Gary
>>
>> ?!"sage" -- doesn't that imply grey and grizzled?
>>
>> <G>Jeff
>>
>> "Gary Walter" <(E-Mail Removed)> wrote in message
>> news:O%(E-Mail Removed)...
>>>
>>> "Vanessa" wrote:
>>>>I have a query with a criteria that contains
>>>>
>>>> like "*" & [Enter Venue] & "*"
>>>>
>>>> When the query is run, the prompt to 'enter venue' is repeated after
>>>> the
>>>> information has been entered - how can I stop this?
>>>
>>> In addition to Jeff's sage advice...
>>>
>>> You might double-check whether you have
>>> applied some sorting while viewing the results
>>> previously, then saved the query.
>>>
>>> When you view the results of your query,
>>> go to top menu and in "Records" dropdown,
>>> click on "Remove Filter/Sort"
>>>
>>> The query was prompting you first when
>>> executing the query, then a second time
>>> when it tried to apply this "external" sort.
>>>
>>>
>>>

>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why does this query ask for the start date and end date twice? GWB Access Queries 4 04-15-2010 01:47 PM
why does outlook ask twice for .pst pw? Jason Outlook General 0 01-01-2008 03:29 AM
Why does Outlook ask for my password twice when retrieving mail? ohscommish Microsoft Outlook 0 02-09-2005 03:25 PM
Why does FP2000 ask for Usename & password twice? Bill Frontpage Client 0 02-04-2005 04:31 AM
Input a user version number via hyperlink/ASK/input box Michael Word Page Layout 1 05-28-2004 06:42 PM


All times are GMT. The time now is 06:50 AM.
Microsoft Office Forums is not affiliated with Microsoft Corporation.


Welcome!
Welcome to the Microsoft Office Forums
 


Latest Threads
Word 2013 Insert Symbol (Not Responding)
tpthrshr (Today, 02:49 AM)

Can't save a large Word document
Josh (Today, 01:03 AM)

Remote help?
newman200 (04-13-2014, 12:54 PM)

Access command button help needed
MikeyL (04-06-2014, 07:01 PM)

Page number problem
satrah (04-06-2014, 10:48 AM)