Error Message when running report
in [Reports]
|
From: Jennifer Nadey on 25 Aug 2006 17:42 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
From: strive4peace on 25 Aug 2006 19:00 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 > > > >
From: strive4peace on 25 Aug 2006 19:00 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 > > > >
From: Jennifer Nadey on 28 Aug 2006 10:57 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(a)yahoo.com> wrote in message news:%23MEJ4oJyGHA.3440(a)TK2MSFTNGP06.phx.gbl... > 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 > > > > > > > >
From: strive4peace on 28 Aug 2006 13:32
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(a)yahoo.com> wrote in message > news:%23MEJ4oJyGHA.3440(a)TK2MSFTNGP06.phx.gbl... >> 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 >>> >>> >>> >>> > > |