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
>
>
>
>
>
>
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.
