Examples of the use of passing parameters to stored procedures ? God, what
will you want next ?
The answer is in a Kbase article titled "Smashing your computer into a
I have been trying to limit the list of values shown in a Combobox by a
"Like" query based on a
value in a text box. I looked at the Input Parameter method for an Sp but
the documentation from Messoft and internet searches was not enlightening.
What you have typed is more useful to me than that which those <censored> at
There is an article about - wait for it - "ACC2002: How to use Parameterized
Combo Boves in an Access Project (Q281870)".
This might work as implemented but it doesn't where the combo box is on the
same form. A 2002 thing perhaps ?
I did come up with something, but I don't want to implement it - Web:
ElementK journals , Microsoft Office Developers Journal August 1998 -
Dynamically filling combo boxes by Patrick L. Steiner.
I'll be watching this thread with interest - meantime I have a PC to glue
> I'm attempting to run a stored procedure based on a value which I'm taking
> from a form. I can get it to work if the value I'm passing across is
> integer, but I actually need to be passing text across. More detail:
> I have a combo called combo0. The row source for this is the name of my
> Procedure is:
> Alter Procedure test
> SELECT blah, blah, blah
> ...the proc works if I just run it manually and feed it the parameter.
> I have the Input Parameters of the form set up to be:
> ..and I've also tried setting it via code with something like:
> ...in the OnClick of a button.
> If, however, I set the combo to show all the contents of the proc, it
> doesn't seem to be getting passed the parameter.
> Can anyone point out where I'm going wrong before I have to smash my
> computer into a gazillion pieces? Are there any examples of the use of
> stored procedures anywhere?