Using Parameters with Report

  • Thread starter Thread starter Dyane Jacobs
  • Start date Start date
D

Dyane Jacobs

I am building a report in Access 2003 that uses
parameters based on the article "Using parameters with
queries and reports". The example report from the
article runs fine. I cut and pasted the code for the
report and 'dialog' form into my
database/query/report/form. When I run the report, I get
an error with the IsLoaded function highlighted and a
window pops up that says: "Compile error: Sub or Function
not Defined." Any one know why this is appearing and how
can I fix it? My code looks like that in the report.
The database is one of mine not the sample.
 
I suspect there is a module in the sample database that
establishes the function. if so copy the module to your
new database and this may get things working.
Hope this helps.
Fons
 
Dyane said:
I am building a report in Access 2003 that uses
parameters based on the article "Using parameters with
queries and reports". The example report from the
article runs fine. I cut and pasted the code for the
report and 'dialog' form into my
database/query/report/form. When I run the report, I get
an error with the IsLoaded function highlighted and a
window pops up that says: "Compile error: Sub or Function
not Defined." Any one know why this is appearing and how
can I fix it?
Click to expand...


IsLoaded is not a built-in function. It's something you
have to add to your application. Theere's an example of the
common version of the function in the Northwind sample
database that comes with Access. Or you can Google the
newsgroup archives for several ways to write the code.
 
Back
Top