Build index for report... plug index into data base

  • Thread starter Thread starter Gary J. Dikkema \(gary_d\) [WXP X64]
  • Start date Start date
G

Gary J. Dikkema \(gary_d\) [WXP X64]

As in, this information is contained on page 33.

Is this do-able?

TIA.
 
You probably have a pretty good idea what you're talking about ... but I
don't have a clue.

Care to elaborate?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Sure... <VBG>

I need to know what page of a long report certain records from the database
will appear. That page number needs to be captured and stored in the record
so that when the user browses the record he'll know what page of the report
to go to to perform other activities.

There is complex processing issues not related to the page number thing that
I don't want to go into here.

TIA.

Gary D
 
Can the report page number be captured and used to update each record
printed on a report?
 
Gary

I haven't done something like that, but I'm guessing that if you add code in
the OnFormat event of the Details section, you could capture the current
value of [Page] and do something with it. Say, write it out to a table...

Good luck!

Jeff Boyce
Microsoft Office/Access MVP
 
Thats what I was hoping to hear.


Jeff Boyce said:
Gary

I haven't done something like that, but I'm guessing that if you add code
in the OnFormat event of the Details section, you could capture the
current value of [Page] and do something with it. Say, write it out to a
table...

Good luck!

Jeff Boyce
Microsoft Office/Access MVP

Gary J. Dikkema said:
Can the report page number be captured and used to update each record
printed on a report?
 
Check out the following URL

ACC2000: How to Create a Table of Contents or Index for a Report
http://support.microsoft.com/?kbid=210269


Gary J. Dikkema said:
Thats what I was hoping to hear.


Jeff Boyce said:
Gary

I haven't done something like that, but I'm guessing that if you add code
in the OnFormat event of the Details section, you could capture the
current value of [Page] and do something with it. Say, write it out to a
table...

Good luck!

Jeff Boyce
Microsoft Office/Access MVP

Gary J. Dikkema said:
Can the report page number be captured and used to update each record
printed on a report?



Sure... <VBG>

I need to know what page of a long report certain records from the
database will appear. That page number needs to be captured and stored
in the record so that when the user browses the record he'll know what
page of the report to go to to perform other activities.

There is complex processing issues not related to the page number thing
that I don't want to go into here.

TIA.

Gary D


You probably have a pretty good idea what you're talking about ... but
I don't have a clue.

Care to elaborate?

Regards

Jeff Boyce
Microsoft Office/Access MVP

in message As in, this information is contained on page 33.

Is this do-able?

TIA.
 
Thanks!

On reading this it appears that you track a 'category' using the Index
feature.

In my case I need to know which page each records' account number prints on.

At its simplest I always print 10 records per page. The account number field
is an autonumber field... so I have another table with min/max autonumbers
and resulting page numbers.

The only kicker to my process is that the table will be very volatile -
records will be added and deleted - and I haven't figured out a scripted way
to reset the autonumber.

Supposedly there is someone who has scripted the use of a numeric field to
do what I use the autonumber field for but I haven't seen the code for that
yet.

Regards.




John Spencer said:
Check out the following URL

ACC2000: How to Create a Table of Contents or Index for a Report
http://support.microsoft.com/?kbid=210269


Gary J. Dikkema said:
Thats what I was hoping to hear.


Jeff Boyce said:
Gary

I haven't done something like that, but I'm guessing that if you add
code in the OnFormat event of the Details section, you could capture the
current value of [Page] and do something with it. Say, write it out to
a table...

Good luck!

Jeff Boyce
Microsoft Office/Access MVP

Can the report page number be captured and used to update each record
printed on a report?



Sure... <VBG>

I need to know what page of a long report certain records from the
database will appear. That page number needs to be captured and stored
in the record so that when the user browses the record he'll know what
page of the report to go to to perform other activities.

There is complex processing issues not related to the page number
thing that I don't want to go into here.

TIA.

Gary D


You probably have a pretty good idea what you're talking about ...
but I don't have a clue.

Care to elaborate?

Regards

Jeff Boyce
Microsoft Office/Access MVP

in message As in, this information is contained on page 33.

Is this do-able?

TIA.
 
Back
Top