The Statement That You Entered Has A Function Name That Microsoft Access Can't Find

[schulzy175]

I got this to work yesterday. But I have 2 databases. Database9 and Database10. Both are located in Documents. I can run a macro in Database9, but not in Database10. I get this error on Database 10 even if the only string I have is

msgbox "hi"

. I used the most simplest form of code to try and debug this, but I have not found the answer anywhere on google.

[ranman256]

that is a legal command. That means the problem could be:
1. the database size is almost at 2 gig. Strange messages occur at this point.
2. there is a missing reference in VBE that is causing this.
3. the db is corrupt. Did you try compact /repair?

[schulzy175]

I did compact and repair, but still get the message. Now I have imported 2 ODBC connections to Database10. Our main DB and then QODBC. So it may be getting too large. To be more clear with my code, here is exactly what I have.

Function TestFunction()

MsgBox "hi"


End Function

[schulzy175]

Ok, so this doesn't make sense to me, but if I change the function name from

TestFunction()

to

Trun2()

then the code actually runs?! I am confused.

[schulzy175]

I figured it out. My function name was the same as my Macro name so there was a conflict. I appreciate you and anyone else who took the time to help. I am marking this thread as solved.

[ranman256]

hmm, ida never thought of that.
You should be able to have both, neither are called the same way.
Ok, now I have a #4.