Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Search for text in report.

Posted on 2013-11-25
3
Medium Priority
?
240 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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

578 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