• Search all reports for an address

    From musicloverlch@21:1/5 to All on Wed Dec 1 09:59:25 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ron Weiner@21:1/5 to All on Wed Dec 1 15:46:58 2021
    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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ammammata@21:1/5 to All on Thu Dec 2 07:55:28 2021
    Il giorno Wed 01 Dec 2021 09:46:58p, *Ron Weiner* ha inviato su comp.databases.ms-access il messaggio news:so8n04$pbb$1@dont-email.me.
    Vediamo cosa ha scritto:

    Access.Application.SaveAsText acReport, rpt.Name, strFolder & rpt.Name & ".txt"


    is it available a "reverse" command to import a report from a dump?

    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From =?UTF-8?B?0JLQu9Cw0LTQuNC80LjRgCDQr@21:1/5 to All on Thu Dec 2 03:27:18 2021
    четверг, 2 декабря 2021 г. в 10:55:32 UTC+3, Ammammata:
    Il giorno Wed 01 Dec 2021 09:46:58p, *Ron Weiner* ha inviato su comp.databases.ms-access il messaggio news:so8n04$pbb$1...@dont-email.me. Vediamo cosa ha scritto:
    Access.Application.SaveAsText acReport, rpt.Name, strFolder &
    rpt.Name & ".txt"

    is it available a "reverse" command to import a report from a dump?

    --
    /-\ /\/\ /\/\ /-\ /\/\ /\/\ /-\ T /-\
    -=- -=- -=- -=- -=- -=- -=- -=- - -=-
    ........... [ al lavoro ] ...........

    There is hidden member of Access.Application
    Sub LoadFromText(ObjectType As AcObjectType, ObjectName As String, FileName As String)

    But if you changed content of previously saved file, you should delete string with check sum before loading.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)