Report (1 Viewer)

[msouriya]

Hi all! So I have this report which I've set parameters on and been using this report for years, but now it's not working. I'm not sure is it because I've created a new database and copied the report from the old DB to the new DB and perhaps that's there's a problem? The prompt said this: Compile error: Sub or Function not defined
Please help! Thanks in advance!

 

[plog]

Sounds like you are missing a module that the query/report uses. Copy the module that sub/function is in to the new database file as well.

 

[msouriya]

Yes, I've already copied and pasted the code, but still gives me the same message.

 

[plog]

Can you upload your database?

 

[msouriya]

Yes. I've just been entering false data, so there are no real student records entered. Please click on the Services Report Form Button on the Switchboard and you will see the error. When I try to upload the DB, this is what that came up: Your file of 5.39 MB bytes exceeds the forum's limit of 2.00 MB for this filetype

 

[plog]

Delete all unncessary objects, then compact and repair and see how large it is.

 

[msouriya]

Hi! Attached is a copy of DB with no real student records. Thanks!

 

[plog]

I clicked on the Services Report Form, it prompted me 3 times to enter data, I did and then the report opened. I can't reproduce your issue.

Go Shockers.

 

[plog]

Just saved it locally and got the error.

You have a custom function called MyIsNull() running when that report is opened. The database you have cannot find that function. Where is it?

There are no modules in that database. Thinking my initial answer was correct.

 

[msouriya]

So the error does not come up as Compile error: Sub or Function not defined? Also, when you clicked on it, did the form actually pop up? Also, I don't understand what do you mean by you can reproduce my issues?

 

[msouriya]

Where can I find the module?

 

[plog]

Disregard post #8, I was able to reproduce it.

I got the error and the error has to do with a function that doesn't exist in that database---MyIsNull(). It's in a module in the original database that you didn't copy over to this new one.

 

[msouriya]

Yay!!! I got it, thanks so much!!! Sometimes it takes someone else to ask the obvious question other than myself!!! I've been trying to figure this out for about 2 days!