Position of Dialog Box

[John Humble]

How can I control the screen position of the "Enter Parameter Value" Dialog
Box on the screen?
It is generated by a Query called from a button on a Swirchboard. I'd like
to be able to place the Dialog Box immediately below the Switchboard button.
I'm using Access 2000.

TIA

John

 

[Fredg]

John,
You can only manually drag it after it appears.
You can't position it by code.

If you want to enter the parameters in a particular place, use an unbound
form to do so.
Open the form in acDialog.
You can position the form wherever you like using the form's MoveSize
property (see Access Help) in the form's Open event:
DoCmd.MoveSize 3 * 1440, 4 * 1440
(3 inches from the left, 4 inches from the top. 1440 twips - 1 inch.)

Then, where you now use something like
[Enter the parameter]
refer to the open form in the query using the
forms!FormName!ControlName
syntax.

 

[John Humble]

Thanks Fred. I'll do as you suggest.

John

John,
You can only manually drag it after it appears.
You can't position it by code.

If you want to enter the parameters in a particular place, use an unbound
form to do so.
Open the form in acDialog.
You can position the form wherever you like using the form's MoveSize
property (see Access Help) in the form's Open event:
DoCmd.MoveSize 3 * 1440, 4 * 1440
(3 inches from the left, 4 inches from the top. 1440 twips - 1 inch.)

Then, where you now use something like
[Enter the parameter]
refer to the open form in the query using the
forms!FormName!ControlName
syntax.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

How can I control the screen position of the "Enter Parameter Value" Dialog
Box on the screen?
It is generated by a Query called from a button on a Swirchboard. I'd like
to be able to place the Dialog Box immediately below the Switchboard button.
I'm using Access 2000.

TIA

John