Jet Database does not recognize 'Forms............................

[Guest]

Hi

I have a REPORT created from a query statement that produces two CHARTS. The
underlying query has a maximum of 120 fields of data (10x12 matrix).

The REPORT worked beautifully when I created it. I have tried to convert it
to a more flexible report using a forms input.

The 3 underlying queries for the report work fine from the form I created.
However the Report will nolonger produce the Charts and I get the error
message "Jet Database does not recognize
'FORMS..............................................etc

The REPORT does not have any direct reference to the FORMS call as these are
done via the query. To debug the problem I have changed the queries call back
to the base version - that previously worked. The queiries work fine, BUT the
report still does now work and continues to give me the error message above.

The computer has plenty of capacity, the query isn't very large.

Please any ideas?

This is driving me crazy!!!!!!!!!

Regards
Peter

 

[Duane Hookom]

I expect you have a crosstab query someplace (probably a graph row source).
You must specify the data type of all parameters in crosstab queries.

 

[Guest]

Hi Duane

Thanks for your response.

Sorry, no these are just simple queries.

Query 1 - Is a lookup query takes an input from Form -

[Forms]![Input Item Class]![List13]

Results is one Record.

Query 2 - Links with Lookup and Reduces Data to those items

Common to Lookup - up to say 12,000 records.

Query 3 - Uses Query 2 Results and creates a summary - no more than 12
records.

REPORT

Calls the Result of the Lookup Table as a label for the Report.

Creates 2 Charts using results of Query 3.

Query's all work and link correctly, just won't print the chart.

Regards
Peter

 

[Duane Hookom]

What are the SQL views of the Row Sources of the charts?

--
Duane Hookom
MS Access MVP

Hi Duane

Thanks for your response.

Sorry, no these are just simple queries.

Query 1 - Is a lookup query takes an input from Form -

[Forms]![Input Item Class]![List13]

Results is one Record.

Query 2 - Links with Lookup and Reduces Data to those items

Common to Lookup - up to say 12,000 records.

Query 3 - Uses Query 2 Results and creates a summary - no more than 12
records.

REPORT

Calls the Result of the Lookup Table as a label for the Report.

Creates 2 Charts using results of Query 3.

Query's all work and link correctly, just won't print the chart.

Regards
Peter

I expect you have a crosstab query someplace (probably a graph row
source).
You must specify the data type of all parameters in crosstab queries.

 

[david epsom dot com dot au]

Forms and Reports have to be already open
(and in the Forms or Reports collection)
before they are called by a query.

Access can recognize Forms! and Reports!
Jet can not. References to the Application
Forms and Reports collections have to be
translated by Access before the query is
handed off to Jet.

You can put this stuff in a Report RecordSource,
but not in a query called through CodeDB or
CurrentDB.

(david)

 

[Guest]

Duane and David

Thanks for your support. I have manually worked around the problem just to
get my boss his reports - so I don't have the SQL code available.

I am determined to get this to work though - for my own piece of mind!

I am about to do some brushing up on setting the parameters as I think that
is where I am falling down. Also, I have a table and a column with the same
name. Could this cause confusion with the program?

Thanks again
Peter