Autoexecute VBA

[Martin]

For grins, I ran the Analyzer tool on an Autoexec Macro that runs a VB
function. It suggested I convert it to VBA. The converter created a
function called Autoexec_Autoexec.

Is this the standard name for a VB function that will execute each time the
database opens? Does this function need to be in a module with a specific
name as well? I can't find anything in VBA Help that defines this.

Thanks.

 

[Douglas J. Steele]

There's no way to have Access automatically run a function or sub when the
database opens.

Your only options are to specify a specific form to open (which can run the
function in its Open event), or to use an AutoExec macro that calls your
function (macros cannot call subs)