[AccessD] Access 2003

jwcolby jwcolby at colbyconsulting.com
Mon May 2 10:15:37 CDT 2011


LOL, yep.  I was looking at code in Excel and simultaneously copying pieces into Access.  I got 
confused where I was inserting the module and inserted it into Excel when I intended to insert it 
into Access.

John W. Colby
www.ColbyConsulting.com

On 5/2/2011 10:28 AM, Heenan, Lambert wrote:
> 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
>



More information about the AccessD mailing list