Simple form to query results from a test DB

[Pharmboy]

testDB.accdb

Total Newb here, I'm sure many are tired of that opening! I'm trying to learn all I can from online before I spend the time of people here, but I'm stuck on a pretty simple thing here. I have a large project at work dealing with documents and reference-ability where I believe access may be a solution, but I have to figure out how first!
So I started with this testDB attached. I simply want to make a form that will query the DB (which will be multiple excel files attached to access eventually) and return all text results that fit the input from the form. I looked at several posts, including one that walked me through how to get this far, but to no avail.
The clear-form button works, I'm proud of myself! (that's how newb i am at this point, and that came from someone else)
The query form returns nothing. I'm OK at SQL server queries actually, but access (forms/syntax/what-to-point-to) is foreign to me.


Can someone please tell me how in this simple testDB I am doing something wrong? If I put the letter 'a' in the first text box and then query, I get nothing. I would expect to get row 1 of 2...
Thanks.

[June7]

I googled: Access query ALIKE. I found http://www.pcreview.co.uk/forums/do-...-t1181176.html but that fix didn't work for me.
Found another http://www.utteraccess.com/forum/Que...ode=linearplus which has a link to http://www.access-programmers.co.uk/...d.php?t=157007.

Options:

1. turn off ANSI compatibility (I think the last link describes how)

2. Use % instead of * wildcard (this does work)

[Pharmboy]

Thank you June7. That was the ticket. I did change the settings to ANSI compatible, b/c all those SQL buffs keep harping on keeping things that way. Little did I know it would muck up the SQL in Access so that it was a little different, and cause me problems trying to learn the 'Access community' way of doing things. I suppose I will keep it off. But I do hope to split this database eventually to a SQL background. As far as I know, the query/form stuff still stays on the 'front side' and only the data goes to SQL. So ANSI compatible or not shouldn't really make a difference then, right?
Thanks for you help.

[June7]

I think your options remain the same regardless of the backend.

Glad it is working now.