Re: Enter MULTIPLE Items in a Query (e.g. [Name:] ??

As you have seen, you can't enter more than one name using your current
syntax. I would first change the name name to some other name so Access
doesn't confuse an object name "property" with the name of a field.

The only non-code method that I am aware of that can use a parameter prompt
is to set up a where clause like:

WHERE Instr("," & [Enter first names] & ",", "," & [FirstNameField] & ",")
>0



--
Duane Hookom
MS Access MVP
--

"kev100 via AccessMonster.com" <u16246@uwe> wrote in message
news:5a07b45996187@xxxxxx
> I've got a query set up that will return all the entries relating to a
> particular Name.
>
> The names are stored in the "Name" field.
>
> In the Query, I simply used the [Enter First Name:] so that the user is
> prompted.
>
>
> Entering 1 name works great.
>
> However, what statement do I use in the Query to allow 1 OR More to be
> entered....so that it will return for one or all (basically Name1 or Name2
> or
> Name3.......etc)?
>
> I've tried just entering "John" or "Mary" or "Tom" into the existing
> prompt,
> but it doesn't seem to work.
>
> Thanks
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200601/1


.

Relevant Pages

  • Re: Custom Function
    ... > Duane Hookom ... > MS Access MVP ... >> myself - If I enter a string into the prompt, ... >>> prompt) Second that you don't have the control named CapacityCode as ...
    (microsoft.public.access.reports)
  • Re: data entry
    ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ... even i dont have any data entered yet it saves when i clicked the Save ... is there any code that prompt to user that they need to enter a data prior ...
    (microsoft.public.access.formscoding)
  • RE: Passing Dates criteria in MS Query
    ... You are correct with the square brackets but you need to add the prompt text ... query set up in the design view. ... I need the dates to equal 2 cells on a worksheet. ...
    (microsoft.public.excel.misc)
  • Re: Update field with contents of another field
    ... Vanderghast, Access MVP ... What is causing that prompt? ... saying Syntax error, missing operator..... ...
    (microsoft.public.access.queries)
  • Re: I have some questions on calculations,IIF,etc.
    ... The "Enter Parameter Value" prompt means that you still have something typed ... If you can post the EXACT field names in your table AND the SQL ... MS Access MVP ...
    (microsoft.public.access.queries)
Loading