[AccessD] Query reference to screen control

Actually, what I encountered had nothing to do with the form being open.
In earlier versions, the query engine understood the syntax without
square brackets around things like Column(0), but in AXP, any missing
brackets will cause it to put a pair of square brackets around the whole
parameter, rendering it completely useless even with the form open.
 
I don't much like using form references as parameters or criteria, but
our applications make extensive use of them that way in report
selection.  
 
Charlotte Foust

	-----Original Message-----
	From: Arthur Fuller [mailto:artful at rogers.com] 
	Sent: Friday, May 30, 2003 3:23 AM
	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 VIRUSES.
<http://g.msn.com/8HMJENUS/2752??PS=>  Get 2 months FREE*. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030530/0a98115c/attachment-0001.html>