Results 1 to 3 of 3
  1. #1
    ksor's Avatar
    ksor is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    Feb 2017
    Posts
    126

    Automatic Option Explicit ??


    Where do I have the checkmark for AUTOMATIC inserting that 'Option Explicit' in a Access 2007 ?

  2. #2
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Open the vb editor (alt+f11)
    Don't have access right now; think it is tools>options. Look for "Always require variable declaration".
    P.S. LOVE the mature Alfred E. Nueman!!
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    ksor's Avatar
    ksor is offline Competent Performer
    Windows 10 Access 2007
    Join Date
    Feb 2017
    Posts
    126
    Quote Originally Posted by Micron View Post
    Open the vb editor (alt+f11)
    Don't have access right now; think it is tools>options. Look for "Always require variable declaration".
    P.S. LOVE the mature Alfred E. Nueman!!
    Ooooooooooh, I've have missed that for a long time end then it's so simple - thx a lot !

    Alfred E. Nueman, yeah, it comes to all of us some day ... the hair, the teeth and more ... they all falls ;-))

    Thx again !

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access 2010: Option Explicit Statement
    By MarkA70 in forum Access
    Replies: 4
    Last Post: 02-15-2016, 07:43 AM
  2. Option Explicit default
    By Glenn_Suggs in forum Access
    Replies: 4
    Last Post: 02-14-2014, 12:41 PM
  3. option explicit issue acc2003 to acc2010
    By trevor40 in forum Programming
    Replies: 6
    Last Post: 02-14-2014, 12:04 PM
  4. Implicit / explicit relationships in Access
    By starson79 in forum Access
    Replies: 4
    Last Post: 01-26-2011, 08:50 AM
  5. no option to import xls file or option all files
    By captgnvr in forum Import/Export Data
    Replies: 3
    Last Post: 09-22-2009, 10:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums