Hi, In the CODE are NO-PROGRAMMERS-ERRORS (my Opinion)
This happens Allways, in 1-2 code-places (most case), sometimes over 10.
After Pseudo-line-edit (Before/After the same)
....it is ALL-OK
And Problem CODE is allways in ANOTHER-Code-Place
BIG-PROBLEM is this wrong-compiler-example
Here is the CORE of CODE....or something else missing ?
*****************************************
http://i34.tinypic.com/71sdq8.jpg ;

I can place the whole code here , but you will see Nothing ....(my Opinion)
There must be Something else WRONG...

"Tony Toews [MVP]" wrote:

PACALA_BA wrote:

After Compile is all OK, NO-Errors (But it is NOT REALLY TRUE !!),

The compile did compile successfully. But you will still get runtime
errors which is what you have.

when executing SQL-string ,
comes an Error: ***Invalid syntax of SQL-String***,
because the Acces-System/Compiler
DO-NOT see the value of one public constant (=NullSting) !!!!,
but in Debugger/Watch IS the value of public constant ANOTHER (="LAB")
After 'PSEUDO-LINE-EDIT' (Value before and after the same) it is OK,
and runs Error-free over night (15 Hours).

Like David said. Post your code. Then we can tell you what the
problem is.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/