How to add a subreport (not subform) on a form?

[Adnan]

Just searched but could not find the answer. Is it possible to add a
subreport (not subform) on a form?

I have a tree view switchboard menu where each command displays a subform,
datasheet table, chart and now need a report within this form (switchboard).
This report must be viewed within the unbound subform just line the form,
datasheet and chart does. (not on separate report/window).

Thank you for any tip/help provided.
Adnan

 

[Klatuu]

No, forms may have sub forms and reports may have sub reports, but not the
other way round.

 

[Adnan]

Klatuu,

Thanks for your response. I just read an article within this community where
there’s a workaround with snapshot control, I am pretty close but need some
code that converts intended report to snapshot and saves it to a certain
folder then I can view it with snapshot control from there.

Again, when I click the command button, it coverts and saves the report and
then views it on subform as snapshot, which is pretty mutch the same as
report.

All I need is the code.

Here’s the question/answer/workaround:

http://www.microsoft.com/office/com...c47a&mid=9ef84b9b-02e6-4ad6-a085-065a012a7c3d

 

[Klatuu]

I read the post. It seems like the solution to your problem. The problem
is, I don't have the snapshot viewer control installed and I have not used it
before, so I don't think I can offer a lot of help.

 

[Larry Linson]

Thanks for your response. I just read an article within this community where
there's a workaround with snapshot control, I am pretty close but need some
code that converts intended report to snapshot and saves it to a certain
folder then I can view it with snapshot control from there.

I see that the original poster you cite told you that you could do that, but
did not give you the information how to do it. I find, like Klaatu, that I
do not have the snapshot control installed. (Many accomplished Access
developers use no ActiveX controls, or at least as few as possible, because
of the extra effort to distribute and install their database applications.)
Have you considered appending your question asking about specifics on how to
do what the poster describes as a followup to that post (given the dates,
I'd copy the entire post that recommends using the snapshot control).

Again, when I click the command button, it coverts and saves the report and
then views it on subform as snapshot, which is pretty mutch the same as
report.

When I read this, it would appear that you do have it working. What am I
missing. What "_the_ command button" are you writing about?

I've not closed/saved a report as a snapshot from code. My users view
reports and, if they want/need a snapshot, they use File | Export and choose
the Snapshot format.

All I need is the code.

Specifically, from where in your application and under what circumstances do
you want to execute "the code" to do specifically what? Do you want to
open, close, and save the report as snapshot without the user being
involved?

Here's the question/answer/workaround:

http://www.microsoft.com/office/community/en-us/default.mspx? &query=Brett+Kinross&lang=en&cr=US&guid=&sloc=en-
us&dg=microsoft.public.access.forms&p=1&tid=ffa77d05-abf2-4e0d-80da-6a893376c47a&mid=9ef84b9b-
02e6-4ad6-a085-065a012a7c3d

Larry Linson
Microsoft Access MVP

 

[Adnan]

Larry,

Thanks for the response, I am missing some code that saves a report as a
napshot in desired folder and then viewing it on a subform (as snapshot,
where I have already a snapshot cobtrol set up).


--
HTP
Adnan

If I have helped and/or answered your question, please let me know by
replying or clicking question answered (below positioned ‘Yes’ button).

 

[Klatuu]

amen on "use no ActiveX controls"
Not only deployment problems, but lack of documentation on the controls
properties and methods.

As an experiment I was trying to set up a treeview control with images. A
KB article said you had to use an image control and gave code examples of how
to attach images to the image control using the .add method. I tried it, and
the control doesn't have an .add method.