Question: How to launch a Module of code on startup

[N. Graves]

Thanks for taking the time to read my question and hopefully it will
be understandable.

I have a need to read a record in a table and place the information in
public variables that can be used in several forms and reports. Is
this an easy process and how would I do this.

I know how to read the data and place them in the variables but I
can't figure out how to automate this at startup.

Please help me

N. Graves

[Jim Allensworth]

On Fri, 02 Jul 2004 13:59:19 -0400, N. Graves
<ng*****@REMOVEyahoo.com> wrote:

Thanks for taking the time to read my question and hopefully it will
be understandable.

I have a need to read a record in a table and place the information in
public variables that can be used in several forms and reports. Is
this an easy process and how would I do this.

I know how to read the data and place them in the variables but I
can't figure out how to automate this at startup.

Please help me

N. Graves

Use the Open event of a startup form to set the variables.

Note that if you have a runtime error, your variables will be wiped
out. An alternative might be to use invisible text boxes on an always
open form to hold the values.

- Jim

[rkc]

"N. Graves" <ng*****@REMOVEyahoo.com> wrote in message
news:ua********************************@4ax.com...

Thanks for taking the time to read my question and hopefully it will
be understandable.

I have a need to read a record in a table and place the information in
public variables that can be used in several forms and reports. Is
this an easy process and how would I do this.

I know how to read the data and place them in the variables but I
can't figure out how to automate this at startup.

There's the Autoexec macro and the Tools, Startup options.
Look up 'Control how an Access file looks and behaves when it
opens' in help. I'd be inclined to open a form on startup and
run the necessary code in the forms Open event.

[PC Datasheet]

Create a blank form and set its visible property to No. Put the code to manage
your public variables in the OnOpen event of the form. Go to Tools - Startup and
at the top right of the dialog box set this form to open when the database
starts. You won't see the form but it will open and your code will execute.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"N. Graves" <ng*****@REMOVEyahoo.com> wrote in message
news:ua********************************@4ax.com...

Thanks for taking the time to read my question and hopefully it will
be understandable.

I have a need to read a record in a table and place the information in
public variables that can be used in several forms and reports. Is
this an easy process and how would I do this.

I know how to read the data and place them in the variables but I
can't figure out how to automate this at startup.

Please help me

N. Graves

[N. Graves]

Good Idea thanks!

N. Graves

On Fri, 02 Jul 2004 19:00:14 GMT, "Jim Allensworth"
<ji****@Notdatacentricsolutions.com> wrote:

On Fri, 02 Jul 2004 13:59:19 -0400, N. Graves
<ng*****@REMOVEyahoo.com> wrote:

Thanks for taking the time to read my question and hopefully it will
be understandable.

I have a need to read a record in a table and place the information in
public variables that can be used in several forms and reports. Is
this an easy process and how would I do this.

I know how to read the data and place them in the variables but I
can't figure out how to automate this at startup.

Please help me

N. Graves

Use the Open event of a startup form to set the variables.

Note that if you have a runtime error, your variables will be wiped
out. An alternative might be to use invisible text boxes on an always
open form to hold the values.

- Jim

[N. Graves]

Thank you very much for your input!

N. Graves

On Fri, 02 Jul 2004 19:01:16 GMT, "rkc"
<rk*@yabba.dabba.do.rochester.rr.bomb> wrote:

"N. Graves" <ng*****@REMOVEyahoo.com> wrote in message
news:ua********************************@4ax.com.. .

Thanks for taking the time to read my question and hopefully it will
be understandable.

I have a need to read a record in a table and place the information in
public variables that can be used in several forms and reports. Is
this an easy process and how would I do this.

I know how to read the data and place them in the variables but I
can't figure out how to automate this at startup.

There's the Autoexec macro and the Tools, Startup options.
Look up 'Control how an Access file looks and behaves when it
opens' in help. I'd be inclined to open a form on startup and
run the necessary code in the forms Open event.

[N. Graves]

Good Idea thanks for the info!

N. Graves

On Fri, 02 Jul 2004 19:03:25 GMT, "PC Datasheet" <no****@nospam.spam>
wrote:

Create a blank form and set its visible property to No. Put the code to manage
your public variables in the OnOpen event of the form. Go to Tools - Startup and
at the top right of the dialog box set this form to open when the database
starts. You won't see the form but it will open and your code will execute.