Access 2010: Setting 'Option Explict'

M

MarkA70

Registered User.
Local time
Today, 02:13
Joined
Jan 30, 2016
Messages
43
Where do I set the Option Explicit setting for Access 2010?
 
on the top of a module:

Option Compare Database
Option Explicit
Option Base 0
 
@MarkA70

This post is double posted here

http://www.accessforums.net/showthread.php?t=58113&p=310898#post310898

A quick review shows you have previously double posted here
http://www.access-programmers.co.uk/forums/showthread.php?t=284593
http://www.accessforums.net/showthread.php?t=58100&p=310854#post310854
and were advised of the proper etiquette

here
http://www.accessforums.net/showthread.php?t=58063&p=310661#post310661
http://www.access-programmers.co.uk/forums/showthread.php?t=284545
and also were advised of the proper etiquette

again here
http://www.access-programmers.co.uk/forums/showthread.php?t=284526
http://www.accessforums.net/showthread.php?t=58045&p=310585#post310585

and here
http://www.accessforums.net/showthread.php?t=58001&p=310360#post310360
http://www.access-programmers.co.uk/forums/showthread.php?p=1473867#post1473867

I leave it to others to decide whether they feel their time is being wasted
 
I am sorry about the double posts, I did not have any idea the forums were connected. Not sure exactly how I would have known that they were. Will note this in the future.
 
they are not connected and it is not a matter of knowing whether they are or not. Per the link provided, it is a matter of consideration for the people who freely give their time to help.

If you were paying people, it wouldn't matter, pay 10 people for the same advice if you wish. But most people who regularly respond to questions are on these and other forums and provide their own time for free - as you are for your church
 
MarkA70, with all due respect, it's not a question of the forums being connected, it's a question of whose time you value. If you ask the same question on four forums and four people answer, three people's time is wasted. That suggests you think your time is worth more than mine, and if I knew that I wouldn't help you for free.
 
i think there is no waste of time here, the op i think need second opinion. think of it as going to a clinic and to another. does the attendant informed you that you have gone to the first clinic and need not go to this clinic?
 
Sorry, doctors work for free at which clinic? And personal health is like declaring variables? :rolleyes:
 
Hmm, did you want it to automatically appear at the top of each Module so you don't have to keep typing it in? You can do this by going to the VB Editor and selecting Tools > Options and check Require Variable Declaration.
 
@gina - as suggested in the duplicate thread
 
i think we all come here to share our knowledge. its our own willingness to share that brought us here. if somebody personally comes to you and seek advice you will surely take patience on him. if again, he comes, will you turn him down, since you already adviced him. if he seek advice on another person, will that person turn him down also because he already went to you?

i was always told that the best way to understand a book is read them, when you don't understand read it again, and again and again. until you truely grasp what's it tries to say.


same situation with op's they need concrete understanding.
 
@arnlegp

I accept that in this instance there is little waste of time, but in earlier posts this is not the case. The OP has acknowledged the issue and made the point, quite rightly, that as a newbie - how would he know? It is an easy habit to fall into and he had been advised previously of the issues - that was my point. It is not a case of double posting should not be done, just that when done, providing links to other threads where the same question has been asked
 
You must log in or register to reply here.

Similar threads

V
Run-time Error 91 variable not set (class Modules)
Replies
9
Views
887
VSolano
V
Gasman
Solved Option Explicit?
2
Replies
32
Views
1,805
BlueSpruce
BlueSpruce
P
No Options in File - Access Runtime 2021
Replies
10
Views
1,067
Pat Hartman
P
N
Solved How to scan a barcode from a parent form and update the child/subform in MS access
Replies
4
Views
453
Uncle Gizmo
Uncle Gizmo
amorosik
Variable defined as Public on a standard module, is not recognized
Replies
18
Views
974
amorosik
amorosik

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom