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.
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US. click here to Talk to a Technician (only for users in the US for now) and get all the help you need. Goodluck!
- 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
The way to get the database size is to point to the directory that the database is do a DIR statement with an output to a file as in DIR payroll.mdb>dbsize.txt and then read from the text file, the first field of the second line being the name (which you really don't need) then the size value of the database.
To import the text files using VB 8 use
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\path\filename.mdb")
Dim cmd As New OleDbCommand("SELECT * INTO [import] FROM [Text;Database=d:\path;Hdr=No].[dbsize.txt]", conn)
Stored Procedures don't exist in MS Access. You do have the following options though. Queries, which are just select or action queries. VB Code, which you can write using Query Objects as if you were writing a Visual Basic application. These can be Functions or Subroutines. In these, you would use the standard programming techniques with while and for loops, etc.
You can create complex situations combining the two of these. A function in the VB code area can accept through parameters, the single values (line by line, record by record) in a query and act on them and manipulate the values.
For example: create a query that does a select phone from address. Create a function in vb called public function StripDashesInPhone(Phone as string) which then uses VB coding to strip dashes from each phone value passed in. To make it all work, in the query on one of the field columns put "NewPhone: StripDashesInPhone([Phone])" and for every record processed in the query, the function is called with the [Phone] field value passed in to the function and the action is processed and returned.
Other than writing a function that is activated by a form button click, which opens the current db and opens a table and process it, just like in VB, this is about as close to cursors and oracle procedures as you get.