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

Report Problem

P: n/a
The database I am working on was built by someone else. This database
records a production run. When a report is called for this database, the
report does not come to the screen but a series of questions do. When the
questions are answered, they fill in some blanks on the report and the
report comes to the screen. The questions being asked are redundant as they
are already present in the table. What I can't find is how to stop these
redundant questions coming to the screen. Help would be appreciated.

Thank you,

Bill.
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
HJ
A possible cause for this lies in the Sorting and Grouping. When a field is
mentioned there, but is not put on the report, you will get those questions.

If this is not the cause, please specify what kind of questions you get.

HJ

"William Bradley" <br******@magma.ca> wrote in message
news:gf********************@magma.ca...
The database I am working on was built by someone else. This database
records a production run. When a report is called for this database, the
report does not come to the screen but a series of questions do. When the
questions are answered, they fill in some blanks on the report and the
report comes to the screen. The questions being asked are redundant as they are already present in the table. What I can't find is how to stop these
redundant questions coming to the screen. Help would be appreciated.

Thank you,

Bill.

Nov 12 '05 #2

P: n/a

"HJ" <hj******@hotmail.com> wrote in message
news:3f*********************@dreader4.news.xs4all. nl...
A possible cause for this lies in the Sorting and Grouping. When a field is mentioned there, but is not put on the report, you will get those questions.
If this is not the cause, please specify what kind of questions you get.


The table records the manufacture of a product. During the course of which
there are some rejects due to a variety of causes. When the operator fills
in the form, she will fill in the number "Slides Damaged", and this is
recorded on the underlying table. When the run is finished a report is
produced that records all the details. When the report is called it asks the
question: "Slides Damaged" which has to be filled in before the report comes
to the screen and can be printed. As can be seen, this information is
already present in the table.

Regards, Bill.
Nov 12 '05 #3

P: n/a
William Bradley wrote:
"HJ" <hj******@hotmail.com> wrote in message
news:3f*********************@dreader4.news.xs4all. nl...
A possible cause for this lies in the Sorting and Grouping. When a
field

is
mentioned there, but is not put on the report, you will get those
questions.

If this is not the cause, please specify what kind of questions you
get.


The table records the manufacture of a product. During the course of
which there are some rejects due to a variety of causes. When the
operator fills in the form, she will fill in the number "Slides
Damaged", and this is recorded on the underlying table. When the run
is finished a report is produced that records all the details. When
the report is called it asks the question: "Slides Damaged" which has
to be filled in before the report comes to the screen and can be
printed. As can be seen, this information is already present in the
table.

Regards, Bill.


I don't think it can be looking at the same thing. It sounds as though the
form is referencing something else. It might be useful to see what
recordsource the report is using and what the controls are bound to.
Nov 12 '05 #4

P: n/a
Access asks for "parameters" if the report or its recordsource contains
references to names that are not fields in the table.

Examples of how this could happen:
* The RecordSource of the report is a query, and some of these fields are
not in the query.

* The names are misspelt (e.g. space missing) on the report.

* The names are in a WhereCondition applied to the OpenReport action.

* The names are in the report's Filter or OrderBy properties, or in the
Sorting'n'Grouping dialog (as already suggested).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"William Bradley" <br******@magma.ca> wrote in message
news:rF********************@magma.ca...

"HJ" <hj******@hotmail.com> wrote in message
news:3f*********************@dreader4.news.xs4all. nl...
A possible cause for this lies in the Sorting and Grouping. When a field is
mentioned there, but is not put on the report, you will get those

questions.

If this is not the cause, please specify what kind of questions you get.


The table records the manufacture of a product. During the course of which
there are some rejects due to a variety of causes. When the operator fills
in the form, she will fill in the number "Slides Damaged", and this is
recorded on the underlying table. When the run is finished a report is
produced that records all the details. When the report is called it asks

the question: "Slides Damaged" which has to be filled in before the report comes to the screen and can be printed. As can be seen, this information is
already present in the table.

Regards, Bill.

Nov 12 '05 #5

P: n/a

"Allen Browne" <ab***************@bigpond.net.au> wrote in message
news:2x*******************@news-server.bigpond.net.au...
Access asks for "parameters" if the report or its recordsource contains
references to names that are not fields in the table.

Examples of how this could happen:
* The RecordSource of the report is a query, and some of these fields are
not in the query.


When I looked more closely, the above was the problem and I scrapped the
report and built a new one which solved the difficulty.

Thank you,

Bill.
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.