Changing the starting page number

[Sara]

How can I tell MS Access what page to start numbering a
report - other than 1?

We store product information and print a listing for our
stores. When we get new products, we need to "add pages
to the book", and want to start with a page number of our
choosing (probably +1 over the last page we printed).
WORD does it so easily.
Thanks

 

[Marshall Barton]

How can I tell MS Access what page to start numbering a
report - other than 1?

We store product information and print a listing for our
stores. When we get new products, we need to "add pages
to the book", and want to start with a page number of our
choosing (probably +1 over the last page we printed).

You didn't say how you want to specify how you want to
specify the starting page number. If all you need is a
popup prompt, then you can add a text box to the report
header. Let's name it txtStartPage and set its
ControlSource property to something like [Enter Start Page]
Then you can use a line of code in the report header's
Format event:
Me.Page = txtStartPage

 

[Sara]

Marsh -
It worked! I can't thank you enough. This is the first
time I've looked or posted online. Fantastic.
Sara

-----Original Message-----

How can I tell MS Access what page to start numbering a
report - other than 1?

We store product information and print a listing for our
stores. When we get new products, we need to "add pages
to the book", and want to start with a page number of our
choosing (probably +1 over the last page we printed).

You didn't say how you want to specify how you want to
specify the starting page number. If all you need is a
popup prompt, then you can add a text box to the report
header. Let's name it txtStartPage and set its
ControlSource property to something like [Enter Start Page]
Then you can use a line of code in the report header's
Format event:
Me.Page = txtStartPage