<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4916.2300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=321093013-12062003><FONT face=Arial color=#0000ff size=2>Yep,
that's it!</FONT></SPAN></DIV>
<DIV><SPAN class=321093013-12062003><FONT face=Arial color=#0000ff
size=2>Normally I don't use this approach (i.e. directly referencing controls in
queries). However, this was for a quick and dirty set of data conversion
queries, and we needed to plug the date range into it.</FONT></SPAN></DIV>
<DIV><SPAN class=321093013-12062003><FONT face=Arial color=#0000ff size=2>Thanks
for the advice.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Rocky Smolin - Beach Access
Software [mailto:bchacc@san.rr.com]<BR><B>Sent:</B> Thursday, June 12, 2003
8:26 AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re:
[AccessD] A2K: Query parameters disappear in break mode<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Brett:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Are you referencing the control directly in the
criteria line of the QBE - Forms!frmXyz!ctl123? I can't remember why but
I always had such trouble getting values from controls off of forms and into
my queries that I changed the criteria to reference a global function which
returns the value of the control. Maybe that will dodge around the
problem instead of solving it.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>HTH,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=BBarabash@tappeconstruction.com
href="mailto:BBarabash@tappeconstruction.com">Brett Barabash</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:'accessd@databaseadvisors.com'">'accessd@databaseadvisors.com'</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, June 10, 2003 2:12
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] A2K: Query
parameters disappear in break mode</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial size=2>My colleague ran
across a strange problem in Access 2000, and I can't seem to find anything
on any of the reference sites that mention this
behavior:</FONT></SPAN></DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial size=2>Created an
append query that references form controls as it's criteria (start/end
dates).</FONT></SPAN></DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial size=2>Set a breakpoint
in the command button event procedure.</FONT></SPAN></DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial size=2>With the code in
break mode, he tried opening the query manually, and no records were
returned.</FONT></SPAN></DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial size=2>After a little
troubleshooting, we found that the referenced form control values disappear
in the query if the form's code is in break mode!</FONT></SPAN></DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=339160221-10062003><FONT face=Arial size=2>What a
PITA! Has anyone else run across this problem?</FONT></SPAN></DIV>
<P><FONT face=Arial size=2>Brett Barabash, MCP <BR>Tappe Construction, Co.
<BR>Eagan, MN <BR>bbarabash@tappeconstruction.com <BR>(651) 256-6831
</FONT></P>
<P><FONT face=Arial size=2>"Computer games don't affect kids; I mean if
Pac-Man affected us as kids, we'd all be running around in darkened rooms,
munching magic pills and listening to repetitive electronic music." -
Kristian Wilson, Nintendo, Inc., 1989.</FONT></P>
<DIV> </DIV><BR><BR>--------------------------------------------------------------------------------------------------------------------<BR>This
email and any files transmitted with it are confidential and<BR>intended
solely for the use of the individual or entity to whom<BR>they are
addressed.<BR>If you have received this email in error please notify
the<BR>originator of the message. This footer also confirms that
this<BR>email message has been scanned for the presence of computer
viruses.<BR><BR>Any views expressed in this message are those of the
individual<BR>sender, except where the sender specifies and with
authority,<BR>states them to be the views of Tappe Construction
Co.<BR><BR>Scanning of this message and addition of this footer is
performed<BR>by SurfControl E-mail Filter software in conjunction with
<BR>virus detection software.<BR>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BLOCKQUOTE><br><br>--------------------------------------------------------------------------------------------------------------------<br>This email and any files transmitted with it are confidential and<br>intended solely for the use of the individual or entity to whom<br>they are addressed.<br>If you have received this email in error please notify the<br>originator of the message. This footer also confirms that this<br>email message has been scanned for the presence of computer viruses.<br><br>Any views expressed in this message are those of the individual<br>sender, except where the sender specifies and with authority,<br>states them to be the views of Tappe Construction Co.<br><br>Scanning of this message and addition of this footer is performed<br>by SurfControl E-mail Filter software in conjunction with <br>virus detection software.<br></BODY></HTML>