Results 1 to 4 of 4

Thread: 'No value given' error with rs [RESOLVED]

Threaded View

  1. Apr 11th, 2005, 05:22 AM #1
    BIOSTALL
    BIOSTALL is offline

    Thread Starter
    Addicted Member BIOSTALL's Avatar
    Join Date
    Apr 2005
    Location
    Northampton, UK
    Posts
    180

    'No value given' error with rs [RESOLVED]

    Hey

    I have this:
    VB Code:
    1. RS.Close

    2.         RS.Source = "Select * from Cars where Car_Registation = '" & lblCarReg.Caption & "'"

    3.         RS.Open

    4.         StartDate = RS.Fields("Car_DateDueOut")

    5.         EndDate = RS.Fields("Car_DateDueBack")

    6.             If (txtHireDateCommence.Text > StartDate And txtHireDateFinish.Text < EndDate) Then

    7.                 MsgBox "The car is not available to hire out at the specified time. Please go back and select another car", vbExclamation + vbOKOnly, "Car not available"

    8.                 Exit Sub

    9.             End If
    Its giving me the error:

    "No value given for one or more required parameters"

    It then highlights RS.Open I cant figure out what wrong with it. Any suggestions please?? Just ask if u need more information. Thanks

    BIOSTALL
    Last edited by BIOSTALL; Apr 11th, 2005 at 09:28 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width