Can a report be searched?

  • Thread starter Thread starter BigHair101
  • Start date Start date
B

BigHair101

Can an Access report be searched or (use find) to locate a specific string of
characters?

I have a report with several hundred pages and only want to locate one page
based on a last name and then print that single page.

Thanks in advance for help.
 
An Access report is a "for-print" version of data stored in tables.

Rather than searching the report, how about searching the underlying data?

If you ONLY have the report (i.e., printed copy), you'll probably have to
employ USB technology ("using someone's brain").

If you have an Access Report in print preview mode, consider exporting it to
Word and searching there... (but I still think searching the data, not the
output, is the way to go!)

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Can an Access report be searched or (use find) to locate a specific string of
characters?

I have a report with several hundred pages and only want to locate one page
based on a last name and then print that single page.

Thanks in advance for help.
Click to expand...

The best method is to simply filter the report so that only that last
name is reported on. Then just print the 'whole' report.

For example, from a form that displays the record with the "Last Name"
of the person you wish to report on, code a command button's click
event:
DoCmd.OpenReport "ReportName", acViewPreview, , "[LastName] = """ &
Me.[LastName] & """"

Note: Searching records by last name is not a good idea. It often
occurs that there may be more than one person with the same last
names, i.e. Smith, Jones, Anderson, etc. How would Access know which
Smith or Jones you wish to report on?

A better method would be to use the PersonID field on the form, which
should uniquely identify each separate person.

Assuming PersonID is a Number datatype:

DoCmd.OpenReport "ReportName", acViewPreview, , "[PersonID] = " &
Me.[PersonID]
 
Back
Top