 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / October 2007Save As Command Can't save any subforms
When testing a change (adding a reject e-mail) to an existing database I'm getting this screen: "The Save As command can't process any subforms contained in your report" Do you want to proceed anyway? I have never seen this message before what is wrong? The form does have a subform, but the report does not. Thanks, > When testing a change (adding a reject e-mail) to an existing > database I'm getting this screen: [quoted text clipped - 6 lines] > > Thanks, You used subforms inside a report instead of subreports.  SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com No I use subreports inside reports not subforms hence the question as to why I'm getting that message and what it means. Thanks, Leslie > > When testing a change (adding a reject e-mail) to an existing > > database I'm getting this screen: [quoted text clipped - 8 lines] > > You used subforms inside a report instead of subreports. > No I use subreports inside reports not subforms hence the question as > to why I'm getting that message and what it means. Did you by any chance use the "Save as Report" option on a form that contained subforms? When doing that only the parent form is re-created as a report. The subforms STAY as subforms. That is the only time I have seen the message you are describing. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Yes both the form and report have subs the subform has a subform for that form and the report has a subreport for that report. So does that mean that it isn't saving the subform and it isn't a large problem? I have never seen this before and I use forms/subform and report/subreports all the time. > > No I use subreports inside reports not subforms hence the question as > > to why I'm getting that message and what it means. [quoted text clipped - 4 lines] > > That is the only time I have seen the message you are describing. > Yes both the form and report have subs the subform has a subform for > that form and the report has a subreport for that report. So does > that mean that it isn't saving the subform and it isn't a large > problem? I have never seen this before and I use forms/subform and > report/subreports all the time. The point that I might not be making as clearly as I would like is that what you think is a subreport might actually be a subform. Access will allow you to put a form inside a report and it will act very much like a subreport. That is until you try to use OutputTo or SendObject on it at which point you will get the error you are seeing. Bottom line, make absolutely sure that all of your subreports are in fact using reports as their SourceObject and not forms. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Thank you I will verify that. One more question can the subform be used when you have created the report from the report design wizard? Thanks, > > Yes both the form and report have subs the subform has a subform for > > that form and the report has a subreport for that report. So does [quoted text clipped - 10 lines] > Bottom line, make absolutely sure that all of your subreports are in fact using > reports as their SourceObject and not forms. > Thank you I will verify that. One more question can the subform be > used when you have created the report from the report design wizard? I don't know about that. Where it is easy to get this condition is to take a form with one or more subforms and use the right-click option to "Save as a Report" on the main form. It creates a report based on the design of the main form, but the subforms are still subforms. They each need to be converted to reports separately. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
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.