If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 .. |
#2
|
|||
|
|||
exporting forms with a subform
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 . |
#3
|
|||
|
|||
exporting forms with a subform
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 . . |
#4
|
|||
|
|||
exporting forms with a subform
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 . . |
#5
|
|||
|
|||
exporting forms with a subform
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 . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |
Need help with cascading combos | Tom | Using Forms | 19 | July 1st, 2004 11:11 PM |
Record Source for SubForm | David F | Using Forms | 1 | June 7th, 2004 10:42 PM |
subform within subform | Chris | Using Forms | 1 | June 4th, 2004 10:26 PM |
Use Combo Box in forms to filter Records in a subform | Rod Burchby | Using Forms | 1 | May 25th, 2004 08:19 PM |