Dear Expert,
My name is Bounthong from Laos, I am new in this forum, I use MS Office 365, I have a pretty good command in VBA, but may be not very advanced. I am very excited to join.
I am stuck with a report which is the bill of a restaurant to be printed in a printer with rolls paper (XP-80):
- the report header height is fixed, contains bill no, table, date .... information,
- the report footer height is also fixed, contains the price sum, discount, paid amount ... information.
- the detail section which is a subreport showing the food ordered, amount, unit price and price of each food (menu), the height for this section can grow and shrink with the number of record (number of food (menu) ordered.
Now I face 2 problems:
Problem 1. when I design a report with fixed paper size, I see very often too much blank space in the detail section above report footer, especially when the number of ordered menu/food is small.
Question 1: How I can set the height of paper depending on the number of record in detail section?
Question 2: Can I also send from MS Access information through VBA to my printer to set to my customized paper size (which will be changed for each bill)?
Problem 2: Now the problem is bigger, when I open report in preview mode and make paper setup to XP-80 which is installed with rolls paper. The report details report becomes very very long blank space, and when I print it seems that the blank details section is endless, I have to pull out the cable of printer and cancel print queue.
Question 3: how I can limit or set the paper size from vba for rolls paper or rolls paper printer?
Anyone, please help.
Thanks in advance.
My name is Bounthong from Laos, I am new in this forum, I use MS Office 365, I have a pretty good command in VBA, but may be not very advanced. I am very excited to join.
I am stuck with a report which is the bill of a restaurant to be printed in a printer with rolls paper (XP-80):
- the report header height is fixed, contains bill no, table, date .... information,
- the report footer height is also fixed, contains the price sum, discount, paid amount ... information.
- the detail section which is a subreport showing the food ordered, amount, unit price and price of each food (menu), the height for this section can grow and shrink with the number of record (number of food (menu) ordered.
Now I face 2 problems:
Problem 1. when I design a report with fixed paper size, I see very often too much blank space in the detail section above report footer, especially when the number of ordered menu/food is small.
Question 1: How I can set the height of paper depending on the number of record in detail section?
Question 2: Can I also send from MS Access information through VBA to my printer to set to my customized paper size (which will be changed for each bill)?
Problem 2: Now the problem is bigger, when I open report in preview mode and make paper setup to XP-80 which is installed with rolls paper. The report details report becomes very very long blank space, and when I print it seems that the blank details section is endless, I have to pull out the cable of printer and cancel print queue.
Question 3: how I can limit or set the paper size from vba for rolls paper or rolls paper printer?
Anyone, please help.
Thanks in advance.