[AccessD] Startup form

Bill Benson bensonforums at gmail.com
Wed Jul 28 13:42:53 CDT 2021


I do it just the opposite, I use a startup form in the File Options, and
the code in the Startup form (which I want open and invisible until the
program quits) to call all my routines in its open event. That way I can
run those again in the immediate window just by the line DoCmd.openForm
"MyStartupForm"

On Wed, Jul 28, 2021 at 1:24 AM Stuart McLachlan via AccessD <
accessd at databaseadvisors.com> wrote:

> Create a function in a normal module and call it Startuip()
> Create a Macro with one operation; RunCode
> Enter Startup() in the "Function Name" prompt.
>
> FWIW, that's the only Macro I ever use
>
> --
> Stuart
>
> On 27 Jul 2021 at 20:06, Arthur Fuller wrote:
>
> > I am new to macros. How do you call your Starup function?
> >
> > On Tue., Jul. 27, 2021, 7:46 p.m. Arthur Fuller,
> > <fuller.artful at gmail.com> wrote:
> >
> > > Thank you all
> > >
> > > On Tue., Jul. 27, 2021, 7:41 p.m. Stuart McLachlan via AccessD, <
> > > accessd at databaseadvisors.com> wrote:
> > >
> > >> My preferred method is an Autoexec macro which calls a Startup()
> > >> function.
> > >>
> > >> The Startup() functon can do all sorts of initialisation including
> > >> a Docmd.OpenForm.
> > >>
> > >> --
> > >> Stuart
> > >>
> > >> On 27 Jul 2021 at 9:08, Jim Dettman via AccessD wrote:
> > >>
> > >> >
> > >> >  Other way to do it is with an AutoExec macro and open the form
> > >> >  from
> > >> there.
> > >> >
> > >> > Jim.
> > >> >
> > >> > -----Original Message-----
> > >> > From: AccessD On Behalf Of Arthur Fuller
> > >> > Sent: Tuesday, July 27, 2021 8:13 AM
> > >> > To: Access Developers discussion and problem solving
> > >> > <accessd at databaseadvisors.com>
> > >> > Subject: [AccessD] Startup form
> > >> >
> > >> > I forget how to set a form to open on startup when the user opens
> > >> > my
> > >> app.
> > >> > Idea?
> > >> > --
> > >> > AccessD mailing list
> > >> > AccessD at databaseadvisors.com
> > >> > https://databaseadvisors.com/mailman/listinfo/accessd
> > >> > Website: http://www.databaseadvisors.com
> > >> >
> > >> > --
> > >> > AccessD mailing list
> > >> > AccessD at databaseadvisors.com
> > >> > https://databaseadvisors.com/mailman/listinfo/accessd
> > >> > Website: http://www.databaseadvisors.com
> > >> >
> > >>
> > >>
> > >> --
> > >> AccessD mailing list
> > >> AccessD at databaseadvisors.com
> > >> https://databaseadvisors.com/mailman/listinfo/accessd
> > >> Website: http://www.databaseadvisors.com
> > >>
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list