Position of Dialog Box

  • Thread starter Thread starter John Humble
  • Start date Start date
J

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
 
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.
 
Thanks Fred. I'll do as you suggest.

John

Fredg said:
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.


John Humble said:
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
Click to expand...
Click to expand...
 
Back
Top