Thanks, Bill.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Friday, May 17, 2013 1:05 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Form - Parameter Query
Looks like John took a break so I'll jump in.
MyField should be replaced with the name of the field you use in your table.
Whenever we post examples and don't know the name of an object we will refer
to it as MyField or MyTable or MyForm. It's just a generic way of writing
the syntax.
Regards,
Bill Mosca, Founder - MS_Access_Professionals http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-6427073088
1E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "ZJUbias" <zjubias@...>
wrote:
>
> Hello John,
>
>
>
> Thank you..
>
>
>
> Just a small clarification, the "MyField" on your below expression,
> would you please feed me more info on this. What is this field, it is
> not that am I only filling out the txtFirstName control from my form
> and it will be use in underlying query as criteria?
>
>
>
> How could I use in my query filter? Should I just put the below
> expression in the criteria row of my FirstName? And another in my
> criteria row for the LastName?
>
>
>
> Thank you for your kind help,
>
> Zjubias
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John
> Viescas
> Sent: Friday, May 17, 2013 4:22 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: RE: [MS_AccessPros] Form - Parameter Query
>
>
>
> ZJubias-
>
> If you want to treat a "blank" criteria as no filter (all records),
> then you must do:
>
> WHERE ((MyField = [forms]![frmEnterParameter]![txtFirstName]) OR
> ([forms]![frmEnterParameter]![txtFirstName] IS NULL))
>
> That works for up to about three parameters in a query like this, but
> you'll probably get "query too complex" if you try to do more than
> three. If you need more than three like this, it's best to write code
> to build a dynamic filter.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications SQL Queries for Mere Mortals
> http://www.viescas.com/ (Paris, France)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of
> ZJUbias
> Sent: Friday, May 17, 2013 12:03 AM
> To: MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Form - Parameter Query
>
> Hello all,
>
> Can someone please clarify my concerns;
>
> If I created a form to get user fills the search criteria like below
> format, I know that if I put these expression to my query criteria row
> I will get the desired record. But what if, the user failed to filled
> out one of the criteria? What happen, what is the result?.
>
> This kind of approach, is it good/suitable for a multi-field criteria
> to use on search form? If not what is the best for multi-field
> criteria search approach, considering that maybe one or two field will
> contain a blank criteria..
>
> [forms]![frmEnterParameter]![txtFirstName]
>
> [forms]![frmEnterParameter]![txtSurname]
>
> Thank you in advance,
>
> Zjubias
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
------------------------------------
Yahoo! Groups Links
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (10) |
Tidak ada komentar:
Posting Komentar