<!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 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=960542913-12062003><FONT face=Arial color=#0000ff
size=2>Rocky,</FONT></SPAN></DIV>
<DIV><SPAN class=960542913-12062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=960542913-12062003><FONT face=Arial color=#0000ff size=2>
The problem that you refer to is that if you don't explicitly indicate the data
type in the control to the query (viq a PARAMETERS statement), Access will guess
as to the data type. In some cases (Date/Time values), it can guess
wrong.</FONT></SPAN></DIV>
<DIV><SPAN class=960542913-12062003></SPAN> </DIV>
<P><FONT size=2>Jim Dettman<BR>President,<BR>Online Computer Services of WNY,
Inc.<BR>(315) 699-3443<BR>jimdettman@earthlink.net </FONT></P>
<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>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Rocky Smolin
- Beach Access Software<BR><B>Sent:</B> Thursday, June 12, 2003 9: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></BODY></HTML>