By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,148 Members | 774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,148 IT Pros & Developers. It's quick & easy.

report repeats himself three times

P: n/a
Hello,

I created a report in Acess2000 and now it repeats itself three times.
At first I thought its a problem with the page margins but that would
mean that empty or almost empty pages would follow the initial report!
In my case the whole report repeats itself completely.

I hope that someone can help me on that

cheers
andi
Feb 13 '08 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"andi" <mu****@gmail.comwrote
I created a report in Acess2000 and now it repeats
itself three times. At first I thought its a problem
with the page margins but that would mean that
empty or almost empty pages would follow the initial report!
Actually, it would mean that an empty / almost empty page would follow each
page of the report.
In my case the whole report repeats itself completely.

I hope that someone can help me on that
There are a couple of possibilities I can think of:

(1) There's something wrong in Access. If you have not applied all three
Service Packs and subsequent patches, then this could very well be the case.
Or, if there had been an error installing Access on your machine, then this
could also be the cause.

(2) There's something wrong with your report.

It's unlikely we will be able to help you in the first case -- you'd simply
have to obtain and apply the Service Packs and patches and see if that
helps.

As to the second possibility, if your car wouldn't move until you started it
three times, and that was all the information you provided to your mechanic,
would you expect that mechanic to be able to tell you how to fix it? You'll
have to explain, in detail, what you have, and what you are doing with what
you have for us to have any ideas to suggest how to avoid the problem.

As a final thought, could it be something as simple as when you print the
report, you have set "number of copies" to three, in the File | Print
dialog?

Larry Linson
Microsoft Office Access MVP

Feb 13 '08 #2

P: n/a
Hello,
I try to be more specific now and I just ignore the comment on "number
of copies"!

The report consists of 4 integrated subreports all of them showing
some data from different querys. There is also a Form which sets two
criteria for the querys, these two criteria are also displayed in the
header of the report.
Everything else is pretty much standard, page number, date and so on.
These things all work properly and if there wouldn't be to more pages
of the report with the same content, everything would be fine.

Larry Linson schrieb:
"andi" <mu****@gmail.comwrote
I created a report in Acess2000 and now it repeats
itself three times. At first I thought its a problem
with the page margins but that would mean that
empty or almost empty pages would follow the initial report!

Actually, it would mean that an empty / almost empty page would follow each
page of the report.
In my case the whole report repeats itself completely.
>
I hope that someone can help me on that

There are a couple of possibilities I can think of:

(1) There's something wrong in Access. If you have not applied all three
Service Packs and subsequent patches, then this could very well be the case.
Or, if there had been an error installing Access on your machine, then this
could also be the cause.

(2) There's something wrong with your report.

It's unlikely we will be able to help you in the first case -- you'd simply
have to obtain and apply the Service Packs and patches and see if that
helps.

As to the second possibility, if your car wouldn't move until you started it
three times, and that was all the information you provided to your mechanic,
would you expect that mechanic to be able to tell you how to fix it? You'll
have to explain, in detail, what you have, and what you are doing with what
you have for us to have any ideas to suggest how to avoid the problem.

As a final thought, could it be something as simple as when you print the
report, you have set "number of copies" to three, in the File | Print
dialog?

Larry Linson
Microsoft Office Access MVP
Feb 13 '08 #3

P: n/a
What is the RecordSource for the main report? That could/would affect the
number of detail records produced. What is the LinkMasterFields and
LinkChildFields property of the top-level Subreport Control? What do you
mean by "integrated subreports"... each nested in a higher-level subreport?

You are likely to have to give details of the criteria gathered by the Form
and how you apply it in the Queries, the details of the Queries, and the
Reports of which they are the RecordSource.

Ignore anything you want, but simple mistakes are often the source of
problems reported in the newsgroup.

Larry Linson
Microsoft Office Access MVP

"andi" <mu****@gmail.comwrote in message
news:c7**********************************@d4g2000p rg.googlegroups.com...
Hello,
I try to be more specific now and I just ignore the comment on "number
of copies"!

The report consists of 4 integrated subreports all of them showing
some data from different querys. There is also a Form which sets two
criteria for the querys, these two criteria are also displayed in the
header of the report.
Everything else is pretty much standard, page number, date and so on.
These things all work properly and if there wouldn't be to more pages
of the report with the same content, everything would be fine.

Larry Linson schrieb:
>"andi" <mu****@gmail.comwrote
> I created a report in Acess2000 and now it repeats
itself three times. At first I thought its a problem
with the page margins but that would mean that
empty or almost empty pages would follow the initial report!

Actually, it would mean that an empty / almost empty page would follow
each
page of the report.
> In my case the whole report repeats itself completely.

I hope that someone can help me on that

There are a couple of possibilities I can think of:

(1) There's something wrong in Access. If you have not applied all
three
Service Packs and subsequent patches, then this could very well be the
case.
Or, if there had been an error installing Access on your machine, then
this
could also be the cause.

(2) There's something wrong with your report.

It's unlikely we will be able to help you in the first case -- you'd
simply
have to obtain and apply the Service Packs and patches and see if that
helps.

As to the second possibility, if your car wouldn't move until you started
it
three times, and that was all the information you provided to your
mechanic,
would you expect that mechanic to be able to tell you how to fix it?
You'll
have to explain, in detail, what you have, and what you are doing with
what
you have for us to have any ideas to suggest how to avoid the problem.

As a final thought, could it be something as simple as when you print the
report, you have set "number of copies" to three, in the File | Print
dialog?

Larry Linson
Microsoft Office Access MVP

Feb 13 '08 #4

P: n/a
DFS
andi wrote:
Hello,

I created a report in Acess2000 and now it repeats itself three times.
At first I thought its a problem with the page margins but that would
mean that empty or almost empty pages would follow the initial report!
In my case the whole report repeats itself completely.
Does your report recordsource have dupe data?

Feb 13 '08 #5

P: n/a
andi <mu****@gmail.comwrote in
news:c7621879-8f48-43ec-9981-
54**********@d4g2000prg.googlegroups.com
:
Hello,
I try to be more specific now and I just ignore the comment on
"number of copies"!

The report consists of 4 integrated subreports all of them showing
some data from different querys. There is also a Form which sets
two criteria for the querys, these two criteria are also displayed
in the header of the report.
Everything else is pretty much standard, page number, date and so
on. These things all work properly and if there wouldn't be to
more pages of the report with the same content, everything would
be fine.
1) If the form is programmed to open the report after entering the
parameters, it might be mis-programmed to open the report 3 times.

2) The number of comies may be set to 3 in the Page-Setup dialog.

3) if the report's main query is mis-programmed, it may be returning
3 copies of the record that meet your criteria.

4) to infinity) only you have the .mdb to debug.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Feb 18 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.