[AccessD] Query reference to screen control

Arthur, can you please put up a quick overview of what's needed to replace form parameters with Static functions? 
TIA
Stephen Bond

-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com]
Sent: Friday, 30 May 2003 11:23 p.m.
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Query reference to screen control


That's an additional reason why I dislike going that route. The query then becomes useless in the absence of said form being open. Static functions are IMO a much better way to go.
 
Just my $.02,
Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: May 29, 2003 11:00 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Query reference to screen control



Parameters referring to form controls work just fine.  Only make sure you put in the square brackets around each part of the parameter yourself.  Otherwise, when/if you convert to 2002, you can run into problems when the query engine kindly inserts its own brackets around the whole blasted parameter.  Hello?  This is the voice of experience speaking ...
 
Charlotte Foust

-----Original Message-----
From: Don Elliker [mailto:delliker at hotmail.com] 
Sent: Thursday, May 29, 2003 5:16 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Query reference to screen control



Hmmmm, that's a twist. Does it then not pop up the parameter dialog because I would be referring to the screen control?...I will give it a go, and thanks Gustav.
_d





"Things are only free to the extent that you don't pay for them." 

>From: Gustav Brock 
>Reply-To: accessd at databaseadvisors.com 
>To: accessd at databaseadvisors.com 
>Subject: Re: [AccessD] Query reference to screen control 
>Date: Thu, 29 May 2003 12:53:47 +0200 
> 
>Hi Don 
> 
>Try specifying in the query [forms]![frmtestcases]![cmbproject] as a 
>parameter. 
> 
>/gustav 
> 
> >I have this odd occurrance in A2K. I have a combo that has criteria 
> >referencing two screen controls, like this 
> >[forms]![frmtestcases]![cmbproject]. Many times (but not always) it 
> >returns nothing when I click it. Then if I go into the grid for the 
> >underlying query and make it 
> >=[forms]![frmtestcases]![cmbproject] it works, however it does not keep 
> >the equal sign, it discards it - works for a while then craps out. What 
> >gives?? Just another wierd Accessism? 
> 
>_______________________________________________ 
>AccessD mailing list 
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd 
>Website: http://www.databaseadvisors.com 

  _____  

MSN 8 helps ELIMINATE E-MAIL  <http://g.msn.com/8HMJENUS/2752??PS=> VIRUSES. Get 2 months FREE*. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030603/7f3cda52/attachment.html>