Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #14412

Re: Search all reports for an address

Show all headers | View raw

musicloverlch submitted this idea :
> I have over 300 reports and I need to make an address change to some of them, 
> but I don't know which ones without opening them.  Is there a way to search 
> them for a certain set of characters?  For example, I want to get a list of 
> all the reports that have "7425" in them.  Is that possible? I have a feeling 
> it's not.
>
> Thanks so much,
> Laura

I do not know how to directly look inside an Access Report to 
inspectand or search through its contents, BUT you can iterate through 
the Reports collection and DUMP the contents of each report to a place 
on your hard drive and then use Search from Windows FileMaker to find 
the Report(s) that contain your target string.  The File Name is the 
Report Name.

Here is some quick and dirty code to accomplish the first part.

    Dim rpt As Object
    Dim strFolder As String

    strFolder = "C:\your folder\"
    For Each rpt In CurrentProject.AllReports
        Access.Application.SaveAsText acReport, rpt.Name, strFolder & 
rpt.Name & ".txt"
    Next

Sheesh, 300 reports.  Good luck

Rdub

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Search all reports for an address musicloverlch <lhowey@gmail.com> - 2021-12-01 09:59 -0800
  Re: Search all reports for an address Ron Weiner <rw@domain.com> - 2021-12-01 15:46 -0500
    Re: Search all reports for an address Ammammata <ammammata@tiscalinet.it> - 2021-12-02 07:55 +0000
      Re: Search all reports for an address Владимир Яковлев <4dmonster@gmail.com> - 2021-12-02 03:27 -0800

csiph-web