A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Problem Printing A record



 
 
Thread Tools Display Modes
  #1  
Old May 20th, 2010, 01:24 PM posted to microsoft.public.access.forms
Brian
external usenet poster
 
Posts: 1,396
Default Problem Printing A record

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
  #2  
Old May 20th, 2010, 02:00 PM posted to microsoft.public.access.forms
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Problem Printing A record

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" wrote in message
...
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



  #3  
Old May 22nd, 2010, 11:52 AM posted to microsoft.public.access.forms
Brian
external usenet poster
 
Posts: 1,396
Default Problem Printing A record

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" wrote in message
...
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



.

  #4  
Old May 22nd, 2010, 02:04 PM posted to microsoft.public.access.forms
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Problem Printing A record

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" wrote in message
...
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" wrote in message
...
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



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:11 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.