Results 1 to 10 of 10

Thread: Error[ReSolved]

Threaded View

  1. Nov 11th, 2004, 10:59 AM #1
    Paradox
    Paradox is offline

    Thread Starter
    Addicted Member Paradox's Avatar
    Join Date
    Sep 2004
    Location
    Nairobi
    Posts
    189

    Resolved Error[ReSolved]

    I am trying to query a records from a SQL Server Dbase and i get a syntax error. Where am i goin wrong
    Thanks


    VB Code:
    1. Private Sub Command1_Click()

    2.     rsrequests.Open "SELECT * FROM Requests WHERE((DateReq) Between '" & Format(DTPicker1.Value, "dd mmm yyyy") & "' AND '" & Format(DTPicker2.Value, "dd mmm yyyy") & "'AND '" & (Combo1.Text) & "')", Cn, adOpenStatic, adLockReadOnly
    Last edited by Paradox; Nov 12th, 2004 at 01:13 AM.
    Peny wise pound Foolish
    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