468,294 Members | 1,907 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,294 developers. It's quick & easy.

Like query - using a string value from a form

gus
I am trying to query large text fields searching for text strings. I
can do this successfully in query design by entering the criteria
Like "*my text*"

I want to do it by entering the text in a form field which on update
will requery a subform displaying the relevant records.

I can do all of that for similar exact matches without any problem.

While I can navigate (slowly) aroung embedded literals I am having
trouble getting this query to work and I am beginning to wonder if
access is adding something to the information on the way to the SQL.
Nov 12 '05 #1
2 13247
gus,
Change the query criteria from
Like "*MyText*"
to:
Like "*" & forms!NameOfForm!NameOfControlOnForm & "*"
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
"gus" <gu*@opr.com.au> wrote in message
news:cc**************************@posting.google.c om...
I am trying to query large text fields searching for text strings. I
can do this successfully in query design by entering the criteria
Like "*my text*"

I want to do it by entering the text in a form field which on update
will requery a subform displaying the relevant records.

I can do all of that for similar exact matches without any problem.

While I can navigate (slowly) aroung embedded literals I am having
trouble getting this query to work and I am beginning to wonder if
access is adding something to the information on the way to the SQL.

Nov 12 '05 #2

I just knew it was going to be an irritatingly simple version of
something slightly different from all the other things I had already
tried.

Thanks mate

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Harvey | last post: by
3 posts views Thread by Reginald | last post: by
6 posts views Thread by Nicolae Fieraru | last post: by
6 posts views Thread by Martin Lacoste | last post: by
7 posts views Thread by Dave Hopper | last post: by
2 posts views Thread by Kevin | last post: by
1 post views Thread by tina.boroff | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.