pass the name of the parameter and the value?

I have fought the battle of passing positional parameters, and it's a pain when, as you stated, there are a lot of parameters and you only need one at the "end".

In Access I can either pass positional parameters or the Parameter name and the value (made up example: PageLen:60). That gives me the ability to pass all the parameters positionally, or just the one(s) needed.