[AccessD] Option Explicit

David McAfee davidmcafee at gmail.com
Fri Sep 10 13:00:00 CDT 2010


Awesome, thanks!

I was looking all through the Access options (Doh!)

On Fri, Sep 10, 2010 at 10:55 AM, Gary Kjos <garykjos at gmail.com> wrote:
> Go into the VB Editor and select Options from the Tools menu.
>
> Ensure that the second check box ("Require Variable Declaration") on the
> first tab ("Editor") is checked.
>
> This will only change NEW modules created from that point onward.
>
> GK
>
> On Fri, Sep 10, 2010 at 12:29 PM, David McAfee <davidmcafee at gmail.com> wrote:
>> In Access 2007, when I create a new form and go to the VBA window, I
>> only see Option Compare Database.
>> Option Explicit is missing, so I have to manually add it.
>>
>> Is there a setting that I can change somewhere to have that listed in
>> all modules?
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
>
>
> --
> Gary Kjos
> garykjos at gmail.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list