Group:  Microsoft Access ยป microsoft.public.access.reports
Thread: Saving Report pages as individual files

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Saving Report pages as individual files
fran 02.09.2006 14:15:02
I have a report with 330 pages...each page for a different employee. Is
there a way to have Access automatically save each page as a separate *.snp
report? I would want each page saved using the employee name field. thanks!
Re: Saving Report pages as individual files
"Larry Linson" <bouncer[ at ]localhost.not> 03.09.2006 01:42:27

"fran" <fran[ at ]discussions.microsoft.com> wrote in message
news:A838991B-9408-4C47-9663-FAE16A27E00B[ at ]microsoft.com...
[Quoted Text]
>I have a report with 330 pages...each page for a different employee. Is
> there a way to have Access automatically save each page as a separate
> *.snp
> report? I would want each page saved using the employee name field.
> thanks!

No, but with some VBA code, you could run 330 reports, each limited to a
single employee -- I haven't done this, so can't give you details about
saving as or outputting to .snp programattically.

Larry Linson
Microsoft Access MVP


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net