Thread: Search by Date -- VB.NET
-
December 11th, 2004, 03:27 AM #1Member
- Join Date
- Sep 2004
- Posts
- 275
Search by Date -- VB.NET
I've got a Format Error "Data Format mismatch "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
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 #2Member
- Join Date
- Oct 2003
- Posts
- 267
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
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
get date in access
By danlindley in forum Webmastering and ProgrammingReplies: 2Last Post: August 9th, 2004, 04:26 PM -
reset search page to default
By JacobM5727 in forum Technical SupportReplies: 6Last Post: January 15th, 2004, 06:11 AM -
Digital Camera on RH9
By Logic in forum Linux and UnixReplies: 9Last Post: December 5th, 2003, 07:37 AM -
MS Access Help with a Query
By Marvinator in forum Applications and Operating SystemsReplies: 2Last Post: December 2nd, 2003, 03:24 PM -
Date Notification
By eastfield in forum Webmastering and ProgrammingReplies: 8Last Post: January 22nd, 2003, 03:10 AM



LinkBack URL
About LinkBacks



Reply With Quote

LOUGH ERNE, NORTHERN IRELAND: People from Downing Street are concerned that disagreements over Syria will overshadow this G8 summit, with its stated agenda of kindling new economic growth by tackling...
Bitter Syria rift gets G8 off to...