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

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

How do i install Visual Basic .Net Standard 2003 on my Vista with compatibility issues?


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

Oct 16, 2009 | Microsoft Visual Basic .NET Standard 2003...

2 Answers

CPU Scheduling VB.Net Sample Program


well threading does this for you, look at the thread class and related classess in .net

Jun 02, 2009 | Microsoft Visual Basic .NET Standard 2003...

1 Answer

How to access data from ms access with buffer in class code with vb application


Use ADO and create a connection string for a Jet file (version matters here when creating the string). Then use ADO commands and return recordsets to buffer your data.

Mar 26, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

Write into excel format


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

Feb 17, 2009 | Microsoft Visual Basic Professional...

1 Answer

I want to add a calendr in my vb form when i clicked on perticular date that gies me the report which already stored in my database which has stored how many person are entered on perticular date please...


I suggest you this URL:
http://www.codeproject.com/
You will get your answers there simply. This websit eis the source of .NET programming like C#, VB, J#, ASP and ....
enjoy it!

Jan 21, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

Put a calander


You can get your answer easily in http://www.codeproject.com/ by a simple search.
Enjoy it!

goodluck

Jan 21, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

Visual basic


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

Aug 02, 2008 | Compilers & Programming Tools

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 | Compilers & Programming Tools

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

Related Topics:

445 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Compilers & Programming Tools Experts

Fred Block
Fred Block

Level 2 Expert

289 Answers

Robin Hill
Robin Hill

Level 3 Expert

1251 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Compiler and Programming Tool Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...