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