Function name error message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several reports in a database: some are run directly from queries,
others use forms to select the criteria. All of my reports work and return
all selected data. Here's the dilemma: Everytime I run the report, it gives
the message "The expression you entered has a function that Microsoft Access
can't find." We have just been selecting OK and moving on; however, it is a
bit of a nuisance. Anyone know why that message would appear, but calculate
all functions and return all required data?

Thanks!
 
I think you have a "function that Microsoft Access can't find" some place in
a control source or in your query. I could be wrong.
 
I figured that much; however, I have opened each and every control source and
query. I have gone through and run every query from the actual query and
every calculation and formulation is completed. It's a mystery!
 
If the record source opens without an error then the problem has to be in
the report. You could either recreate the report or use the documenter to
analyze all of the report properties including the code. Export the
documenter report to Word and then search for the function that can't be
found. If the error message doesn't provide the function name then you may
need to create the new report.

Have you compiled your code?
 
Okay, so how do I use the documenter?

Duane Hookom said:
If the record source opens without an error then the problem has to be in
the report. You could either recreate the report or use the documenter to
analyze all of the report properties including the code. Export the
documenter report to Word and then search for the function that can't be
found. If the error message doesn't provide the function name then you may
need to create the new report.

Have you compiled your code?
Click to expand...
 
Back
Top