Can one open 2 forms side by side at startup?

[royfarnol]

That's all folks, thanks, Roy

 

[Tom van Stiphout]

On Fri, 6 Feb 2009 16:23:51 +1300, "royfarnol" <[email protected]>
wrote:

Have you tried:
Docmd.OpenForm "myForm1"
Docmd.OpenForm "myForm2"

where you currently only have
Docmd.OpenForm "myForm1"

-Tom.
Microsoft Access MVP

 

[royfarnol]

No I haven't. But I will.
Thanks, Roy.

Have you tried:
Docmd.OpenForm "myForm1"
Docmd.OpenForm "myForm2"

where you currently only have
Docmd.OpenForm "myForm1"

-Tom.
Microsoft Access MVP

 

[BruceM]

I don't think you can select more than one startup form, but you should be
able to use that form's Open or Load event to open another form.

 

[Stefan Hoffmann]

I don't think you can select more than one startup form,

Correct.

But he can use an AutoExec macro. Create a macro name it AutoExec (case
insensitv). This macro will be called after opening the file.


mfG
--> stefan <--

 

[BruceM]

I don't use macros much, so that didn't occur to me. Thanks for pointing it
out.

 

[Stefan Hoffmann]

hi Bruce,

I don't use macros much, so that didn't occur to me. Thanks for
pointing it out.

This is the only macro I use sometimes


mfG
--> stefan <--

 

[fredg]

That's all folks, thanks, Roy

Others have told you how to open the 2 forms.
If you then wish them to be set side by side use each form's Load
event to position the forms where you wish them:
Code the left side form's Load event:

DoCmd.MoveSize 0.5*1440,2*1440

Code the right side form's Load event:

DoCmd.MoveSize 5*1440,2*1440

The first form will be placed 1/2-inch from the left of the screen and
the right form will be 5 inches from the left edge of the screen. Both
will be 2 inches down from the top of the screen.
Adjust the values as needed.
Note that all measurements must be in Twips, 1440 per inch.

 

[royfarnol]

This was my original question and I solved it more or less by accident. I
simply used access startup options for the first form and then used that
form's "on resize" to open the second form. A typical Kiwi 6" wire solution.
A complete lack of elegance but it works.

Regards, Roy.