Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Location
    Perth, Western Australia
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Querydefs (Access97)

    Hi
    When I run a query from the query window which evaluates values in form controls I get matching record(s). There are 13 controls. When I try to open the same querydef/recordset in code I get no matching records. Could it be that some of the fields are empty? When I use the query window the empty fields are handled. But when I use the parameter evaluation in code it does not seem to handle "" values.

    Does anyone know what I can do?

    Thanks
    Dean

  2. #2
    Star Lounger
    Join Date
    Nov 2001
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Querydefs (Access97)

    I think that this article is the answer that you are looking for....

    <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q136/0/62.asp?LN=EN-US&SD=gn&FR=0&qry=q136062&rnk=1&src=DHCS_MSPSS_gn_ SRCH&SPR=ACC97>http://support.microsoft.com/support/kb/ar..._SRCH&SPR=ACC97</A>

    hth,
    Jack

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •