custom paper size

[kolait]

Hello I have a piece of paper 17 cm wide and 12 cm high. I want to print the information in specific parts of this paper. Please help me and suggest

 

[The_Doc_Man]

If this paper size can be accomodated by your printer as a custom size, Access would see it and would allow you to use Page Setup (on the report ribbon) as the way to control the size. Otherwise you would have to figure out some things on your own.

You can certainly set the width of a report or form using a length unit called "twips" - 1440 twips per inch. Remember that you set the width of a form for all sections but you set the height on a section by section basis. The question would then be whether you can print it.

I looked up the "standard" paper sizes and that isn't one of them. It isn't A0, A1, ... A6, or A7. So it might be tricky.

As to the "printing on specific parts" - you can adjust controls in increments of 1/1440th of an inch. It will be a matter of aligning everything.

You adjust controls based on their Left and Top margins plus their Width and Length. You adjust report sections by their Width and Height. Note that no section width can exceed the given page limits as set by Page Size options.

 

[arnelgp]

adjust your Textbox/Images, etc so it will rightly align to the "part" where you want to print.

 

[gemma-the-husky]

I think you are venturing towards desk top publishing.
Maybe you could design your end report in publisher, and then get Access to fill the various text boxes with appropriate data.

 

[FrankRuperto]

You can go into your printer preferences and setup a custom paper size. Then in your Access report page setup you can chose that paper size.
You can also create a new custom form in the printer server that can be used with any printer.

 

[kolait]

Greetings to all of you friends
thank you
I have the image below, which is 17 x 12 cm in paper size. I want the information to be recorded exactly in the numbering sections .. so that each printer does not need to enter the settings and print.
Do I have to create all the adjustment tasks in the report? And what would you do if you had this file?
thank you

 

[arnelgp]

put the image to your report.
then add textbox to each {numbers].
you should be able to Bind the textbox to the Recordsource of the report.

 

[kolait]

I put the photo in the details section .. After placing the fields, I deactivate the image .. but it does not work ..

You can go into your printer preferences and setup a custom paper size. Then in your Access report page setup you can chose that paper size.
You can also create a new custom form in the printer server that can be used with any printer.

Thank you .. I went the route. I also saved the new form but it does not appear in the paper size list

 

[kolait]

put the image to your report.
then add textbox to each {numbers].
you should be able to Bind the textbox to the Recordsource of the report.

I put the photo in the details. I also disabled the print time .. but the fields in the paper are not correct and there is probably a problem with the size of the paper .. I do not know what the size of the paper and the size of the details are.

 

[arnelgp]

You need to resize the image to fit onyour paper.
Then "send to back" the image so that the textbox is showing.

 

[arnelgp]

here is a sample.

 

[kolait]

Hello
thanks a lot
It was a good example.
What if I want a separate print for each record to be printed in 3 copies? Is there a need for coding or should adjustments be made to the report?

 

[arnelgp]

it

Is there a need for coding or should adjustments be made to the report?

i think it is best to use Standards paper size like A4.
then you adjust your image to fit the paper size.

What if I want a separate print for each record to be printed in 3 copies?

yes you can do that.

add a Dummy Table, with field (Num, Integer).
add 3 records to dummy table, 1, 2, 3.

now create a query and choose the table of your report and the dummy table.
just use

"select * from yourTable;" (not the dummy)

save the query and use the query as Recordsource of your report.

 

[kolait]

Thank you so much for taking the time for me
I will ask you if there is a problem. Thank you again

it

i think it is best to use Standards paper size like A4.
then you adjust your image to fit the paper size.


yes you can do that.

add a Dummy Table, with field (Num, Integer).
add 3 records to dummy table, 1, 2, 3.

now create a query and choose the table of your report and the dummy table.
just use

"select * from yourTable;" (not the dummy)

save the query and use the query as Recordsource of your report.

Thank you so much for taking the time for me
I will ask you if there is a problem. Thank you again