[AccessD] Query reference to screen control

Arthur Fuller artful at rogers.com
Fri May 30 06:22:54 CDT 2003


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/20030530/f155ff0f/attachment-0001.html>


More information about the AccessD mailing list