December 11th, 2004, 03:27 AM
|
#1 (permalink)
|
| Member
Join Date: Sep 2004
Posts: 275
| Code: Private Sub GetPO()
Dim fromdate As Date
fromdate = cboPOsearchTD.Text + "/" + cboPOsearchTM.Text + "/" + cboPOsearchTY.Text
objDS.Clear()
objDS = objUser.Search_tblUser("Select * from tbl_PURCHASE where Order_Date = 'fromdate'")
Try
dgPOSearch.DataSource = objDS.Tables(0)
Catch ex As Exception
End Try
End Sub I've got a Format Error "Data Format mismatch "
How Come ??
The "Order_Date " is in Date/Time format in MS Access Database !!
Please Help ! i've been stuck in this error for few weeks !!! |
| |