Thread: Search by Date -- VB.NET
December 11th, 2004, 03:27 AM #1
- Join Date
- Sep 2004
Search by Date -- VB.NETCode:
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
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 !!!
December 11th, 2004, 02:09 PM #2
- Join Date
- Oct 2003
I would try changing the data type in access to text. Ive had problems in the past similiar to your issue. When using vb as a front end its better to just validate everything in vb rather then the database side
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By danlindley in forum Webmastering and ProgrammingReplies: 2Last Post: August 9th, 2004, 04:26 PM
By JacobM5727 in forum Technical SupportReplies: 6Last Post: January 15th, 2004, 06:11 AM
By Logic in forum Linux and UnixReplies: 9Last Post: December 5th, 2003, 07:37 AM
By Marvinator in forum Applications and Operating SystemsReplies: 2Last Post: December 2nd, 2003, 03:24 PM
By eastfield in forum Webmastering and ProgrammingReplies: 8Last Post: January 22nd, 2003, 03:10 AM