Results 1 to 5 of 5
  1. #1
    MarkA70 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    6

    Question Access 2010: Option Explicit Statement


    Where do I set the Option Explicit setting for Access 2010?

  2. #2
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    In the VBE, click on Tools--->Options and make sure the Require Variable Declaration check box is checked.

  3. #3
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    alternatively at the top of each module just below 'Option Compare Database'

  4. #4
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397

  5. #5
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Please review this link on why crossposting is frowned upon.

    http://www.excelguru.ca/content.php?184

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

Similar Threads

  1. Option Explicit default
    By Glenn_Suggs in forum Access
    Replies: 4
    Last Post: 02-14-2014, 12:41 PM
  2. option explicit issue acc2003 to acc2010
    By trevor40 in forum Programming
    Replies: 6
    Last Post: 02-14-2014, 12:04 PM
  3. Access 2010 package solution upgrade option
    By snoopy2003 in forum Programming
    Replies: 5
    Last Post: 05-17-2011, 09:23 AM
  4. Implicit / explicit relationships in Access
    By starson79 in forum Access
    Replies: 4
    Last Post: 01-26-2011, 08:50 AM
  5. If Statement or better option
    By chrisjack001 in forum Access
    Replies: 3
    Last Post: 08-20-2010, 04:24 PM

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