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 5 2375
"andi" <mu****@gmail.c omwrote
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
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.c omwrote
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
What is the RecordSource for the main report? That could/would affect the
number of detail records produced. What is the LinkMasterField s 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.c omwrote in message
news:c7******** *************** ***********@d4g 2000prg.googleg roups.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.c omwrote
> 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
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?
andi <mu****@gmail.c omwrote in
news:c7621879-8f48-43ec-9981- 54**********@d4 g2000prg.google groups.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mike Conklin |
last post by:
This one really has me going. Probably something silly. I'm using
dcount for a report to determine the number of different types of
tests proctored in a semester.
My report is based on a parameter query which is the recordsource for
the report. The parameter is <=. The query returns the
correct amounts upto the date entered (no need for "between" dates
here).
There are 8 textboxes with dcounts; 2 other boxes Sum some of these
|
by: Jessica |
last post by:
I have a database where a person is able to enter the different tasks
they do each day by specific department and matter.
On a form they enter the date, their name, and their title; in a
subform they select from a drop down list what department/section this
task pertains to and then they select the matter they are discussing
or working on with that department. They enter the time they spent on
this matter and they also enter some more...
|
by: viuxrluxvbbc |
last post by:
Hi im trying to write a program that will read in numbers and display
them in ascending order along with a count of how many times it
repeats. i got the numerical order portion done but cant figure out the
other part. i keep on getting a wrong number
please help
#include <iostream>
using namespace std;
int main()
{
|
by: baool |
last post by:
I have a report that keeps track of sales by company for any given month within a year. I am using two subreports embedded within a report to produce 2006 (one subreport) and 2007 (the other subreport) sales by station for any month I choose. The report works but I have two issues:
1) The subreports are located in the detail section of the report. The report should be three pages long but the report keeps repeating the data for a total of...
|
by: prn |
last post by:
Hi folks,
I'm looking for a little advice here. I need to create a report that is totals only, with no detail records. I have a database with a lot of individuals (people) and the report has to have some overall totals, totals per state, totals by gender, race/ethnicity, and several other criteria. This report does not need to (and should not) report on each individual, just the totals.
I can create expressions for each of the items I...
| |
by: Joyfully |
last post by:
I and a new user of MS Access 2003, and I need help with a report created from a form. I created a form that data is inputed weekly. I created a report to display this data in putting only the last entry from the form in the report by putting Last(field name) in the ControlSource of each field on the report. The report pull the last entry, but it repeats it as many times as I have records in the form. How do I get the report to only show...
|
by: lupo666 |
last post by:
Hi everybody, this time I have three problems driving me nuts :-(((
(1)
I have a report with 20 or so Yes/No "squares". Is there a way to
either hide/show the "square" or change the yes/no relative textbox,
depending on value?
(2)
|
by: jglabas |
last post by:
For a report, I am using a query as my record source. The query produces 5 columns by 3272 records.
The data in columns 1 & 2 (“Objective” and “Rating”) repeats every 409 records The data for “initial” and “Date” are unique for the individual. Currently there are 8 individuals (409 * 8 = 3272)
. . . . .. . . . .Objective . . . Rating . . Initial . . . .. Date . . . . . Name
. . . . .abc. . . . . . .a. . . . . . jg. . . . . .1/12/07 . ....
|
by: Studiotyphoon |
last post by:
Hi,
I have report which I need to print 3 times, but would like to have
the following headings
Customer Copy - Print 1
Accounts Copy - Print 2
File Copy -Print 3
I created a macro to print the report three times, but do not know how
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: 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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |