473,836 Members | 1,405 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Weird parameter prompt appearing after creating a subreport

I have a pair of tables (Applicaties en Releases) in a 1-to-N relation.
I created and tested a report based on Applicaties. I then added a
subreport based on Releases using the wizard. This displays the correct
data.

BUT: before it displays, it asks me to enter a parameter value for
"Applicatie s". It makes no apparent use of any value entered.

I have seen similar messages before, requesting a field value to be
entered - caused by either mistyping a field name or deleting a field in
an underlying query or table. But I've never seen Access request a
parameter value for a table before (what on earth does that mean?).
The behaviour is consistent: deleting the subreport removes the prompt,
recreating it causes it to come back. Basing the subreport indirectly on
the table, via a query, produces the same problem.

Googling on the archive for this group I found one similar problem, but
no solution. This prompt will be confusing for the users - how do I get
rid of it?
Am using Access 2000, Dutch-language version, Win XP Pro

--
Stephen Poley
Nov 13 '05 #1
4 2427
Stephen Poley <sb************ ******@xs4all.n l> wrote in
news:eq******** *************** *********@4ax.c om:
I have a pair of tables (Applicaties en Releases) in a 1-to-N relation.
I created and tested a report based on Applicaties. I then added a
subreport based on Releases using the wizard. This displays the correct
data.

BUT: before it displays, it asks me to enter a parameter value for
"Applicatie s". It makes no apparent use of any value entered.


You must have used somewhere a reference to an object named "Applicatie s"
without being recognized. You either have used a wrong syntax or the object
doesn't exist.
As you said you have a table named "Applicatie s", it really must be the
syntax. It could be a dot or exclamation mark or anything similarly simple
and easy to overlook.

It could also be somewhere in a macro or a piece of VBA.
--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)
Nov 13 '05 #2
On 26 Aug 2005 15:34:13 GMT, Dodo
<dodo2u@-takethisNOSPAMo ut-freemail.nl> wrote:
Stephen Poley <sb************ ******@xs4all.n l> wrote in
news:eq******* *************** **********@4ax. com:
I have a pair of tables (Applicaties en Releases) in a 1-to-N relation.
I created and tested a report based on Applicaties. I then added a
subreport based on Releases using the wizard. This displays the correct
data.

BUT: before it displays, it asks me to enter a parameter value for
"Applicatie s". It makes no apparent use of any value entered.


You must have used somewhere a reference to an object named "Applicatie s"
without being recognized. You either have used a wrong syntax or the object
doesn't exist.
As you said you have a table named "Applicatie s", it really must be the
syntax. It could be a dot or exclamation mark or anything similarly simple
and easy to overlook.

It could also be somewhere in a macro or a piece of VBA.


Well, I've looked as hard as I can. This report does not use any macro
or VBA. (In fact so far I've only written four lines of VBA in the whole
database, all of which have been tested.) The report and subreport are
each based on a query; both queries run without producing the prompt.
(And both are in any case simple drag-and-drop queries - I've not
inserted any formulae.) I've tried removing every single control from
the subreport - the prompt still appears. I remove the subreport control
itself - it goes away. The only reference to the Applicaties table in
the subreport control properties (that I either wanted to be there or
can find) is the one that couples field Applicaties.AKe y in the one
table to Releases.AKey in the other - and that is obviously correct
because the report produces the correct data.

So the wizard takes a query which runs fine and somehow turns it into a
subreport which doesn't.

I gather from the lack of response that it's not a known Access problem.
But if anyone can think of somewhere I should have looked that I've not
mentioned ...

--
Stephen Poley
Nov 13 '05 #3
Stephen Poley <sb************ ******@xs4all.n l> wrote in
news:7m******** *************** *********@4ax.c om:
I gather from the lack of response that it's not a known Access
problem. But if anyone can think of somewhere I should have looked
that I've not mentioned ...


Have you tried to get a total summary of items/objects/etc used through:

Tools/Analyse/Documentation/All object types/Select all

(or what it would be in the English version).
--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)
Nov 13 '05 #4
Dodo <dodo2u@-takethisNOSPAMo ut-freemail.nl> wrote in
news:Xn******** *************** *******@130.133 .1.4:
Stephen Poley <sb************ ******@xs4all.n l> wrote in
news:7m******** *************** *********@4ax.c om:
I gather from the lack of response that it's not a known Access
problem. But if anyone can think of somewhere I should have looked
that I've not mentioned ...


Have you tried to get a total summary of items/objects/etc used through:

Tools/Analyse/Documentation/All object types/Select all

(or what it would be in the English version).


I just read in a diffferent group:

Tools >> Analyze >> Documenter
--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)
Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
1779
by: Börni | last post by:
Hi, Is there a way to provide a default for a function parameter. i tried function func (type, message, obj = "message") but it doesn't seem to work. It seems a bit ugly to make an if/else statement right at the begining of a function, just to imitate this behavior.
1
4138
by: Steve Edwards | last post by:
I am trying to use an existing report as a subreport in another report. I have the subreport added to the main report, but the only thing that shows up where the subreport should be is the name of the subreport. In reading the Access help files, it sounds like there should be LinkChildFields and LinkMasterFields proprties in the propert sheet for the subreport. However, neither of these properties are there for the subreport.. I used...
2
9194
by: Sami | last post by:
Could someone explain clearly how to go about doing this? I have tried setting up the structure on numerous occasions, but it never seems to work. Could someone please help me out? Thanks!
7
3575
by: Ellen Manning | last post by:
I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user inputs the program desired then only those students in that program are printed. I want the subreports headings to print only for the first student on the page. Is there a way to suppress printing of the headings on subsequent students on that page? I tried the following in both the...
0
1275
by: Helen | last post by:
Here's the code: how do I prevent the parameter prompt from appearing during run time? Thanks Imports CrystalDecisions.CrystalReports.Engin Imports CrystalDecisions.Share Public Class Form Inherits System.Windows.Forms.For #Region " Windows Form Designer generated code
1
1758
by: Fiona | last post by:
Hi, I'm new to the forum and need help in working out why the following does not work. I have created a report with a subreport which are run from two queries respectively. My problem is this. When I use the "Between and " criteria in the subreport query it creates a loop that I can't get out of when i try and open the main report, however if I use "< Now() - 30" it works fine. I am trying to create a report that pulls all clients...
2
1945
by: smowen | last post by:
Hi I have created a report which contains several charts/subreports which are based on parameter queries. Every time I open the report i have to enter the criteria in a prompt box several times (one for every chart/subreport.) Is there a way of only entering the criteria once so all the charts/subreports display the information based on that criteria? Thanks
11
7464
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RowSource of a Master Report is: Me.RowSource = "TableOrQueryName"
4
3016
by: dawanwan | last post by:
I built a database at my job for tracking and reporting debt records. I am very new at using Access and have basically trained myself. Here's my problem: I created a parameter query using a form to prompt for a begin date and an end date.This returns a report with a result set of all records that fall within the dates specified. The report has 3 sub reports as well, which also uses the date criteria from the form. When I enter my begin and...
0
9825
marktang
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9672
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,...
0
10559
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10260
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9388
agi2029
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...
1
7794
isladogs
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...
0
5829
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4460
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
2
4023
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.