Programmicly Save Form As Report

[Guest]

Is there a way to programmicly save a Form as a Report? I have a form that
has several pie charts. Each day, as these charts update, the lables get
screwed up. Sometimes I can adjust these in the Report. Othertimes when I
open the chart that shows current data, it shows old data inside, so I can't
work with the labels (some aren't there). Then I have to re-save the Form as
a Report. I can change the lables in the Form without problems. Or is there a
way to deal with the probelem with the reports?

The name of the Form and Report is "QA Report". I use the report with Steven
Lebans ReportTools that sends the Report To MS Word and the Snapshot output.
It works evidently only with Reports and not forms. If it worked with Forms,
my probelm would be moot. I must due this due to our companies requirements
for sending reports thru email.

Any Ideas? any help is greatly appreciated.

 

[Alex Dybenko]

Hi,
instead of converting form to report - you can just use form as report - you
can preview it, print, define what controls are printable, what no

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

Alex,
the ReportTools that Steven Lebans created uses msysobjects to select
reports (SELECT Name FROM msysobjects WHERE Type=-32764. if i knew what the
numbers for forms were that'd probably work? otherwise i'm not quite sure how
the form as report would work with this. any advise. any experience with
Steven Leban's ReportTools?

 

[Alex Dybenko]

Hi,
ahh, now I see, but don't know if Steven's ReportTools works with forms.
Will try to ask him to join this tread


--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

I found my answer on MVPS.ORG (queries: return database object names). My
answer is 32768. When I change the list box's source, it pulls the forms
info. It does work with forms. Now for my next trick: make the Export To File
button have a hardcoded source that pulls a specific Form (instead of using a
combo or list box).
Thanks.

 

[Stephen Lebans]

But my solution relies on Access's ability to export a Report to Snapshot
format. Unfortunately, you cannot export a Form to Snapshot format.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.