Opening a report to a specific record

  • Thread starter Thread starter Carrie B
  • Start date Start date
C

Carrie B

I have a 320 page report with an individual Item listed on each page of the
report. I have created a way to select an individual record to display on one
page of a report (done through a where statement I believe), however the page
number always says 1 of 1. Is there a way to change the page number to
reflect what the page number would be in the full report. i.e. page 56 of
320, even though its still just one page showing in the report???

Thanks
 
Hi Carrie,

There is if you have a way of knowing what the page number would be.
In which case, you could set it in the On Format event of the report header:

Page = 56

Clifford Bass
 
You need to know how many records in the large report and the relative
position of the individual item. You could probably use a DCount
Function to get that and set that as the value in the single page report.

Generic examples follow as the control sources

=DCount("*","SomeTableOrQuery")

The next thing you need to know is What position the individual item is
in the hierarchy.

Again DCount might be able to do that if you have some way to identify
the individual records position.

=DCount("*","SomeTableOrQuery","ItemID <='" [ItemID] & "'")

So, you can combine that into something like the following.

="Page " & DCount("*","SomeTableOrQuery","ItemID <='" [ItemID] & "'") &
" of " & DCount("*","SomeTableOrQuery") & " Pages"
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Whoops! left out an ampersand

Section should read:

Again DCount might be able to do that if you have some way to identify the
individual records position.

=DCount("*","SomeTableOrQuery","ItemID <='" & [ItemID] & "'")

So, you can combine that into something like the following.

="Page " & DCount("*","SomeTableOrQuery","ItemID <='" & [ItemID] & "'") & " of
" & DCount("*","SomeTableOrQuery") & " Pages"

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

John said:
You need to know how many records in the large report and the relative
position of the individual item. You could probably use a DCount
Function to get that and set that as the value in the single page report.

Generic examples follow as the control sources

=DCount("*","SomeTableOrQuery")

The next thing you need to know is What position the individual item is
in the hierarchy.

Again DCount might be able to do that if you have some way to identify
the individual records position.

=DCount("*","SomeTableOrQuery","ItemID <='" [ItemID] & "'")

So, you can combine that into something like the following.

="Page " & DCount("*","SomeTableOrQuery","ItemID <='" [ItemID] & "'") &
" of " & DCount("*","SomeTableOrQuery") & " Pages"
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Carrie said:
I have a 320 page report with an individual Item listed on each page
of the report. I have created a way to select an individual record to
display on one page of a report (done through a where statement I
believe), however the page number always says 1 of 1. Is there a way
to change the page number to reflect what the page number would be in
the full report. i.e. page 56 of 320, even though its still just one
page showing in the report???

Thanks
Click to expand...
Click to expand...
 
I counted the records in a SQL statement. Thanks John. Excellent idea.

John Spencer said:
Whoops! left out an ampersand

Section should read:

Again DCount might be able to do that if you have some way to identify the
individual records position.

=DCount("*","SomeTableOrQuery","ItemID <='" & [ItemID] & "'")

So, you can combine that into something like the following.

="Page " & DCount("*","SomeTableOrQuery","ItemID <='" & [ItemID] & "'") & " of
" & DCount("*","SomeTableOrQuery") & " Pages"

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

John said:
You need to know how many records in the large report and the relative
position of the individual item. You could probably use a DCount
Function to get that and set that as the value in the single page report.

Generic examples follow as the control sources

=DCount("*","SomeTableOrQuery")

The next thing you need to know is What position the individual item is
in the hierarchy.

Again DCount might be able to do that if you have some way to identify
the individual records position.

=DCount("*","SomeTableOrQuery","ItemID <='" [ItemID] & "'")

So, you can combine that into something like the following.

="Page " & DCount("*","SomeTableOrQuery","ItemID <='" [ItemID] & "'") &
" of " & DCount("*","SomeTableOrQuery") & " Pages"
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Carrie said:
I have a 320 page report with an individual Item listed on each page
of the report. I have created a way to select an individual record to
display on one page of a report (done through a where statement I
believe), however the page number always says 1 of 1. Is there a way
to change the page number to reflect what the page number would be in
the full report. i.e. page 56 of 320, even though its still just one
page showing in the report???

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top