Where do I set the Option Explicit setting for Access 2010?
Where do I set the Option Explicit setting for Access 2010?
In the VBE, click on Tools--->Options and make sure the Require Variable Declaration check box is checked.
alternatively at the top of each module just below 'Option Compare Database'
@MarkA70
This post is double posted here
http://www.access-programmers.co.uk/...d.php?t=284608
A quick review shows you have previously double posted here
http://www.access-programmers.co.uk/...d.php?t=284593
https://www.accessforums.net/showthr...854#post310854
and were advised of the proper etiquette
here
https://www.accessforums.net/showthr...661#post310661
http://www.access-programmers.co.uk/...d.php?t=284545
and also were advised of the proper etiquette
again here
http://www.access-programmers.co.uk/...d.php?t=284526
https://www.accessforums.net/showthr...585#post310585
and here
https://www.accessforums.net/showthr...360#post310360
http://www.access-programmers.co.uk/...67#post1473867
I leave it to others to decide whether they feel their time is being wasted
Please review this link on why crossposting is frowned upon.
http://www.excelguru.ca/content.php?184