Re: Error Message when running report

Hi Jennifer,

did you Compile your code?

did you change the ControlSource and Name properties on the report (in design view) to match the columnname in your query?

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Jennifer Nadey wrote:
Sorry there was a typo in my re-typing of the error message. The error
message did say <<Expr>>.

I changed the name of the field I added and tried to rerun the report but
got the same error. The query runs and provides the correct data with no
error.

Thanks!
Jennifer


"strive4peace" <strive4peace2006@xxxxxxxxx> wrote in message
news:%23MEJ4oJyGHA.3440@xxxxxxxxxxxxxxxxxxxxxxx
Hi Jennifer,

Expr1 is what Access will assign for the first calculated field in a
recordset... I suspect that

Ex[r

needs to change to Expr

You either have a bad reference in your code, a calculated field in the
report, or the query that the report is based on.

I would check the query first -- look at the calculated fields. You
can, by the way, change Expr1 to be something more logical... anything
before the colon in a query will be the fieldname that the report uses.
Avoid spaces and special characters (except underscore) in names.

To check your code:

go to the design view of any module:

'~~~~~~~~~ Compile ~~~~~~~~~

Whenever you change code or references, your should always compile
before executing.

from the menu in a module window: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)

'~~~~

if you didn't find it yet, we can give you more things to check

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*



Jennifer Nadey wrote:
I have a report, which runs off a query, which runs off a table. I
added a
column of data to the table and then that column to the query. I went
into
the report via Design View and added a text box to display the value of
the
new column. When I try to run the report, I get the following error
message:

"The expression On Format you entered as the event property setting
produced
the following error: The object doesn't contain the Automation object
'<<Ex[r>>.'.
* The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event, or macro."

Any thoughts on how I can fix this error?

Thanks,
Jennifer






.

Relevant Pages

  • Re: Error Message when running report
    ... Sorry there was a typo in my re-typing of the error message. ... The query runs and provides the correct data with no ... report, or the query that the report is based on. ... Whenever you change code or references, your should always compile ...
    (microsoft.public.access.reports)
  • Re: String Used in Report Displays as Garbage
    ... All the text in the calculated fields in my query are left aligned. ... I tried creating a new report with only the calculated field printed. ... You say the calculation looks fine in the query. ...
    (microsoft.public.access.reports)
  • Re: Error Message when running report
    ... You either have a bad reference in your code, a calculated field in the report, or the query that the report is based on. ... Whenever you change code or references, your should always compile before executing. ...
    (microsoft.public.access.reports)
  • Re: Error Message when running report
    ... you're welcome, Jennifer;) happy to help ... This time the report was able to run! ... did you Compile your code? ... You either have a bad reference in your code, a calculated field in the ...
    (microsoft.public.access.reports)
  • Re: Nz in report section heading
    ... even better on my existing query because I already ... another calculated field into the query which feels a little better. ... In your query behind the report, ... control's control source is a field in that query. ...
    (microsoft.public.access.reports)