Connie-
Yes. You can make it automatic by going to the VB Editor and choosing Options
from the Tools menu. In General, make sure that "Require Variable Declaration"
is checked. That will get you an automatic Option Compare Database and Option
Explicit in every new module.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
Sent: Wednesday, August 08, 2012 6:41 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Option Compare Database
John - So you would recommend adding "Option Compare Database" to each module?
That's not the default in vb?
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Connie-
>
> Option Compare Database sets your code to use non-case sensitive compares for
> text (string). "A" = "a"
>
> That's what the query engine uses, and it's good to use that unless you need a
> case-sensitive compare. You can use the StrComp function to override the
> default compare.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mrsgoudge
> Sent: Wednesday, August 08, 2012 5:30 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Option Compare Database
>
> Hi all,
>
> Midway through creating the database I made Option Explicit the default. So I
> was going to go back and add it too the initial modules. I've noticed that
some
> modules have both Option Compare Database and Option Explicit.
>
> What does Option Compare Database mean? What determines if it should be used?
> Seems like some are recommending using it all the time. If so, should I go
back
> and add it?
>
> Thanks!
> Connie
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar