[AccessD] Access 2003

Ah yes. Context is everything. :-) 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, May 02, 2011 10:14 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2003

Yea, never mind.  I was in an Excel module, and inserted another module.  Excel knows nothing about database options so...

PBKAC as so often happens.

John W. Colby
www.ColbyConsulting.com

On 5/2/2011 9:59 AM, Heenan, Lambert wrote:
> That's an odd one.
>
> Perhaps if you try changing the Database Sort setting. You get at that from the Access windows, not the IDE window. Got to Tools/Options and select the 'General' tab. There's an option there for 'New database sort order'. Hopefully if you change that to something other than 'General' and then change it back again then that will fix the problem.
>
> Lambert
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Monday, May 02, 2011 9:49 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Access 2003
>
> How do I get the Option Compare Database to be inserted into the modules automatically?  For some reason the new modules are coming up with Option Explicit but *not* Option Compare Database.
>
> Normally it is the other way around.
>
> The Tools / Options / Editor / Require variable declaration checkbox is checked.  I am not seeing anything anywhere that allows me to set the "compare" option.
>
> --
> John W. Colby
> www.ColbyConsulting.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com