Reuben Cummings
reuben at gfconsultants.com
Thu Jan 13 14:47:44 CST 2005
I'd have to take a look, Dale. Seems to me that the only other simple answer is that the data in the parent and child fields does not match and therefore there is no data to put into a subreport. We came across that yesterday - drove us nuts until we finally found a very slight variation in the data. Beyond that I'm stumped. Reuben Cummings GFC, LLC phone: 812.523.1017 email: reuben at gfconsultants.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dale Kalsow Sent: Thursday, January 13, 2005 3:25 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] SubForms/SubReport not displaying a report I think it is a 2003 thing. It has worked fine since I wrote it in office 97. Andy Lacey <andy at minstersystems.co.uk> wrote:Scratching my head on this one. I'd suggest you send me a copy off-line only I don't have A2003. Ok, here's a shot in the dark. The query which drives the subreport doesn't have a 'Top n' in it does it, or any kind of Distinct which is causing it to suppress extra records? In fact, if you Preview the subreport on its own does it show lots of records as you'd expect? -- Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dale Kalsow > Sent: 13 January 2005 19:23 > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] SubForms/SubReport not displaying a report > > > No it is in the detail section. > > Reuben Cummings wrote:The subform > isn't in the report header is it? Or in a group header that > is only showing on the first page? > > Reuben Cummings > GFC, LLC > phone: 812.523.1017 > email: reuben at gfconsultants.com > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dale Kalsow > Sent: Thursday, January 13, 2005 1:56 PM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] SubForms/SubReport not displaying a report > > > The main form is a report and the item that is not displaying > is a subform/subreport. Yes, I have master and child fields. > My report is a shipping form. If my criteria produces more > then one shipping form then the subform is only printed on > the first shipping form. If I set my criteria to only be one > of the pages that did not print before then it is fine. > > Dale > > Andy Lacey wrote: > Hi Dale > Questions. Do you mean subform not subreport? Is it in the > Detail section? Is it linked via Master and Child fields? > > -- Andy Lacey > http://www.minstersystems.co.uk > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Dale Kalsow > > Sent: 13 January 2005 16:49 > > To: accessd at databaseadvisors.com > > Subject: [AccessD] SubForms/SubReport not displaying a report > > > > > > > > Good Morning,I have Office 2003 with sp 1 installed. I have > an access > > report that has a subform on it. If my report has multiple > pages the > > subform will only show up on the first page of the > report.Has anyone > > seen this and is there a way to fix it?Thanks in advance!Dale > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam protection around > > http://mail.yahoo.com > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > --------------------------------- > Do you Yahoo!? > All your favorites on one personal page Try My Yahoo! > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > > --------------------------------- > Do you Yahoo!? > All your favorites on one personal page - Try My Yahoo! > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --------------------------------- Do you Yahoo!? All your favorites on one personal page Try My Yahoo! -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com