novaBBS - comp.databases.ms-access - Search all reports for an address

Search all reports for an address

<7c1b95fc-609c-4dd7-9e7f-9fdabb595ef1n@googlegroups.com>

https://www.novabbs.com/devel/article-flat.php?id=543&group=comp.databases.ms-access#543

copy link Newsgroups: comp.databases.ms-access

X-Received: by 2002:ac8:5ad1:: with SMTP id d17mr8688188qtd.23.1638381566502;
Wed, 01 Dec 2021 09:59:26 -0800 (PST)
X-Received: by 2002:aca:646:: with SMTP id 67mr7409339oig.175.1638381566140;
Wed, 01 Dec 2021 09:59:26 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-access
Date: Wed, 1 Dec 2021 09:59:25 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=2601:2c7:8c00:9ab0:85be:25b1:8f42:bab9;
posting-account=Lr72qQoAAADkUv-gyUq0hiLVTj6vT-m8
NNTP-Posting-Host: 2601:2c7:8c00:9ab0:85be:25b1:8f42:bab9
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <7c1b95fc-609c-4dd7-9e7f-9fdabb595ef1n@googlegroups.com>
Subject: Search all reports for an address
From: lho...@gmail.com (musicloverlch)
Injection-Date: Wed, 01 Dec 2021 17:59:26 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

by: musicloverlch - Wed, 1 Dec 2021 17:59 UTC

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

Re: Search all reports for an address

<so8n04$pbb$1@dont-email.me>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=544&group=comp.databases.ms-access#544

copy link Newsgroups: comp.databases.ms-access

Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: rw...@domain.com (Ron Weiner)
Newsgroups: comp.databases.ms-access
Subject: Re: Search all reports for an address
Date: Wed, 01 Dec 2021 15:46:58 -0500
Organization: WorksRite
Lines: 31
Message-ID: <so8n04$pbb$1@dont-email.me>
References: <7c1b95fc-609c-4dd7-9e7f-9fdabb595ef1n@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Wed, 1 Dec 2021 20:47:00 -0000 (UTC)
Injection-Info: reader02.eternal-september.org; posting-host="b1cd7e14a364e41342283e94e7ad5063";
logging-data="25963"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18Qnd8LuGnYmLC4nIhgxcby"
Cancel-Lock: sha1:A6hpBc92ubBzv2a3xWSN38Yljq0=
X-Antivirus-Status: Clean
X-Newsreader: MesNews/1.08.06.00-gb
X-Antivirus: AVG (VPS 211130-0, 11/29/2021), Outbound message
X-ICQ: 1701145376

by: Ron Weiner - Wed, 1 Dec 2021 20:46 UTC

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

Re: Search all reports for an address

<XnsADF45ACC0EC6Dammammatatiscalineti@127.0.0.1>

copy mid

https://www.novabbs.com/devel/article-flat.php?id=545&group=comp.databases.ms-access#545

copy link Newsgroups: comp.databases.ms-access

Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!reader5.news.weretis.net!news.solani.org!.POSTED!not-for-mail
From: ammamm...@tiscalinet.it (Ammammata)
Newsgroups: comp.databases.ms-access
Subject: Re: Search all reports for an address
Date: Thu, 2 Dec 2021 07:55:28 -0000 (UTC)
Message-ID: <XnsADF45ACC0EC6Dammammatatiscalineti@127.0.0.1>
References: <7c1b95fc-609c-4dd7-9e7f-9fdabb595ef1n@googlegroups.com> <so8n04$pbb$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Injection-Date: Thu, 2 Dec 2021 07:55:28 -0000 (UTC)
Injection-Info: solani.org;
logging-data="31002"; mail-complaints-to="abuse@news.solani.org"
User-Agent: Xnews/??.01.30 Mime-proxy/2.3.c.1 (Win32)
X-Face: s5/Tl9"^@"z`/]&NeE,Wl.^B~E2x9PA?1n:XZq2^T2Prz*},H~M'2.*@~v9MXx|OL8<EqC0MU$v+`Pu;`eq$N12\Nc*)cp$iBgD/wysO=)P%n6)\Xf}L\E$-0s\mD::Dx\6QwNh<U!LBH1Xj(=zy?OV.|=]We",DS\6[:
X-User-ID: eJwNyskBwCAIBMCW5NqQcliR/kvQeU8YBPtzBDwmhrVUJN0H1QLaifmln9E9naizjFLkaPZiGbKYKe86j1503xaT
Cancel-Lock: sha1:bge5ewW/q04mtH3VWrfvU/WkCfw=

by: Ammammata - Thu, 2 Dec 2021 07:55 UTC

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 ] ...........

Nothing ever becomes real until it is experienced. -- John Keats

devel / comp.databases.ms-access / Search all reports for an address

Subject	Author
Search all reports for an address	musicloverlch
Re: Search all reports for an address	Ron Weiner
Re: Search all reports for an address	Ammammata