locating sample database info in Access 2003

G

Guest

Hello,

I can not seem to locate an "CLIENTS" database sample that is referred to in
a HOWto article I found on microsoft knowledgebase. I have installed the
northwinds sample database, and I can find that, but I can't find a database
called clients in that, nor can a I locate the path SAMPLE\ORGANIZE\DBFS that
the article refers to as the place where I can locate the "CLLENTS" sample
database.

Here is a copy of the HOWto article

HOWTO: Search for Specific Text in a Memo Field
Article ID : 117217
Last Review : July 13, 2004
Revision : 1.0
This article was previously published under Q117217
On this Page
SUMMARY
MORE INFORMATION

SUMMARY
This article demonstrates the two methods you can use to search for specific
text in a memo field. The first method uses the Query Designer. The second
method programmatically searches a memo field of a database and highlights a
specific word or phrase. The program continues searching and highlighting all
occurrences within a memo field until all the matches are located.
MORE INFORMATION
Method 1
This example uses the CLIENTS database in the SAMPLE\ORGANIZE\DBFS
subdirectory interactively using the Query Designer. Open the Query Designer
(File, New, Query), and select the drop-down box under fField Name in the
Selection Criteria dialog. Scroll to the bottom of the list of fields, and
select <EXPRESSION...>. In the Expression window, enter the following:
"ATC("msrchstr", Notes)."

In the Criteria drop-down box, select "More Than." In the Example textbox,
type "0" (zero). When the query is performed, the cursor returns the set of
records where the searched-for string occurs in the specified field at any
location.
 
D

Douglas J. Steele

Take a look at the bottom of that KB article: it applies to FoxPro, not
Access.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top