PARAMETERS statment in the query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, All
I have a question,
How can i specify the size of the dialog box with "Enter Parameter Value"
it has two buttons "OK" and "CANCEL"?
Is it possible to customize the dialog box? the size of it and where it
displayes on the screen?

Thank you,
 
Not in a parameter query. However, the preferred way to get data to plug
into a query is to create your own form, which you do have much more control
over.

HTH
Dale
 
Hi, All
I have a question,
How can i specify the size of the dialog box with "Enter Parameter Value"
it has two buttons "OK" and "CANCEL"?
Is it possible to customize the dialog box? the size of it and where it
displayes on the screen?

Thank you,
Click to expand...

You have no control over the size/appearance of the parameter dialog
box.

If you want something custom, create your own form. You can add as
many or as few features as you wish. You can have it appear anywhere
in the window you wish.

You would then refer to the form in the query criteria as:
forms!FormName!ControlName

Of course, the form must be open when the query is run.
 
Hi, All
I have a question,
How can i specify the size of the dialog box with "Enter Parameter Value"
it has two buttons "OK" and "CANCEL"?
Is it possible to customize the dialog box? the size of it and where it
displayes on the screen?
Click to expand...

You don't have a lot of choice with the builtin parameter box. What you can do
instead is use an unbound Form for the purpose, and a parameter like

=[Forms]![frmCriteria]![controlname]


John W. Vinson [MVP]
 
Thank you,
It is very helpful!

John W. Vinson said:
Hi, All
I have a question,
How can i specify the size of the dialog box with "Enter Parameter Value"
it has two buttons "OK" and "CANCEL"?
Is it possible to customize the dialog box? the size of it and where it
displayes on the screen?
Click to expand...

You don't have a lot of choice with the builtin parameter box. What you can do
instead is use an unbound Form for the purpose, and a parameter like

=[Forms]![frmCriteria]![controlname]


John W. Vinson [MVP]
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cancel Button on Parameter Query 1
Parameter in query 2
Parameter Query Won't Run 0
Parameter query issue in Access 2003 6
Enter Parameter Value in Access Form 0
Parameter Query Using A custom form 2
dialog box/parameter query 2
query parameter order 4

Back
Top