David.
>>I'm sorry, but this is pure gibberish to me. I haven't a clue what you're talking about.<<
Your title on UA is ‘Utterly Banned’ and we currently share that title.
It doesn’t concern me all that much but you may be interested to know that
this link was got directly from Google. There was no need to go to UA and log in, so your customers may see it and I can’t think it doing you or your company any good. Also, you may want to consider that this post might also end up on Google and that is the reason for me not stating it clearly in the first place.
So ‘gibberish’ has its place but, of course, that is entirely up to you to call it what you will.
And so, back to business…
------------------------------
Luke Chung
President of FMS, Inc.
No date available.
>>By default, Access/Office ships with this option turned off, so be sure to turn it on.<<
http://www.fmsinc.com/freE/NewTips/VBA/Option/index.html
That was still his opinion a few weeks ago at Dev Con in Brisbane.
His argument was that it is done to reduce calls to Microsoft.
My argument was that it is done to help make it work in VBA.
On considering both arguments carefully I should have said it would amount to the same thing.
(Luke’s was an aim, mine was a method.)
------------------------------
Kathleen McGrath
Microsoft Corporation
June 2003
>>Declaring Variables. In VBA, you can use the Option Explicit statement to enforce explicit variable declaration. You can also set this automatically by selecting the Require Variable Declaration check box in the VBA IDE options, which by default is not selected. All implicitly declared variables are of Variant type.<<
http://msdn.microsoft.com/en-us/library/aa192490(office.11).aspx
------------------------------
So what I would prefer is not some typed statement of fact but a link to one or many sites that state the Option Explicit default in VBA. (Please note VBA not VB)
As to your statement: -
>>And those other apps are not directly relevant to discusions on this site, because this is an Access site.<<
This site may be predominately an Access site but it is not restricted to Access.
It is still my contention that VBA is different from other languages.
It is different in that it is required to work in many different applications.
It is different in that it is required to work for people, not just programmers.
It is different in that it is required to be ‘syntax tolerant’.
It is different in that it is required to work…most of the time.
Regards,
Chris.