Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Search for text in report.

Posted on 2013-11-25
3
Medium Priority
?
239 Views
Last Modified: 2013-11-25
I've inherited an access database.  it has lots of reports.   I'm trying to find a report some specific text in it.   Is there a way to do search?
0
Comment
Question by:HLRosenberger
3 Comments
 
LVL 49

Accepted Solution

by:
Dale Fye earned 1000 total points
ID: 39674983
If the text is in a caption, yes.  The easiest way it to purchase Rick Fisher's "Find and Replace".  This is a great tool and about the best $40 I ever spent.
0
 
LVL 120

Assisted Solution

by:Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1) earned 1000 total points
ID: 39674987
you have to do a search in the Record Source of your report..

sample query..

select * from TableOrQueryX where [fieldName] Like "* texttosearch *"

"TableOrQueryX" is the record Source of your report, could be a table or a query
0
 
LVL 1

Author Closing Comment

by:HLRosenberger
ID: 39675036
Thanks
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question