[AccessD] Query Parameter

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Thu Aug 31 18:55:14 CDT 2006


I usually make a public function in a module which return the value from 
the forms and call that function in the criteria line on the QBE grid.  
Don't forget the () in the call on the QBE grid.

Rocky


Bob Heygood wrote:
> Yeah.
> Tried to supply the !Forms.... to the query parameters box even. No luck....
>
>
> Bob
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
> Beach Access Software
> Sent: Thursday, August 31, 2006 4:13 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Query Parameter
>
>
> How do you run it from code?  db.Execute?
>
> Rocky
>
>
> Bob Heygood wrote:
>   
>> I have a query that I execute from code.
>> It has criteria and an alias that references a form control value.
>> This query works fine when run from the db window.
>> But complains that "Too few parameters..1 expected.", when run from my
>>     
> code.
>   
>> TIA
>>
>> Bob Heygood
>>
>>
>>
>>     
>
> --
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com




More information about the AccessD mailing list