Compilation problems

[dogdays]

With no warning of exceeding limits
I ended up with a variable undefined.
the entry is a global string.
I tried moving the variable about
but I do not the order of compilation.

tia Jack

 

[Micron]

Not clear what you're saying - especially the last sentence. You're raising an error message when you try to compile code? Or you're raising an error when you use the db? Something else?
If #1 then could be that
a) a reference to the variable is mis-spelled
b) the variable does not have the proper scope
c) you have Option Explicit at the top of a module but did not declare a variable that you are trying to use in code

 

[dogdays]

With no warning of exceeding limits
I ended up with a variable undefined.
the entry is a global string.
I tried moving the variable about
but I do not the order of compilation.

tia Jack

the line but I do not know the order of compilation. (could be a scope problem) the variable is
Global Const gcstrExcelExportFieldsTableName As String = "tblExcelExportFields"
the variable in question is global

thx for the reply
Jack

 

[Micron]

That looks like a constant being declared, not a variable.
If declared in a procedure, regardless of where its scope is that procedure only. IIRC, you'd raise an error trying to make it public inside of a procedure.
If declared at the top of a form/report module its scope is to any procedure in that form/report only.
If declared Public at the top of a standard module its scope is project wide.

Without seeing your code project I don't know what else to suggest, except maybe to research scope of variables & constants

 

[dogdays]

The problem is at compile time
I changed every instance of global to Public, no joy.
Still get Variable not defined.
What does IIRC stand for?

Jack

 

[Micron]

AFAIK, it means If I Recall Correctly.