After I tried several ways i figure out that actually it was my fault.
But the new problem occurs
the query SELECT * from booking WHERE BOOK_DATE = date()
is actually work in VB
the reason why it wasn't working because there is no records which contains BOOK_DATE = today date
But how could this happen because there are records which has BOOK_DATE = today date but VB just couldn't find it.
There is a possibility either the database i've made in MS Access or the VB itself has the error.
The same table shows in Access and VB is even different
let me explain. I have created the database in MS Access for a while with some records in it (i'm talking to only specific table 'booking')
so these records contain various date range.
but once i work with the VB, i thought that i want to try showing the data which has the 'today date' in the DBGrid, so i go back to my MS Access and edit some of the records, changing their date to either 12 Oct or 15 Oct 2010.
then i switch back to VB, i tried showing the data with the simple query SELECT * from booking
.
But the records that show in the table were the previous data before i've changed the date(12,15).
This is what i curious that why the data in Access that i've edited and saved but it didn't update in VB DBGrid.
It turns out whether how much more i change the information in the Access, the vb wont update the table but keep displaying the old one.