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

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