RE: prompt criteria in find command

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: jojo (jojo_at_discussions.microsoft.com)
Date: 01/17/05 

Date: Mon, 17 Jan 2005 10:51:03 -0800

I forgot to mention, the reason why I am not creating a query to prompt the
user for criteria is that although my main form where I want to do my search
is based on a table, I also have several other subforms linked that are based
on other tables and queries.

"jojo" wrote:

> Is there a way to prompt a user by using the find command? I am trying to do
> something similar to what User "Wolfman" posted on 11/25/2004, subject:
> "Find". However, the Combobox is not ideal to me, because I do not want to
> allow the user to view the possible choices. I just want the user to
> manually type the account #.

Relevant Pages

  • Re: Dont prompt for criteria
    ... prompt for Date info, and in that case, NOT prompt for ClientID -- I don't ... criteria, and point the query to the form to get the criteria. ...
    (microsoft.public.access.queries)
  • Re: Criteria prompts
    ... how do I specify a "name" prompt? ... report, which is linked to a query. ... set this criteria to come up as prompts when the report is run? ...
    (microsoft.public.access.reports)
  • Re: Criteria prompts
    ... how do I specify a "name" prompt? ... report, which is linked to a query. ... set this criteria to come up as prompts when the report is run? ...
    (microsoft.public.access.reports)
  • Re: Slow Query when Prompts enabled
    ... This is happening because you are setting a criteria on a field from a view. ... That is why I suggest you create a pass-through query to your database ... server and change the SQL property as needed. ... I set just the query to prompt me for 1 thing, ...
    (microsoft.public.access.queries)
  • RE: Help! I need some simple statistics
    ... You can write one query for multiple dates by utilizing a prompt for user ... If you copy exactly this criteria to another field's criteria within the ... > CompletionDate as fields in my table. ...
    (microsoft.public.access.gettingstarted)