Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MySQL (http://www.go4expert.com/forums/mysql-forum/)
-   -   VB + SQL (Accept date input from user for search) (http://www.go4expert.com/forums/vb-sql-accept-date-input-user-search-t26173/)

abstrused00388 29Jun2011 11:24

VB + SQL (Accept date input from user for search)
 
Adodc1.RecordSource = "SELECT * FROM cm1 WHERE dt>=#1/1/2011 02:00:00 AM# AND dt<=#4/1/2011 02:00:00 PM#"

for searching a database using VB !

please let me know if there is a way to accept input from the user in a text box and use thm instead of the constant values that i have used


All times are GMT +5.5. The time now is 15:25.