Outout FORM to snapshot viewer - Registry hack?

[Guest]

Server = SQL Server 2000 SP3a
Client = Access 2000 data project

Im trying to ouptut a form to snapshot view, this surely must be possible as
it works fine in the reports. I've tried coding it with:

DoCmd.OutputTo acOutputForm, "frmMyFormP", acFormatSNP, "c:\temp"

Which results in:
Run-time error '2282':
The formats that enable you to output data as Microsoft Excel, rich-text
format, MS-DOS text, or HTML file are missing from the Windows Registry

This works fine for a report, surely there is a way to hack the resgistry to
get it to work in Access Forms as well.
The other outputs, xls, asp, html etc are useless as they totally screw the
formating.

I have a complicated form which has taken quite a while to write, what
options do I have eg
1. Re-write the whole thing again as a report (ie have both)
2. Buy Adobe Acrobat and get it to spit out a pdf file

Any othe suggestions? Much appreciated!!!

Steve'o

 

[Rick Brandt]

Server = SQL Server 2000 SP3a
Client = Access 2000 data project

Im trying to ouptut a form to snapshot view, this surely must be
possible as it works fine in the reports. I've tried coding it with:

DoCmd.OutputTo acOutputForm, "frmMyFormP", acFormatSNP, "c:\temp"

Which results in:
Run-time error '2282':
The formats that enable you to output data as Microsoft Excel,
rich-text format, MS-DOS text, or HTML file are missing from the
Windows Registry

This works fine for a report, surely there is a way to hack the
resgistry to get it to work in Access Forms as well.
The other outputs, xls, asp, html etc are useless as they totally
screw the formating.

I have a complicated form which has taken quite a while to write, what
options do I have eg
1. Re-write the whole thing again as a report (ie have both)
2. Buy Adobe Acrobat and get it to spit out a pdf file

Any othe suggestions? Much appreciated!!!

Right-click the form in the db window and choose "Save as report".

If the form has subforms be careful as this process only creates a new
object (report) to replace the parent or main form. The subform objects
will still be pointing to the same source objects as in the form so if you
open the report and start messing with the design of the subforms you will
be making changes to the same subforms used in your current form. You would
need to repeat the process for the subforms separately and then change the
SourceObject in the main report to point at those.

Still the whole process of making a report that looks just like your form
should take less than a minute.

 

[Guest]

Hi Rick, thanks for the heads up on the sub form issue, sounds as though it
could have been messy, thanks for saving me more grief!

I'll try creating the reports as you suggested, my reasons for not liking
this were
a. Why on earth should anyone have to do this for such a basic thing (not
just exports to snp, but also the onFormat event on the detail section, the
sorting and grouping too)
b. I use some RTF controls and subforms which use code to dynamically resize
themselves (not as rigid as canShrink or canGrow), wasn't looking forward to
having to recode it all.

But, it is what it is, so hopefully I don't make a mess of it

Thanks.