Can one open 2 forms side by side at startup?

T

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
 
R

royfarnol

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

Tom van Stiphout said:
Have you tried:
Docmd.OpenForm "myForm1"
Docmd.OpenForm "myForm2"

where you currently only have
Docmd.OpenForm "myForm1"

-Tom.
Microsoft Access MVP
Click to expand...
 
B

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.
 
S

Stefan Hoffmann

BruceM said:
I don't think you can select more than one startup form,
Click to expand...
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 <--
 
B

BruceM

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

Stefan Hoffmann

hi Bruce,
I don't use macros much, so that didn't occur to me. Thanks for
pointing it out.
Click to expand...
This is the only macro I use sometimes :)


mfG
--> stefan <--
 
F

fredg

That's all folks, thanks, Roy
Click to expand...

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.
 
R

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.
 
Top