|
Home > Archive > MS Access database support > August 2005 > Weird parameter prompt appearing after creating a subreport
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Weird parameter prompt appearing after creating a subreport
|
|
| Stephen Poley 2005-08-26, 11:24 am |
| 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
"Applicaties". 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
| |
|
| Stephen Poley < sbpoleySpicedHamTrap
@xs4all.nl> wrote in
news:eq9ug11nvsra5ib
q811k5ec8h1egq1rn40@
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
> "Applicaties". It makes no apparent use of any value entered.
>
You must have used somewhere a reference to an object named "Applicaties"
without being recognized. You either have used a wrong syntax or the object
doesn't exist.
As you said you have a table named "Applicaties", 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)
| |
| Stephen Poley 2005-08-29, 1:25 pm |
| On 26 Aug 2005 15:34:13 GMT, Dodo
<dodo2u@-takethisNOSPAMout-freemail.nl> wrote:
>Stephen Poley < sbpoleySpicedHamTrap
@xs4all.nl> wrote in
> news:eq9ug11nvsra5ib
q811k5ec8h1egq1rn40@
4ax.com:
>
>
>You must have used somewhere a reference to an object named "Applicaties"
>without being recognized. You either have used a wrong syntax or the object
>doesn't exist.
>As you said you have a table named "Applicaties", 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.AKey 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
| |
|
| Stephen Poley < sbpoleySpicedHamTrap
@xs4all.nl> wrote in
news:7mh6h1dai9crfsi
k5dbmj7v2k4dn83e722@
4ax.com:
> 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)
| |
|
| Dodo <dodo2u@-takethisNOSPAMout-freemail.nl> wrote in
news:Xns96C1DAA25DC0
2dodo2ufreemailnl@13
0.133.1.4:
> Stephen Poley < sbpoleySpicedHamTrap
@xs4all.nl> wrote in
> news:7mh6h1dai9crfsi
k5dbmj7v2k4dn83e722@
4ax.com:
>
>
> 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)
|
|
|
|
|