By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,446 Members | 3,031 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,446 IT Pros & Developers. It's quick & easy.

Searching for a string from a form

P: n/a
Please can someone provide the code for the following problem from a
video store database:

where:
tblVideo(VideoID, Title, Artist, etc)

what would be done in frmFindTitle to select the recordset that
matches some words in the title?

For example, the customer wants a song that has 'rain' in the title
but can't remember what the full title is.

So far as I have got:

txtSearchWord (text box to input search word)
Event: afterupdate calls vba code which will select records like the
search word.

PseudoCode:
select from tblVideo
Title
where
tblVideo title = wildcard txtSearchWord wildcard

Any help greatly appreciated.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
As far as getting the records you want, a query using Like '*entry*' in the
WHERE clause would get want you want. However, it all depends on where the
results are going as to how to build the code for it. Are you displaying it
on a form with bound controls? Into a Listbox? Report?

Mike Storr
www.veraccess.com

"Mark Thomas" <mt*****@beacon.surrey.sch.uk> wrote in message
news:b1**************************@posting.google.c om...
Please can someone provide the code for the following problem from a
video store database:

where:
tblVideo(VideoID, Title, Artist, etc)

what would be done in frmFindTitle to select the recordset that
matches some words in the title?

For example, the customer wants a song that has 'rain' in the title
but can't remember what the full title is.

So far as I have got:

txtSearchWord (text box to input search word)
Event: afterupdate calls vba code which will select records like the
search word.

PseudoCode:
select from tblVideo
Title
where
tblVideo title = wildcard txtSearchWord wildcard

Any help greatly appreciated.

Nov 12 '05 #2

P: n/a

"Mark Thomas" <mt*****@beacon.surrey.sch.uk> wrote in message
news:b1**************************@posting.google.c om...
Please can someone provide the code for the following problem from a
video store database:

where:
tblVideo(VideoID, Title, Artist, etc)

what would be done in frmFindTitle to select the recordset that
matches some words in the title?

For example, the customer wants a song that has 'rain' in the title
but can't remember what the full title is.

So far as I have got:

txtSearchWord (text box to input search word)
Event: afterupdate calls vba code which will select records like the
search word.

PseudoCode:
select from tblVideo
Title
where
tblVideo title = wildcard txtSearchWord wildcard

Any help greatly appreciated.


WHERE title LIKE txtSearchWord
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.