Dialog boxes

[Caramilk]

Hi,

I have created parameter queries and I was wondering if there is a way to
add a drop down box to that parameter query dialog box that pops up.

Also, is there a way to change the size of that dialog box? My whole message
isn't showing up.

THANKS!

 

[Allen Browne]

The parameter dialog is very limited. You cannot use a combo, or resize it.

But you can create a form any size you like for the user to see your
message, and use a combo to select the value.

For example, if you create a form named Form1, with a combo named Combo1,
and you open this form before running the query, then it will read the value
from the combo on the form if you enter this into the Criteria for of your
query under the right field:
[Forms].[Form1].[Combo1]

 

[Caramilk]

A bit more help... (I'm a bit confused)

The group I am trying to do this for is fairly computer illiterate so I am
trying to make it as simple as possible.

Right now on the switch board they can click "print a report".

Before the report shows up the parameter box pops up asking a question. e.g.
what menu item do you want to print a report for.

After answering it shows the report.

So I'm trying to figure out how your suggestion could work into the above
situation.

I'm trying to figure this all out for the first time so if you wouldn't mind
explaining like I'm 5 years old that would be great!

The parameter dialog is very limited. You cannot use a combo, or resize it.

But you can create a form any size you like for the user to see your
message, and use a combo to select the value.

For example, if you create a form named Form1, with a combo named Combo1,
and you open this form before running the query, then it will read the value
from the combo on the form if you enter this into the Criteria for of your
query under the right field:
[Forms].[Form1].[Combo1]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi,

I have created parameter queries and I was wondering if there is a way to
add a drop down box to that parameter query dialog box that pops up.

Also, is there a way to change the size of that dialog box? My whole
message
isn't showing up.

THANKS!

 

[kabaka]

Not that I know of. To do what you're suggesting, I would create a form that
"looks" like a dialog box, and filter your query based on the combo box
input. This way you can make your custom-made dialog box look and act in any
way you like.

 

[Allen Browne]

You can build this in stages:

1. Create the form with the combo.

2. Open the query in design view. In the Criteria row under the right field,
enter:
[Forms].[Form1].[Combo1]

3. Test, by opening this form, selecting something in the combo. Then
double-click the query in the database window. It should show only the
matching values.

4. Once you have that working, add an Ok button to your form. In its Click
event procedure, use a macro or event procedure containing the OpenReport
action, so it opens the right report.

5. Once that's working too, you can change your Switchboard form so that it
does an OpenForm (to open the form at step 1) instead of the OpenReport.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

A bit more help... (I'm a bit confused)

The group I am trying to do this for is fairly computer illiterate so I am
trying to make it as simple as possible.

Right now on the switch board they can click "print a report".

Before the report shows up the parameter box pops up asking a question.
e.g.
what menu item do you want to print a report for.

After answering it shows the report.

So I'm trying to figure out how your suggestion could work into the above
situation.

I'm trying to figure this all out for the first time so if you wouldn't
mind
explaining like I'm 5 years old that would be great!

The parameter dialog is very limited. You cannot use a combo, or resize
it.

But you can create a form any size you like for the user to see your
message, and use a combo to select the value.

For example, if you create a form named Form1, with a combo named Combo1,
and you open this form before running the query, then it will read the
value
from the combo on the form if you enter this into the Criteria for of
your
query under the right field:
[Forms].[Form1].[Combo1]

Hi,

I have created parameter queries and I was wondering if there is a way
to
add a drop down box to that parameter query dialog box that pops up.

Also, is there a way to change the size of that dialog box? My whole
message
isn't showing up.

THANKS!

 

[Caramilk]

Thanks Allen!

You can build this in stages:

1. Create the form with the combo.

2. Open the query in design view. In the Criteria row under the right field,
enter:
[Forms].[Form1].[Combo1]

3. Test, by opening this form, selecting something in the combo. Then
double-click the query in the database window. It should show only the
matching values.

4. Once you have that working, add an Ok button to your form. In its Click
event procedure, use a macro or event procedure containing the OpenReport
action, so it opens the right report.

5. Once that's working too, you can change your Switchboard form so that it
does an OpenForm (to open the form at step 1) instead of the OpenReport.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

A bit more help... (I'm a bit confused)

The group I am trying to do this for is fairly computer illiterate so I am
trying to make it as simple as possible.

Right now on the switch board they can click "print a report".

Before the report shows up the parameter box pops up asking a question.
e.g.
what menu item do you want to print a report for.

After answering it shows the report.

So I'm trying to figure out how your suggestion could work into the above
situation.

I'm trying to figure this all out for the first time so if you wouldn't
mind
explaining like I'm 5 years old that would be great!

The parameter dialog is very limited. You cannot use a combo, or resize
it.

But you can create a form any size you like for the user to see your
message, and use a combo to select the value.

For example, if you create a form named Form1, with a combo named Combo1,
and you open this form before running the query, then it will read the
value
from the combo on the form if you enter this into the Criteria for of
your
query under the right field:
[Forms].[Form1].[Combo1]

Hi,

I have created parameter queries and I was wondering if there is a way
to
add a drop down box to that parameter query dialog box that pops up.

Also, is there a way to change the size of that dialog box? My whole
message
isn't showing up.

THANKS!