Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    New Zealand
    Posts
    47

    Unanswered: No valuegiven for one or more parameter...

    this is my error

    "No value give for one or more required parameter"

    this is the code it refers to.

    Dim strDetail As Integer
    sqlMastLine = (Nz("select * from Mast_Detail_Line, QuoteMast where cstr(Mast_Detail_Line.Quote_Detail_ID) =" + CStr(strDetail) + " AND Mast_Detail_Line.Mast_ID = QuoteMast.ID"))
    Set rstMast = New ADODB.Recordset
    rstMast.Open sqlMastLine, CurrentProject.Connection, adOpenKeyset, adLockBatchOptimistic

    this all works fine if my SQL query retuens values, but if it has no values then this line has the above error.
    "rstMast.Open sqlMastLine, CurrentProject.Connection, adOpenKeyset, adLockBatchOptimistic"

    Please help?
    nerdy_girl
    Nerdy Girl

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    sqlMastLine = (Nz("select * from Mast_Detail_Line, QuoteMast where cstr(Mast_Detail_Line.Quote_Detail_ID) = " & CStr(strDetail) & " AND Mast_Detail_Line.Mast_ID = QuoteMast.ID"))

Posting Permissions

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