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
>
Tidak ada komentar:
Posting Komentar