I am using Access as data base there is a date field
In vb i'm passing to dates in two text box and want to get data which lies between these two dates
since dates in SQL command are of string type and date in access are date type
there is data type mismatch
pl help and solve my problem
An expert who has achieved level 2 by getting 100 points
An expert that got 10 achievements.
An expert that got 5 achievements.
Visited the website for 20 consecutive days.
Re: how do i use date in visual basic 6
I am not getting your problem clearly. If you are referring to save the input dates as date in database with the help of sql query then you need to provide hash(#) mark at the beginning and end of date values. It will resolve your problem.
Hope this helps and let me know if you are not getting the solution clearly.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
visual basic, is only a basic programming language, most programs will run on Java script, microsoft is visual basic though, but it uses a lot more complex scripts then, if you like the programing language, go for it, but i did not like it.
VB is undoubtedly the simplest and easiest platform to build major Windows applications. The problem is that like other Microsoft products they change faster than I change my socks.You will certainly need more than just VB. Get into server and client side scripting and the use of VB Net.
RIGHT CLICK ON MY COMPUTER AND SELECT THE MANAGE AND SELECT USER AND GROUPS CLICK YOUR USER ON WHICH YOU WANT CREATE PASSWORD RIGHT CLICK THE USER AND SET PASSWORD AND FILL THE PASSWORD AND ENTER NOW YOUR PASSWORD WILL SET ENJOY
Sorry to say but its impossible. Vita does not support VB.NET. You may succeed if VB 7+ is used and not VB 6 which is installed in most PC's.............................................................sodeep
Your code does not save in access format it just makes a copy of existing file. You need to open table by table and export data using csv format.
It can be done using access OLE to export, or
write some VB code to access the database tables via ODBC and save row data to csv file