set query parameter from VBA Modules & VBA. If I type in the the above criteria in the design window I get what I want, but how do I send that. This example demonstrates Parameter objects and the Parameters Sample code provided by the Microsoft Access Programmer's. PARAMETERS declaration (Microsoft Access SQL) One of the primary Microsoft Access SQL data types or their synonyms. The following example expects two parameters to be provided and then applies the criteria to. VBA parameters are implicitly passed by reference (ByRef). This means you're passing a reference to the value, not the value itself: mutating that value inside.