Question about Microsoft Visual Basic 6.0 for PC

1 Answer

How do i use date in visual basic 6

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

Murtaza Aalam

Posted by on

  • 1 more comment 
  • Anonymous Mar 20, 2009

    there is a date/time field in access now i want to get those records which lies between two date e.g those records which lie say between 01 march 2008 and 18 august 2008



    my problem is that when i execute SQL command in VB 6 with two string type in a text box . It shows an error i.e Data type missmatch



    hope now i'm have explained my problem more clearly



    Murtaza

  • Anonymous Apr 01, 2009

    Sir,



    I am creating a project in vb6.0 using acess database i have added search option there also ex search by date or name, etc



    My problem is that i want to search records in my database between two dates and have a report of same for print



    if you can solve this problem then please mail me its solution at aakash.best@gmail.com. (Mail me an example file of same in vb 6.0 and acess databace 2000)



    you can call me also.

    i will be very grateful to you

    reply me soon as possible pleasee.



    Akash Garg

    9968635587

  • Anonymous May 20, 2009

    I am using vb 6.0 and MS-Access 2003 as data base. I want to call data between 2 dates on the Datagrid view placed on the VB Form. I am using ADO control. Please Help in this regard guruji

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Dedicated:

    Visited the website for 20 consecutive days.

  • Expert
  • 90 Answers

Hi,

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.

Thanks.

Posted on Mar 18, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

I dont know the disadvantages of visual basic.


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.
Also
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.

Jul 06, 2010 | Microsoft Visual Basic V6.0 Fundamentals...

2 Answers

How to make a code for log in using database?


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

Oct 21, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

What is the compatible database for visual basic 6.0?


Microsoft Access uses the Jet Engine. In VB 6, you can create a data connection using ODBC or OLE DB. Here is an example of OLE DB:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\YourAccessDB.mdb;User Id=;Password=;" Good luck

Mar 09, 2009 | Microsoft Press MS Access 2000 and Visual...

1 Answer

VB With MC9090S


Hello,
If you are willing to use VB.NET, then it will be easy. You would need the Symbol EMDK. With that and VS2008 (Express should be fine as well), you only need few coding steps:

1) Add reference to dlls
Symbol.dll and Symbol.Barcode.Dll

2) Finder a scanner
s = Symbol.Barcode.Device.AvailableDevices.First()

3) make a reader
r = New Symbol.Barcode.Reader(s)

4) add data
d = New Symbol.Barcode.ReaderData(1, 1024)

5) enable laser
r.Actions.Enable()

6) enable reading
r.Actions.Read(nrd)

7) add handler
AddHandler r.ReadNotify, AddressOf r_ReadNotify

8) read data in event
msgbox(d.Text)

That is all there is too it. Good day.

Jan 22, 2009 | Symbol MC9090 Barcode Scanner

1 Answer

Code for find the Ms access database size using visual basic


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

'Imports System.Data.OleDb 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) conn.Open() cmd.ExecuteNonQuery() conn.Close()

Nov 10, 2008 | Microsoft Office Standard for PC

1 Answer

Visual basic codes


Since I'm not sure what version of VB you are using, or whether you have a date picker application or not, try the following suggestions:

Nov 06, 2008 | Computers & Internet

1 Answer

How this can be do in asp.net???


You will need a third party control to produce graphs in ASP.net. Is that what you want?
Take a look at http://www.dotnetcharting.com/ it is free I think and may do what you need.

Nov 04, 2008 | Keystone Active Server Pages (ASP)/Visual...

1 Answer

Visual basic


Please Check the format of date time that is comming from record set

Aug 02, 2008 | Computers & Internet

1 Answer

Vb project


One of three ways:
1 make the table using vb creating a Bload screen.
2 using the visual data manager.
3 import a windows access or excel data base table.

Try the data wizard, easiest to use and U can program the program to manipulate the data in the tables.

May 29, 2008 | Computers & Internet

1 Answer

Ms access


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.

I wish it was more, but ...

Oct 09, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Visual Basic 6.0 for PC Logo

Related Topics:

448 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18344 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...