COMPILER WRONG !!!

=?Utf-8?B?UEFDQUxBX0JB?= wrote
in :

Hi, In the CODE are NO-PROGRAMMERS-ERRORS (my Opinion)

Well, none of us can say as we don't know what the code says.

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 ;

Again, this image IS COMPLETELY MEANINGLESS. It is not from Access,
it is from some tool that you are using to detect a "problem." The
problem may be with your detection tool, and not with the code, but
we can't say, since you aren't posting the code.

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

Until you post the code, I'm done responding, as there's not a
damned thing I can offer to help unless I see *real* code (not the
pseudo code that you've posted).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

No intention of offending anyone.

Maybe you’re posting to the wrong forum? What CODE? Da Vinci Code? That book
was use to be collecting dust in bookstores back in the early 70s.

PACALA_BA wrote:
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...

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

--
Please Rate the posting if helps you

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1

Hi, today's CRAZY example....
error-code-line: SetOption "Left margin", "0.1"""
************************************
error: 2091 ,'' is an invalid name.
in Immediate window : NONE-ERRORS !!!!!!!
-------------------
After full-database-import
Compact & Repair
open-db (un-compiled, compile-on-demand = false)
error: 2091 ,'' is an invalid name.
error-code-line: SetOption "Left margin", "0.1"""
I DO-NOT UNDERSTAND such errors !!!
------------------
Public Function INI_AC_OPTIONS_PRT_MARGINS()
On Error GoTo XPAC_CHYBA: Dim lc__proc_meno$, lc__proc_ErrUSR$, ln__proc_err&
lc__proc_meno$ = "INI_AC_OPTIONS_PRT_MARGINS"
SetOption "Left margin", "0.1"""
SetOption "Right margin", "0.1"""
SetOption "Top margin", "0.1"""
SetOption "Bottom margin", "0.1"""
xPAC_KONIEC: Exit Function ' DATASHEET
XPAC_CHYBA:
ln__proc_err& = ERROR_SHOW(Err, lc__proc_meno$, lc__proc_ErrUSR$,
lkCurModul_NV)
Select Case ln__proc_err
Case 1: Resume
Case 2: Resume Next
Case Else: GoTo xPAC_KONIEC
End Select
End Function
----------------------------------------------------------------------------------
By this do you mean that you delete the line of code and replace it with
the identical code? ...YES, it seems un-believable, but than O.K.
--------------
After Psuedo-line-edit" this line executes without error? ..YES
--------------
1. If you run this code repeatedly (without any alteration at all) ..NO,
allways
LITTLE changes
--------------
2. If you add a line of code, delete it, recompile and test what
happens ?
3. Have you decompiled your mdb? Here is some information on decompiling
Allways NEW mdb created, than ExportasText/LoadAstext, and build MDE.
tha same errors, Only sometimes on the First TRY it is O.K.
----------------------------------------------------------------------------------


"Clif McIrvin" wrote:

Pacala, did you understand the earlier reference to 'spaghetti
postings'? Your posts tend to be very incomplete fragments, and are
exceedingly difficult for anyone out here to make any sense of.

It would be very helpful if you could avoid the SHOUTING and provide a
beginning - to - end summary in one narrative.

I understand that you are hesitant to post your complete code, as it
sounds as though it is many thousands of lines in length.

Do I understand you to be saying that this code has been running
successfully for some time, and then begins to fail after you attempt a
(minor) modification and re-compile?

After Pseudo-line-edit (Before/After the same)
...it is ALL-OK

By this do you mean that you delete the line of code and replace it with
the identical code? Or do you mean something else? By ALL-OK, are you
saying that you get a run-time error on this line, but after your
"Psuedo-line-edit" this line executes without error? How do you know
this to be the case?

And Problem CODE is always in ANOTHER-Code-Place

Are you telling us that your run-time error doesn't always occur at the
same place?

1. If you run this code repeatedly (without any alteration at all) does
the run-time error stay exactly the same, or does it "move around"?

2. If you add a line of code, delete it, recompile and test what
happens?

3. Have you decompiled your mdb? Here is some information on decompiling
from Tony Toews:
http://www.granite.ab.ca/Access/decompile.htm

--
Clif

"PACALA_BA" wrote in message
...
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/




--
Clif
Still learning Access 2003

Hi, today's CRAZY example....
The WHOLE CODE is this LINE.......
error-code-line: SetOption "Left margin", "0.1"""
************************************
error: 2091 ,'' is an invalid name.
in Immediate window : NONE-ERRORS !!!!!!!
-------------------
After full-database-import
Compact & Repair
open-db (un-compiled, compile-on-demand = false)
error: 2091 ,'' is an invalid name.
error-code-line: SetOption "Left margin", "0.1"""
I DO-NOT UNDERSTAND such errors !!!
------------------
Public Function INI_AC_OPTIONS_PRT_MARGINS()
On Error GoTo XPAC_CHYBA: Dim lc__proc_meno$, lc__proc_ErrUSR$, ln__proc_err&
lc__proc_meno$ = "INI_AC_OPTIONS_PRT_MARGINS"
SetOption "Left margin", "0.1"""
SetOption "Right margin", "0.1"""
SetOption "Top margin", "0.1"""
SetOption "Bottom margin", "0.1"""
xPAC_KONIEC: Exit Function ' DATASHEET
XPAC_CHYBA:
ln__proc_err& = ERROR_SHOW(Err, lc__proc_meno$, lc__proc_ErrUSR$,
lkCurModul_NV)
Select Case ln__proc_err
Case 1: Resume
Case 2: Resume Next
Case Else: GoTo xPAC_KONIEC
End Select
End Function


"David W. Fenton" wrote:

=?Utf-8?B?UEFDQUxBX0JB?= wrote
in :

Hi, In the CODE are NO-PROGRAMMERS-ERRORS (my Opinion)

Well, none of us can say as we don't know what the code says.

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 ;

Again, this image IS COMPLETELY MEANINGLESS. It is not from Access,
it is from some tool that you are using to detect a "problem." The
problem may be with your detection tool, and not with the code, but
we can't say, since you aren't posting the code.

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

Until you post the code, I'm done responding, as there's not a
damned thing I can offer to help unless I see *real* code (not the
pseudo code that you've posted).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Hi, today's CRAZY example....
This CODE-LINE
error-code-line: SetOption "Left margin", "0.1"""
************************************
error: 2091 ,'' is an invalid name.
in Immediate window : NONE-ERRORS !!!!!!!
-------------------
After full-database-import
Compact & Repair
open-db (un-compiled, compile-on-demand = false)
error: 2091 ,'' is an invalid name.
error-code-line: SetOption "Left margin", "0.1"""
I DO-NOT UNDERSTAND such errors !!!


"AccessVandal via AccessMonster.com" wrote:

No intention of offending anyone.

Maybe you’re posting to the wrong forum? What CODE? Da Vinci Code? That book
was use to be collecting dust in bookstores back in the early 70s.

PACALA_BA wrote:
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...

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

--
Please Rate the posting if helps you

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1

=?Utf-8?B?UEFDQUxBX0JB?= wrote
in :

Hi, today's CRAZY example....
The WHOLE CODE is this LINE.......
error-code-line: SetOption "Left margin", "0.1"""

AND THE CODE IS WRONG!!!!!!!!!!!!!!!!!

No wonder you get errors.

The format is
expression.SetOption(OptionName, Setting)
you want
printer.setoption "Left Margin", 0.1

Fix your code!!! STOP blaming the compiler for your stupidity.



--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **

Did Bob's suggestion work? Stop giving us mysterious code to decipher.

PACALA_BA wrote:
Hi, today's CRAZY example....
This CODE-LINE
error-code-line: SetOption "Left margin", "0.1"""
************************************
error: 2091 ,'' is an invalid name.
in Immediate window : NONE-ERRORS !!!!!!!
-------------------
After full-database-import
Compact & Repair
open-db (un-compiled, compile-on-demand = false)
error: 2091 ,'' is an invalid name.
error-code-line: SetOption "Left margin", "0.1"""
I DO-NOT UNDERSTAND such errors !!!

No intention of offending anyone.

[quoted text clipped - 15 lines]

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

--
Please Rate the posting if helps you

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200810/1

Bob Quintal wrote in
:

=?Utf-8?B?UEFDQUxBX0JB?= wrote
in :

Hi, today's CRAZY example....
The WHOLE CODE is this LINE.......
error-code-line: SetOption "Left margin", "0.1"""

AND THE CODE IS WRONG!!!!!!!!!!!!!!!!!

No wonder you get errors.

The format is
expression.SetOption(OptionName, Setting)
you want
printer.setoption "Left Margin", 0.1

Fix your code!!! STOP blaming the compiler for your stupidity.

And this is why we needed to see the code.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Hi, the same command
SetOption "Left margin", "0.1"""
while running..error, empty argument...WHY ?
in Immediate window(while code running) the same OK !!!!
and the same code-line in another databse build...OK !!!!, WHY ???

I do not have time for stupid Questions,
My MDB ( ~5MB, of text code, i wrote for 5 years, it was running
in Access 2000 wounderful, but now is there something WRONG, and it is really
ANNOYING such CRAZY errors !!!

"Bob Quintal" wrote:

=?Utf-8?B?UEFDQUxBX0JB?= wrote
in :

Hi, today's CRAZY example....
The WHOLE CODE is this LINE.......
error-code-line: SetOption "Left margin", "0.1"""

AND THE CODE IS WRONG!!!!!!!!!!!!!!!!!

No wonder you get errors.

The format is
expression.SetOption(OptionName, Setting)
you want
printer.setoption "Left Margin", 0.1

Fix your code!!! STOP blaming the compiler for your stupidity.



--
Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **

OK, i can try it with printer

but the question is a have 10 another databases,
with this CRAZY-line , and it is O.K. WHY ????

this was an Error in ONLY ONE (WRONG) Database.
I does not have changed this line of code !!!!!
Todays build is O.K., Why ??????????

Hi, the same command
SetOption "Left margin", "0.1"""
while running..error, empty argument...WHY ?
in Immediate window(while code running) the same OK !!!!
and the same code-line in another databse build...OK !!!!, WHY ???

I do not have time for stupid Questions,
My MDB ( ~5MB, of text code, i wrote for 5 years, it was running
in Access 2000 wounderful, but now is there something WRONG, and it is really
ANNOYING such CRAZY errors !!!


"David W. Fenton" wrote:

Bob Quintal wrote in
:

=?Utf-8?B?UEFDQUxBX0JB?= wrote
in :

Hi, today's CRAZY example....
The WHOLE CODE is this LINE.......
error-code-line: SetOption "Left margin", "0.1"""

AND THE CODE IS WRONG!!!!!!!!!!!!!!!!!

No wonder you get errors.

The format is
expression.SetOption(OptionName, Setting)
you want
printer.setoption "Left Margin", 0.1

Fix your code!!! STOP blaming the compiler for your stupidity.

And this is why we needed to see the code.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/