I have a Report that creates a Catalogue of Products we sell under various
Headings eg:
Books, Recordings, Health Food, Diet Foods, etc
There are 82 Headings and a total of 6000+ products which makes a big
Catalogue.
A Printed version of the Catalogue is done every 2 Months and we manually
create an Index which takes HOURS, the problem is the Catalogue page numbers
change depending on New or Deleted product ranges.
Can anyone help me to create an Index using Access so that the page numbers
go against the Headings.
Thanks in advance.
Ross
7  5587 
On Wed, 17 Nov 2004 12:00:29 +0800, Ross Hamilton wrote: I have a Report that creates a Catalogue of Products we sell under various
Headings eg:
Books, Recordings, Health Food, Diet Foods, etc
There are 82 Headings and a total of 6000+ products which makes a big
Catalogue.
A Printed version of the Catalogue is done every 2 Months and we manually
create an Index which takes HOURS, the problem is the Catalogue page numbers
change depending on New or Deleted product ranges.
Can anyone help me to create an Index using Access so that the page numbers
go against the Headings.
Thanks in advance.
Ross
What version of Access are you using?
Here is a method for Access 2000.
See Microsoft KnowledgeBase article:
210269 'ACC2000: How to Create a Table of Contents or Index for a
Report'
For Access 97 and older:
131588 'ACC: How to Create a Table of Contents or Index for a Report'
You must actually run the report (in preview, or by actually printing
it).
Then run a separate report, using the TOC table made by the first
report, to print out just the Table of Contents.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
See:
How to Create a Table of Contents or Index for a Report
at: http://support.microsoft.com/default...b;en-us;210269
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Ross Hamilton" <oz****@hotmail .com> wrote in message
news:41******** @news.highway1. com.au... I have a Report that creates a Catalogue of Products we sell under various
Headings eg:
Books, Recordings, Health Food, Diet Foods, etc
There are 82 Headings and a total of 6000+ products which makes a big
Catalogue.
A Printed version of the Catalogue is done every 2 Months and we manually
create an Index which takes HOURS, the problem is the Catalogue page
numbers
change depending on New or Deleted product ranges.
Can anyone help me to create an Index using Access so that the page
numbers
go against the Headings.
Sorry, I am using Access97, and the link is for 2000 do you know of a way in
97??
Ross
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:41******** *************** @per-qv1-newsreader-01.iinet.net.au ... See:
How to Create a Table of Contents or Index for a Report
at:
http://support.microsoft.com/default...b;en-us;210269
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Ross Hamilton" <oz****@hotmail .com> wrote in message
news:41******** @news.highway1. com.au...I have a Report that creates a Catalogue of Products we sell under
various Headings eg:
Books, Recordings, Health Food, Diet Foods, etc
There are 82 Headings and a total of 6000+ products which makes a big
Catalogue.
A Printed version of the Catalogue is done every 2 Months and we
manually create an Index which takes HOURS, the problem is the Catalogue page
numbers
change depending on New or Deleted product ranges.
Can anyone help me to create an Index using Access so that the page
numbers
go against the Headings.
Ross, I think you will find that the same approach works in A97, but there
is an earlier version of the same article.
To find it:
Go to support.microso ft.com
Choose the knoweldgebase.
Ask for the advanced search.
Specify the product as Access.
Run a search for Table of Contents" as the "exact phrase".
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Ross Hamilton" <oz****@hotmail .com> wrote in message
news:41******@n ews.highway1.co m.au... Sorry, I am using Access97, and the link is for 2000 do you know of a way
in
97??
Ross
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:41******** *************** @per-qv1-newsreader-01.iinet.net.au ... See:
How to Create a Table of Contents or Index for a Report
at:
http://support.microsoft.com/default...b;en-us;210269
"Ross Hamilton" <oz****@hotmail .com> wrote in message
news:41******** @news.highway1. com.au... >I have a Report that creates a Catalogue of Products we sell under various > Headings eg:
>
> Books, Recordings, Health Food, Diet Foods, etc
>
> There are 82 Headings and a total of 6000+ products which makes a big
> Catalogue.
> A Printed version of the Catalogue is done every 2 Months and we manually > create an Index which takes HOURS, the problem is the Catalogue page
> numbers
> change depending on New or Deleted product ranges.
>
> Can anyone help me to create an Index using Access so that the page
> numbers
> go against the Headings.
Found it thanks very much.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:41******** *************** @per-qv1-newsreader-01.iinet.net.au ... Ross, I think you will find that the same approach works in A97, but there
is an earlier version of the same article.
To find it:
Go to support.microso ft.com
Choose the knoweldgebase.
Ask for the advanced search.
Specify the product as Access.
Run a search for Table of Contents" as the "exact phrase".
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Ross Hamilton" <oz****@hotmail .com> wrote in message
news:41******@n ews.highway1.co m.au... Sorry, I am using Access97, and the link is for 2000 do you know of a
way in
97??
Ross
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:41******** *************** @per-qv1-newsreader-01.iinet.net.au ... See:
How to Create a Table of Contents or Index for a Report
at:
http://support.microsoft.com/default...b;en-us;210269
"Ross Hamilton" <oz****@hotmail .com> wrote in message
news:41******** @news.highway1. com.au...
>I have a Report that creates a Catalogue of Products we sell under
various > Headings eg:
>
> Books, Recordings, Health Food, Diet Foods, etc
>
> There are 82 Headings and a total of 6000+ products which makes a big
> Catalogue.
> A Printed version of the Catalogue is done every 2 Months and we
manually > create an Index which takes HOURS, the problem is the Catalogue page
> numbers
> change depending on New or Deleted product ranges.
>
> Can anyone help me to create an Index using Access so that the page
> numbers
> go against the Headings.
Fred, Thanks for your prompt response I found the Access97 article and now
all I have to do is make it work.
"fredg" <fg******@examp le.invalid> wrote in message
news:1n******** *************** ******@40tude.n et... On Wed, 17 Nov 2004 12:00:29 +0800, Ross Hamilton wrote:
I have a Report that creates a Catalogue of Products we sell under
various Headings eg:
Books, Recordings, Health Food, Diet Foods, etc
There are 82 Headings and a total of 6000+ products which makes a big
Catalogue.
A Printed version of the Catalogue is done every 2 Months and we
manually create an Index which takes HOURS, the problem is the Catalogue page
numbers change depending on New or Deleted product ranges.
Can anyone help me to create an Index using Access so that the page
numbers go against the Headings.
Thanks in advance.
Ross
What version of Access are you using?
Here is a method for Access 2000.
See Microsoft KnowledgeBase article:
210269 'ACC2000: How to Create a Table of Contents or Index for a
Report'
For Access 97 and older:
131588 'ACC: How to Create a Table of Contents or Index for a Report'
You must actually run the report (in preview, or by actually printing
it).
Then run a separate report, using the TOC table made by the first
report, to print out just the Table of Contents.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
> Can anyone help me to create an Index using Access so that the page numbers go against the Headings.
Depends. Is your report grouped by anything? For example, if it's a
product list, is it grouped by product family, so toothbrush and
toothpaste come together, and then popcorn comes somewhere else? If
not you can use the product itself, but that's going to be an awefully
long iindex.
Go into your report's design, then right-click on either detail or the
group heading, and say "add event" or something like that, should be
the option on the top. Another menu comes up, and you want the code
designer to write a VB function.
Declare a report-level string variable that's going to hold your
index. Like:
dim sIndex as string
Then in the sub you just added, when your data changes, you want
something like:
If InStr(sIndex, [CurrentDataValu e]) = 0 Then
sIndex = sIndex + [CurrentDataValu e]
sIndex = sIndex + String(" ", 30) + [Page] + vbCrLf
End If
( You can put that on one line. )
Now go back into your report's design, add a text-box to the report
footer, set it's CanGrow property to true, and then add more code to
when the report-footer gets formatted, and say:
Textbox391.Text = sIndex
Change 391 to refer to the one you just added to the report footer
section. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Sean C. |
last post by:
Helpful folks,
Most of my previous experience with DB2 was on s390 mainframe systems
and the optimizer on this platform always seemed very predictable and
consistent. Since moving to a WinNT/UDB 7.2 environment, the choices
the optimizer makes often seem flaky. But this last example really
floored me. I was hoping someone could explain why I get worse
response time when the optimizer uses two indexes, than when it uses
one. Some context:
|
by: Mike Wiseley |
last post by:
I would like to be able to loop through all the report objects in the
database and show the recordsource for each and every report, even if the
report is not actively open. If I know in advance of this analysis that I
all of my reports have queries that start with "qry" I can use the code
below. I wonder if there is a way to do this code if the queries could have
several naming conventions (or no convention at all).
Here is my code for...
|
by: dog |
last post by:
I've seen plenty of articles on this topic but none of them have been
able to solve my problem.
I am working with an Access 97 database on an NT4.0 machine, which has
many Access reports.
I want my users to be able to select a report, click on a command
button on a form, which will then automatically create the report as a
pdf file and save it to the user's machine.
I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
|
by: badboybrown |
last post by:
Hello,
Is it possible to step through the "Create MDE" process and see what is
causing Access to crash?
I tried, unsuccessfully, many times to create an MDE from my database.
But, randomly, I checked the "Allow Full Menus" in the Startup section.
I was then able to create an MDE.
That worked once. It has not worked since and I don't particularly
|
by: Vayse |
last post by:
I have a report which has several sub reports. Each sub report starts on its
own page, and may be 2 or 3 pages long.
I'd like to create an index on the first page of the main report. Something
like:
Clients..............p1
Sales................p3
Salesmen.........p4
| | |
by: DKelley |
last post by:
I'm receiving a "severe" error that I can't seem to trap and evaluate in SQL Server 2000 (and no, I can't switch to 2005, this is on our customers' machines). And I've not been able to find info on this specific problem.
This is essentially the statement I'd like to catch and gracefully quit if it occurs:
CREATE UNIQUE NONCLUSTERED INDEX UQ_First_Key_SecondField_ThirdField
ON . ( Prime_Key, SecondField, ThirdField ) ON
SET @ErrorNumber...
|
by: creative1 |
last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however, working with complex reports is tricky
Assumption: Reader of this article have basic knowledge of creating data reports.
Creating a Parent-Child Command and create a DataReport
Suppose we have a database called company with two tables
...
|
by: Niranjan |
last post by:
I want create a report based on the crosstab query which normally
returns about 50 - 60 columns. The columns have names of the counties
and they keep changing for every session. Is there a way to program a
dynamic multi-page crosstab report?
|
by: Paul H |
last post by:
I want to base a form on a crosstab query. The query shows statistics
for a user defined period. The column headings will look something
like this:
ClientID Month01 Month02 Month03 etc..
So if the user selects 3 months in the criteria form, there will be 3
(month) column headings, if he selects 6 months, the will be 6
headings.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
