 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / February 2007problem emailing report with subform
I have an order confirmation that is emailed after the order is entered. I just added a subform to the Confirmation Report. When I try to send it I get this message: "The save as command can't process any subforms contained in your report". This the code I use to send the email: DoCmd.RunCommand acCmdSaveRecord DoCmd.SendObject acReport, "rptOrderConfirmation", "RichTextFormat(*.rtf)", Forms!Orders!Email, "", "", "Order Confirmation", "Message" I don't have a clue what the problem is. Thanks for any help on this. Ron > I have an order confirmation that is emailed after the order is > entered. I just added a subform to the Confirmation Report. When I [quoted text clipped - 7 lines] > Thanks for any help on this. > Ron A report should use a subreport, not a subform. Access will let you embed as subform in a report, but as you have seen not everything works when you do that.  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Thanks Rick Sometimes MS don't make it clear. Ron > > I have an order confirmation that is emailed after the order is > > entered. I just added a subform to the Confirmation Report. When I [quoted text clipped - 10 lines] > A report should use a subreport, not a subform. Access will let you embed as > subform in a report, but as you have seen not everything works when you do that. OOOPS! I just created the subreport using the subreport wizard, and got the same message. > > I have an order confirmation that is emailed after the order is > > entered. I just added a subform to the Confirmation Report. When I [quoted text clipped - 10 lines] > A report should use a subreport, not a subform. Access will let you embed as > subform in a report, but as you have seen not everything works when you do that. I found my answer. All I had to do was open my subform in design mode and do a Save As> Report. Then I dragged it into my main report . It works fine now. Thanks Ron > OOOPS! > [quoted text clipped - 15 lines] > > A report should use a subreport, not a subform. Access will let you embed as > > subform in a report, but as you have seen not everything works when you do that. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.