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. 5 2789
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.
"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.
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.
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.
"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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: GC |
last post by:
HI,
I'am using Crystal Report with visual Studio .NEt 2003
When i make a report using a store procedure, I can not see all the fields
of the store proc and i'm suppose to see those fields. I'm...
|
by: deko |
last post by:
I can't move a multi-page report to the last record unless I keep the popup
form (that defined it's subreports) open.
DoCmd.OpenReport "rptStandard", acViewNormal
DoCmd.Close acForm,...
|
by: xzzy |
last post by:
I need to automate a report in a different database (and thank yous to Terry
Kreft for pointing me in the right direction).
below is the code with the one line that does not work, marked: 'Does...
|
by: ahaque38 |
last post by:
Hello.
Using A2K SP3, I am having the following problem with a report using
"Sorting and Grouping".
I have recently added a grouping in the reports for
"Category2<>'CONTRACTS'".
I have...
|
by: Rick Caborn |
last post by:
I am having a problem with an Access 2000 report getting data from SQL
Server 2000. Here are the specifications for it:
RecordSource: a stored procedure (tested via query analyzer and working...
|
by: Trevor Best |
last post by:
I have a report that's fairly simple, page headers and footers, detail
has a subreport in (can vary in length). The customer wanted a signature
block for them, their client and 3rd party. This was...
|
by: MLH |
last post by:
Trouble is, it doesn't happen every time. Yesterday, for example, it
happened only once and not again afterward. Some days ago, a similar
situation. Today, well - I tried 7 times straight to open...
|
by: Bill Nguyen |
last post by:
What's the VB syntax to run the CR report using the following SP?
I use CrystalreportViewer and ReportDocument.
Thanks
Bill
Here's the SP in SQLserver 2K:
CREATE proc mysp_ReportSubmission...
|
by: TC |
last post by:
I've produced an Access application for a client. For one report, text
gets cut-off at the right margin when we print the report. It does this
only when we print; it doesn't happen when we view the...
|
by: =?Utf-8?B?UmljaA==?= |
last post by:
On my development machine where I have Visual Studio 2005 loaded, I have an
app that uses the Report control. I can view data in report format with the
Report control -- the data renders OK in the...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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,...
|
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...
| |