1. Forum
  2. USENET
  3. comp.databases.ms-sqlserv

  • Search all reports for an address

    From musicloverlch@lhowey@gmail.com to comp.databases.ms-access on Wed Dec 1 09:59:25 2021
    From Newsgroup: comp.databases.ms-sqlserv

    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
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Ron Weiner@rw@domain.com to comp.databases.ms-access on Wed Dec 1 15:46:58 2021
    From Newsgroup: comp.databases.ms-sqlserv

    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
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Ammammata@ammammata@tiscalinet.it to comp.databases.ms-access on Thu Dec 2 07:55:28 2021
    From Newsgroup: comp.databases.ms-sqlserv

    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 ] ...........
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From =?UTF-8?B?0JLQu9Cw0LTQuNC80LjRgCDQr9C60L7QstC70LXQsg==?=@4dmonster@gmail.com to comp.databases.ms-access on Thu Dec 2 03:27:18 2021
    From Newsgroup: comp.databases.ms-sqlserv

    -c-|-e-#-|-C-|, 2 -|-|-|-#-#-C-A 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.
    --- Synchronet 3.21d-Linux NewsLink 1.2