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 2813
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******** ************@ma gma.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******@hotma il.com> wrote in message
news:3f******** *************@d reader4.news.xs 4all.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******@hotma il.com> wrote in message news:3f******** *************@d reader4.news.xs 4all.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'Group ing 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******** ************@ma gma.ca... "HJ" <hj******@hotma il.com> wrote in message news:3f******** *************@d reader4.news.xs 4all.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******** ***********@new s-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 suppose to see a
"+" sign at the left of the store procedure name in the Field Explorer section
When we click on the sign "+" we see all the...
|
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, "frmReportOptions" <== popup form
This is the error I get when I try to move to the last page of the report
*after* closing the popup:
"This expression...
|
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 not
Work'
It appears that the type of object returned from the "AllReports" collection
is not a report object.
=>> I need it to be an object of...
|
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 reports at the plan (overall totals), department and division
levels which have sorting and grouping implemented with this new
|
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
correctly - permissions properly set)
InputParameters: just one - provided by a function call that is
functioning properly
When I run the...
| |
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 no problem, couple
of boxes and labels in the report footer.
Now customer wants this signature block on the foot of page 1 (stoopid
IMO as that...
|
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 the report
and each time, A97 shuts down. The seemingly hit 'n miss nature of
the error is intriguing. All I've been able to determine is that if I...
|
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
@salesdate as varchar(20),
|
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 report in
preview mode. Also, it occurs only at the client site; it doesn't occur
at my office or on any other computer I've tried.
I can...
|
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 Report control. My problem is
in rendering the report from the rdlc file for printing to a line printer.
Following the example from MSDN Help at...
|
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...
| |
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
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...
|
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...
|
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.
|
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...
| |