How do i ask what page to go to in a report?

D

DocRogers

I am working on an access 2003 database. I have created a report, and i would
like a pop up to ask what page to skip to. I would then also be able to
export that as a html or .doc file to print/email.

How can I do this?
 
R

Rick Brandt

DocRogers said:
I am working on an access 2003 database. I have created a report, and
i would like a pop up to ask what page to skip to. I would then also
be able to export that as a html or .doc file to print/email.

How can I do this?
Click to expand...

Don't know, but the usual practice would be to apply a filter to the report so
that you only get the data you want rather than trying to print only certain
pages.
 
D

DocRogers

Rick Brandt said:
Don't know, but the usual practice would be to apply a filter to the report so
that you only get the data you want rather than trying to print only certain
pages.
Click to expand...

Thanks for ya help, I have heard you can have a pop up ask what page you go
to... I'm aiming for that. Basically so i can skip to the page im wanting to
print out with out having to skip thru them all.
 
R

Rick Brandt

DocRogers said:
Thanks for ya help, I have heard you can have a pop up ask what page
you go to... I'm aiming for that. Basically so i can skip to the page
im wanting to print out with out having to skip thru them all.
Click to expand...

While it might be possible to do that I have personally never heard of it
and know of no way to programmatically "go to a page" in a report preview.
 
G

Garret

You might be able to find something about the [Page] feature on
reports. Maybe while on a form you can get a msgbox to come up that
asks for the page number, then you can set [Page] on the report to this
number? I'm not sure that this is possible, but just suggesting another
idea if you are stumped.
 
Top