Open report at specific (variable) page

[Wayne-I-M]

Hi

Is it possible to open a report a a specific page - not filter the report

I have a form with a text box showing a statement number and would like to
open the report at the page containing that number ( the report is sorted by
the statement number - shown in the page header).

I can't filter the report as it contains a number of running sums which
would be wrong if I don't show the entire report - or at least the previous
pages

Many thanks

 

[Tom van Stiphout]

On Mon, 5 May 2008 03:11:01 -0700, Wayne-I-M

There is no uilt-in way to do that.
*Maybe* you can use SendKeys to send some PageDown instructions, but I
don't think it will be reliable.

-Tom.

 

[Wayne-I-M]

Hi Tom

Thank you for the advice - I didn't think so. I have tried "many" strange
combinations to get it to work. It's not really import but I think it would
add a small "something" to the DB (It's a new accounts DB that combines 5
companies from the same holding company- so there are thousands of report
pages possible) when a user enters an amount I have a view statement checker
that compairs the on-line banking statment with what the user has just addedd
- checks for errors in input.

Thanks again Tom


Oh and in case anyone else is reading this - the one thing that does work
that I found was to filter the base querry the report is based on by removing
any ID's after the ID just created (onClick of th openReport event fro the
form) - not ideal if you have more than one person inputting (due to
inputting different dated items) but it will (if used with go to last page)
sort of do the trick (opens the report to the item just entered whist
maintaining any running sums).
If you can get it to work any better, please post your answer so everyone
can see.

The obvious answer would be to do the running sums in the querry and not the
report and then filter for the statement number and anything lower. (I'll
alter it one day - too much to do at the moment)

 

[eugenio.guadalupi]

Hi

Is it possible to open a report a a specific page - not filter the report

I have a form with a text box showing a statement number and would like to
open the report at the page containing that number ( the report is sorted
by
the statement number - shown in the page header).

I can't filter the report as it contains a number of running sums which
would be wrong if I don't show the entire report - or at least the
previous
pages

Many thanks

you spicing franc