[...] event propety setting produced error Sub or Funcion not defined

After adapting a piece of code to convert number to "spelled" text and after a few runs the mentioned error

"[...] event propety setting produced error Sub or Funcion not defined"

started to occur at ALL events. I have completly rebuild the database and can't find any reason.
It now occurs for all events even if they won't call any funcion!

I am sending in a clean database, with just this code (for F07... on [T07_MontantePagar]

can anyone help?

formulariosFEDON-11.accdb
João serras-pereiraAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
In the screen shot above.
strWrt(100) s/b strWrdt(100)   ' the 'd' was missing

Similar for the last line  'd' was missing.

Neither of those lines compiled.

mx
0
 
Surone1Commented:
have you tried Debug>compile in the vba editor?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
It appears you had typos on the two lines shown, as  these are where the compile errors are.

mx
Capture1.gif
0
 
João serras-pereiraAuthor Commented:
Hi Databasemx,

your solition worked perfectly. But I can't find what was wrong. can you please tell me?
0
 
João serras-pereiraAuthor Commented:
Thanks! What I was missing is that there was no compiler mesag at ALL!!!!
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
That's probably because Option Explicit is not in the Declarations section of that Module.  It should *always* be there.

You can force to automatically be added when creating a new Form or regular Module - see 2nd image >> Tools>>Options

mx
Capture1.gif
Capture1.gif
0
 
João serras-pereiraAuthor Commented:
Great many thanks for all! It costed me a day of work and a real pain as I was scratcthing may head all over!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.