exporting forms with a subform

Hi. I already posted this, but I wanted a better answer
than "Micsoft Access does not export subforms."

I have made a form that has "item" information at
the top, and it has two subforms underneath it which
contain detail information from a few different sources.

Now my task is to export this form into an emailable
form. Exporting into Excel definitely does not work.
I've tried outputting my form "Form1" into html, but only
Form1 is exported. The two subforms are not.

Does anyone have a workaround to this limitation of
Access?

Any ideas?

Thanks,
Joe
..

What do you mean "Micsoft Access does not export subforms"?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Joe" wrote in message
...
Hi. I already posted this, but I wanted a better answer
than "Micsoft Access does not export subforms."

I have made a form that has "item" information at
the top, and it has two subforms underneath it which
contain detail information from a few different sources.

Now my task is to export this form into an emailable
form. Exporting into Excel definitely does not work.
I've tried outputting my form "Form1" into html, but only
Form1 is exported. The two subforms are not.

Does anyone have a workaround to this limitation of
Access?

Any ideas?

Thanks,
Joe
.

I found a little blurb on the MS site about why subforms
don't get exported with the form. It said very bluntly
that subforms do not get exported. I'm trying to find
the link.

-----Original Message-----
What do you mean "Micsoft Access does not export
subforms"?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Joe" wrote in
message
...
Hi. I already posted this, but I wanted a better
answer
than "Micsoft Access does not export subforms."

I have made a form that has "item" information at
the top, and it has two subforms underneath it which
contain detail information from a few different
sources.

Now my task is to export this form into an emailable
form. Exporting into Excel definitely does not work.
I've tried outputting my form "Form1" into html, but
only
Form1 is exported. The two subforms are not.

Does anyone have a workaround to this limitation of
Access?

Any ideas?

Thanks,
Joe
.




.

Hi Lynn. Here is what I found on MS's site:
_____________________________________________
http://office.microsoft.com/assistance/preview.aspx?
AssetID=HP030851161033&CTT=4&Origin=CH063648341033

Subforms are ignored during the export operation.
Export the subform separately.
_____________________________________________


Exporting forms into Excel results in exporting the
database, so I'm exporting the form into HTML (I only
need to send the file electronically). Problem is I
can't link the forms back together if I export them
separately.

-----Original Message-----
What do you mean "Micsoft Access does not export
subforms"?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Joe" wrote in
message
...
Hi. I already posted this, but I wanted a better
answer
than "Micsoft Access does not export subforms."

I have made a form that has "item" information at
the top, and it has two subforms underneath it which
contain detail information from a few different
sources.

Now my task is to export this form into an emailable
form. Exporting into Excel definitely does not work.
I've tried outputting my form "Form1" into html, but
only
Form1 is exported. The two subforms are not.

Does anyone have a workaround to this limitation of
Access?

Any ideas?

Thanks,
Joe
.




.

Ah, now I understand better. What you have to remember is that a subform is
actually a form in its own right. It is merely displayed on a main form
using a subform control. The subform control IS exported with the main form,
but it is of no use without the actual form that is displayed in that
subform control.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Joe" wrote in message
...
I found a little blurb on the MS site about why subforms
don't get exported with the form. It said very bluntly
that subforms do not get exported. I'm trying to find
the link.

-----Original Message-----
What do you mean "Micsoft Access does not export
subforms"?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Joe" wrote in
message
...
Hi. I already posted this, but I wanted a better
answer
than "Micsoft Access does not export subforms."

I have made a form that has "item" information at
the top, and it has two subforms underneath it which
contain detail information from a few different
sources.

Now my task is to export this form into an emailable
form. Exporting into Excel definitely does not work.
I've tried outputting my form "Form1" into html, but
only
Form1 is exported. The two subforms are not.

Does anyone have a workaround to this limitation of
Access?

Any ideas?

Thanks,
Joe
.




.