Question Parameter box value

[SeanD]

Hi,

I have this query.
SELECT * FROM Data WHEE Volume = [Type Volume]

Then there appeares a parameter box where you type in the value.
Is there a way to pass this value into a variable?

Sorry for bad english, I hope you understand it

Thanks!

 

[Galaxiom]

Use a form where you can type the value into a text box. Then you can easily use the value in the query and anything else you want.

 

[vbaInet]

Further to GalaxiomAtHome's advice, read the section "Create a form that collects parameters"

http://office.microsoft.com/en-us/access-help/use-parameters-in-queries-and-reports-HA010096314.aspx

 

[SeanD]

Here's my situation

I have a switchboard where I have a button.
If I press the button, a Form opens with the results of the query.
SELECT * FROM Data WHERE Volume = [Type Volume: ]
So I really need this parameter box because it's not laways the same value I like to type.
In the form, there are multiple records. So you have to click ' go to next record' to see all the records, one by one.
On this form, I have a butten called 'Summary'
If I press this button, A new form opens, based on the same query.
(So this is the part I want a change because here I need to type the same value again).

So is there a way to put the value from the parameter box into a variable, or is there a way to save the query after u typed in the value in the parameter box?

Example: If you type '5' in the paramater box, the query is:
SELECT * FROM Data WHERE Volume = 5
Can I put this query into a variable?

 

[vbaInet]

SeanD, GalaxiomAtHome has told you the way to do it and I provided you with the link. Have a look at what has been advised.

 

[Galaxiom]

There are ways to do just about anything but working around the limitations while entering values via a parameter box isn't one that I would bother with.

Personally I find entering parameters this way tedious and in most cases see it as a sign of an amateurish designer.

Far better to include a textbox, listbox or combo in the form where the button is pressed to open the form that displays the data. This control can include features such as a default, a date picker and validation code. Multiple parameters can be entered and edited without having to retype them all for every run.

 

[SeanD]

Oke, thanks for the answer.
I'll solve it with a form.
I know how to do it with forms, but I just wondered if it was possible with parameter boxes also.

 

[vbaInet]

I know how to do it with forms, but I just wondered if it was possible with parameter boxes also.

If it was possible we would have said so So the answer is, no it isn't possible to get the value from a pop-up input box in a query. However, perhaps you can put that as a parameter of a function and get the value from the function, but it's just not worth the hassle.

 

[SeanD]

Thank you all ^^

This threat can be closed ^^