Prev: subform for inputting grades not working
Next: What is the extra field added with a combo or list box
From: Brian on 20 May 2010 08:24 Hello Experts I have a problem with printing a record with a sub-form section. I have a "Quotation" form I print and send to customers. The form incorporates a "Product Detail" subform with a line by line description of services and cost. When I select and print the record, the Product Details are not always in the same order as they appear in display. I have tried fiddling with Sorting & Filters and sometimes I can get the record to print as it appears but I am not sure what triggers the problem or the solution. Here is a typical example: Quotation Sand Down And re-Hang Doors: Court Room 1 £350 Court Room 2 £350 Court Room 3 £400 Court Room 4 £420 When Printed Quotation Court Room 4 £420 Sand Down And re-Hang Doors: Court Room 1 £350 ....etc Dosen't appear to follow any particular pattern that I can see and worse it seems random, some records print fine others get jumbled. The databse has multiple users so perhaps someone is doing something they shouldn't? Would dearly appreciate your comments. Brian Court Room
From: Al Campagna on 20 May 2010 09:00 Brian, > I have a problem with printing a record with a sub-form section. I take it you developed a report to print the specific Quote? How are your subform records sorted? (According to your sample data... AlphaNum sorting is not indicated) You say that they always "display" in the correct order... then that sorting should work for your report too. In reports, Sorting is handled through the Sorting & Grouping dialog box, in report design mode. Sorting in the reports query is always over-ridden by the S&G. If each of the subform records had an autonumber ID field, then sorting on that value would always insure that they sort in the order they were entered. (another method would be to date & timestamp each quote item entry, and sort on that) -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Brian" <Brian(a)discussions.microsoft.com> wrote in message news:E55960B8-8054-4FAD-AC5F-84D24A13710C(a)microsoft.com... > Hello Experts > > I have a problem with printing a record with a sub-form section. > > I have a "Quotation" form I print and send to customers. > > The form incorporates a "Product Detail" subform with a line by line > description of services and cost. > > When I select and print the record, the Product Details are not always in > the same order as they appear in display. I have tried fiddling with > Sorting > & Filters and sometimes I can get the record to print as it appears but I > am > not sure what triggers the problem or the solution. > > Here is a typical example: > Quotation > Sand Down And re-Hang Doors: > Court Room 1 �350 > Court Room 2 �350 > Court Room 3 �400 > Court Room 4 �420 > > When Printed > Quotation > Court Room 4 �420 > Sand Down And re-Hang Doors: > Court Room 1 �350 > ...etc > > Dosen't appear to follow any particular pattern that I can see and worse > it > seems random, some records print fine others get jumbled. > > The databse has multiple users so perhaps someone is doing something they > shouldn't? > > Would dearly appreciate your comments. > Brian > > > > Court Room
From: Brian on 22 May 2010 06:52 Al My apologies for not replying earlier. I actually print from the record and not a report and I was wrong to say that the sub-form detail remains in the same order as originally typed I noticed by chance that the order had in fact altered in record display mode. There is nothing in the table or query asking for an order sort. There are only 4 field on the sub-form [Description], [Price], [Quantity], [Total] (which is Calculated). I can't figure out which field is taking precedence. I think your suggestion to Auto ID each Line on the sub is a great way of sorting the problem although I will look at going down the "Report" route with sorting & grouping. Thanks a lot for some very helpful pointers. Brian "Al Campagna" wrote: > Brian, > > I have a problem with printing a record with a sub-form section. > I take it you developed a report to print the specific Quote? > > How are your subform records sorted? > (According to your sample data... AlphaNum sorting is not indicated) > You say that they always "display" in the correct order... then that > sorting should work for your report too. > > In reports, Sorting is handled through the Sorting & Grouping > dialog box, in report design mode. Sorting in the reports query is always > over-ridden by the S&G. > > If each of the subform records had an autonumber ID field, then > sorting on that value would always insure that they sort in the order > they were entered. (another method would be to date & timestamp > each quote item entry, and sort on that) > -- > hth > Al Campagna > Microsoft Access MVP 2007-2009 > http://home.comcast.net/~cccsolutions/index.html > > "Find a job that you love... and you'll never work a day in your life." > > "Brian" <Brian(a)discussions.microsoft.com> wrote in message > news:E55960B8-8054-4FAD-AC5F-84D24A13710C(a)microsoft.com... > > Hello Experts > > > > I have a problem with printing a record with a sub-form section. > > > > I have a "Quotation" form I print and send to customers. > > > > The form incorporates a "Product Detail" subform with a line by line > > description of services and cost. > > > > When I select and print the record, the Product Details are not always in > > the same order as they appear in display. I have tried fiddling with > > Sorting > > & Filters and sometimes I can get the record to print as it appears but I > > am > > not sure what triggers the problem or the solution. > > > > Here is a typical example: > > Quotation > > Sand Down And re-Hang Doors: > > Court Room 1 £350 > > Court Room 2 £350 > > Court Room 3 £400 > > Court Room 4 £420 > > > > When Printed > > Quotation > > Court Room 4 £420 > > Sand Down And re-Hang Doors: > > Court Room 1 £350 > > ...etc > > > > Dosen't appear to follow any particular pattern that I can see and worse > > it > > seems random, some records print fine others get jumbled. > > > > The databse has multiple users so perhaps someone is doing something they > > shouldn't? > > > > Would dearly appreciate your comments. > > Brian > > > > > > > > Court Room > > > . >
From: Al Campagna on 22 May 2010 09:04
Brian, >>I take it you developed a report to print the specific Quote? That's why I asked that... Printing a form is not a reliable Access function, in that it's not a substitute for a real report. By the nature of tables, if there is no sorting called for in your subform, then they should always display in the ordfer they were entered. Not positive about that, I never had a table that didn't have some logical "sort" designed in. The ID or Date/Time etc... field should do the trick for you... -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "Brian" <Brian(a)discussions.microsoft.com> wrote in message news:AF716818-8DCA-47A8-9376-874A1AE8576D(a)microsoft.com... > Al > > My apologies for not replying earlier. I actually print from the record > and > not a report and I was wrong to say that the sub-form detail remains in > the > same order as originally typed I noticed by chance that the order had in > fact > altered in record display mode. There is nothing in the table or query > asking > for an order sort. There are only 4 field on the sub-form [Description], > [Price], [Quantity], [Total] (which is Calculated). I can't figure out > which > field is taking precedence. > > I think your suggestion to Auto ID each Line on the sub is a great way of > sorting the problem although I will look at going down the "Report" route > with sorting & grouping. > > Thanks a lot for some very helpful pointers. > Brian > > "Al Campagna" wrote: > >> Brian, >> > I have a problem with printing a record with a sub-form section. >> I take it you developed a report to print the specific Quote? >> >> How are your subform records sorted? >> (According to your sample data... AlphaNum sorting is not indicated) >> You say that they always "display" in the correct order... then that >> sorting should work for your report too. >> >> In reports, Sorting is handled through the Sorting & Grouping >> dialog box, in report design mode. Sorting in the reports query is >> always >> over-ridden by the S&G. >> >> If each of the subform records had an autonumber ID field, then >> sorting on that value would always insure that they sort in the order >> they were entered. (another method would be to date & timestamp >> each quote item entry, and sort on that) >> -- >> hth >> Al Campagna >> Microsoft Access MVP 2007-2009 >> http://home.comcast.net/~cccsolutions/index.html >> >> "Find a job that you love... and you'll never work a day in your >> life." >> >> "Brian" <Brian(a)discussions.microsoft.com> wrote in message >> news:E55960B8-8054-4FAD-AC5F-84D24A13710C(a)microsoft.com... >> > Hello Experts >> > >> > I have a problem with printing a record with a sub-form section. >> > >> > I have a "Quotation" form I print and send to customers. >> > >> > The form incorporates a "Product Detail" subform with a line by line >> > description of services and cost. >> > >> > When I select and print the record, the Product Details are not always >> > in >> > the same order as they appear in display. I have tried fiddling with >> > Sorting >> > & Filters and sometimes I can get the record to print as it appears but >> > I >> > am >> > not sure what triggers the problem or the solution. >> > >> > Here is a typical example: >> > Quotation >> > Sand Down And re-Hang Doors: >> > Court Room 1 �350 >> > Court Room 2 �350 >> > Court Room 3 �400 >> > Court Room 4 �420 >> > >> > When Printed >> > Quotation >> > Court Room 4 �420 >> > Sand Down And re-Hang Doors: >> > Court Room 1 �350 >> > ...etc >> > >> > Dosen't appear to follow any particular pattern that I can see and >> > worse >> > it >> > seems random, some records print fine others get jumbled. >> > >> > The databse has multiple users so perhaps someone is doing something >> > they >> > shouldn't? >> > >> > Would dearly appreciate your comments. >> > Brian >> > >> > >> > >> > Court Room >> >> >> . >> |