Re: Error Message when running report

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: OutputTo to Excel question
    ... I can't help you with the macro error message as I don't use macros. ... the result from a query. ... Save a query that pulls the same data as the report. ...
    (microsoft.public.access.macros)
  • Re: Error Message when running report
    ... did you Compile your code? ... did you change the ControlSource and Name properties on the report to match the columnname in your query? ... You either have a bad reference in your code, a calculated field in the ...
    (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: Related question
    ... How can I display the query ... source for bot the chart and the report needs to reference the same ... Make sure the controls are formatted correctlym I generally am using ... another error message pops up regarding the size of the data. ...
    (microsoft.public.access.reports)
  • Re: 07 prompts for table field
    ... Still in the code window, choose Compile from the Debug menu. ... Given that the report was generated via Report Wizard and that field is not ... Presumably you have already tried running the source query directly to ...
    (microsoft.public.access.reports)