[AccessD] A2K: Query parameters disappear in break mode

Rocky,

  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.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
Beach Access Software
  Sent: Thursday, June 12, 2003 9:26 AM
  To: accessd at databaseadvisors.com
  Subject: Re: [AccessD] A2K: Query parameters disappear in break mode


  Brett:

  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.

  HTH,

  Rocky

    ----- Original Message -----
    From: Brett Barabash
    To: 'accessd at databaseadvisors.com'
    Sent: Tuesday, June 10, 2003 2:12 PM
    Subject: [AccessD] A2K: Query parameters disappear in break mode


    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:

    Created an append query that references form controls as it's criteria
(start/end dates).
    Set a breakpoint in the command button event procedure.
    With the code in break mode, he tried opening the query manually, and no
records were returned.
    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!

    What a PITA!  Has anyone else run across this problem?
    Brett Barabash, MCP
    Tappe Construction, Co.
    Eagan, MN
    bbarabash at tappeconstruction.com
    (651) 256-6831

    "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.




    ------------------------------------------------------------------------
--------------------------------------------
    This email and any files transmitted with it are confidential and
    intended solely for the use of the individual or entity to whom
    they are addressed.
    If you have received this email in error please notify the
    originator of the message. This footer also confirms that this
    email message has been scanned for the presence of computer viruses.

    Any views expressed in this message are those of the individual
    sender, except where the sender specifies and with authority,
    states them to be the views of Tappe Construction Co.

    Scanning of this message and addition of this footer is performed
    by SurfControl E-mail Filter software in conjunction with
    virus detection software.



----------------------------------------------------------------------------


    _______________________________________________
    AccessD mailing list
    AccessD at databaseadvisors.com
    http://databaseadvisors.com/mailman/listinfo/accessd
    Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030612/cf5676e3/attachment-0001.html>