[AccessD] References-Converted to 2k code stops on Usysreferencescheck module

Hi Gustav

I'll give this a try tomorrow (or at the latest Monday)...but we're out
camping right now and I'm toooooo tired to think very hard tonight.

Thanks for the tip & code, I do appreciate your help!

I'll let you know the results as soon as I get them tested.

Greg



> Hi Greg et all
>
> Create this tiny function for closing the VBE window:
>
> <code>
>
> Public Function VbeMainWindowClose()
>
>   Application.VBE.MainWindow.Visible = False
>
> End Function
>
> </code>
>
> Then adjust the AutoExec macro like this:
>
> <macro>
>
>   OpenModule
>     UsysReferencesCheck
>
>   RunCode
>     VbeMainWindowClose()
>
>   RunCommand
>     CompileAndSaveAllModules
>
> </macro>
>
> Please let me know if this works for you.
>
> /gustav
>
>
>> Date: 2004-08-20 18:30
>
>> Hi everyone!  Happy FRIDAY!
>
>> I'm using Gustav's code to check references in Access 97, and, it
>> works great in A97.  I'm using the code that runs via the autoexec
>> from his article in the Archives.  After converting to A2k (on the way
>> to XP/2003), the program dies during the execution of the autoexec
>> when it hits the code:
>
>>      DoCmd.OpenModule "Usysreferencescheck", ""
>
>> where Usysreferencescheck is an empty module.  Apparently A2k doesn't
>> like this.  There is no error or message, it just brings up the visual
>> basic editor and quits.
>
>> Or am I missing something else?
>
>> TIA!
>
>> Greg Smith
>> gregsmith at starband.net