SELECT Main_Tbl[A1], Main_Tbl[B1]
FROM Main_Tbl
WHERE (((Main_Tbl[A1]) Like [Forms]![Form Main Query]![A1] & "*")
AND ((Main_Tbl[B1]) Like [Forms]![Form Main Query]![B1]& "*"));
John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Ralph Krumdieck
Sent: Tuesday, May 09, 2006 5:25 AM
To: [email protected]
Subject: Re: [ms_access] Simple Search problem
The name of the form is Form Main Query. The two controls (I assume you
mean the names of the boxes that come up) are A1 and B1. That's A followed
by the number 1. SQL looks like:
SELECT Main_Tbl[A1], Main_Tbl[B1]
FROM Main_Tbl
WHERE (((Main_Tbl[A1]) Like [Enter A1 Term: ]&"*") AND ((Main_Tbl[B1]) Like
[Enter B1 Term: ]&"*"));
> The data you're typing in the two boxes on the second form are values you
> want to use to filter the data that is displayed, correct? What is the
name
> of that form? What is the name of the two controls on the form? And
> finally, what is the SQL of the query? (Open the query in Design view and
> choose SQL View from the View menu.)
>
> John Viescas, author
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> Running Microsoft Access 2000
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
> For the inside scoop on Access 2007, see:
> http://blogs.msdn.com/access/
>
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf
> Of Ralph Krumdieck
> Sent: Monday, May 08, 2006 3:03 AM
> To: [email protected]
> Subject: Re: [ms_access] Simple Search problem
>
> I'm using Like [Search Main For: ] &"*" as a criteria in the query. No
code
> in the second form, though I'm not certain what "applying the filter"
means.
>
> > Are you using a parameter query? Is there code in the second form to
> apply
> > the filter? More details, please.
> >
> > John Viescas, author
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > Running Microsoft Access 2000
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> > For the inside scoop on Access 2007, see:
> > http://blogs.msdn.com/access/
> >
> >
> > -----Original Message-----
> > From: [email protected] [mailto:[EMAIL PROTECTED] On
> Behalf
> > Of Ralphkru
> > Sent: Sunday, May 07, 2006 6:40 AM
> > To: [email protected]
> > Subject: [ms_access] Simple Search problem
> >
> > I have a very simple database, 1 table, 1 query, 2 forms. One of
> > the forms is based on the table and when it is opened, it opens
> > at the first record, and all the other records are available via
> > the controls. The second form, when it is opened, opens with two
> > small boxes, one coming after the other, that ask for a search
> > term from the user for one of two fields, or both. Upon
> > supplying the term(s), the form opens but shows no data.
> >
> > I have input some trial data to test this, so I know I'm not
> > asking for terms that don't exist. I have another database that
> > does essentially the same thing, and does it successfully. I
> > thought I was setting up this 2nd database the same way, but
> > obviously I've forgotten something. I have tried comparing the
> > two but cannot find what the difference is. Any ideas on what
> > might be going wrong?
> >
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
