Access Startup properties

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill - 05 Apr 2005 06:30 GMT

I have an application that makes extensive use of the
"Switchboard" (nested). As such, the "Startup" properties
specifies the Switchboard as the initial form. What
I'd like to do is startup a general module that loads
the application installation properties and sets global variables
and then starts the Switchboard via DoCmd.OpenForm.

How do I give initial control to a general module?

Or, do I build a "once function" and put it in the OnOpen
of the switchboard's code sheet?

Thanks,
Bill

Reply to this Message

Andreas - 05 Apr 2005 07:30 GMT

You could:
- Use a macro called Autoexec, which will automatically execute when the
database starts, use it to run your code and the load the Switchbord.
- Use the Open event of the form to run your code (as stated below).

Regards,
Andreas

> I have an application that makes extensive use of the
> "Switchboard" (nested). As such, the "Startup" properties
[quoted text clipped - 10 lines]
> Thanks,
> Bill

Reply to this Message

Bill - 05 Apr 2005 16:28 GMT

Autoexec macro will work just fine. (Who says DOS
is dead... hahaha)
Thank you,
Bill

> You could:
> - Use a macro called Autoexec, which will automatically execute when the
[quoted text clipped - 18 lines]
>> Thanks,
>> Bill

Reply to this Message