Question about Microsoft Visual Basic Enterprise Edition 6.0 (361-00667) for PC

1 Answer

Inserting data into MSFlexGrid control from an excel file

How to insert data to an MSFlexGrid contol in visual basic 6.0. After this is done with the data how to draw chart of type XYscatter using MSChart control

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

    New Friend:

    An expert that has 1 follower.

  • Expert
  • 48 Answers

Have you tried implementing an ADO (Active Data Object) control (available from the toolbox)? Properly configured (and run via OLEDB or Microsoft Jet as appropriate for your setup) it works like a champ.

Posted on Apr 07, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How to install microsoft visual basic 6.0


  • Open the Web page for Microsoft Visual Studio on your computer.
  • 2 Start the download by clicking the "Download" button. Put the file somewhere where you can find it easily, such as your desktop.
  • 3 Locate the setup file "vbrun60sp5.exe" on your hard drive.
  • 4 Double click the setup file to start the installation wizard.
  • 5 Read the license agreement and click the "accept" box to begin installation.
  • 6 Follow the instructions provided by the installation wizard to install the program.


  • Read more: How to Install Visual Basic 6 ' eHow.com http://www.ehow.com/how_5896501_install-visual-basic-6.html#ixzz16RqHSTGS

    Nov 27, 2010 | Microsoft Visual Basic 6.0 for PC

    1 Answer

    How to Export MSFlexgrid Data to Crystal Report in Visual Basic 6.0


    simple Way to do is
    Save all Data to any temporary table
    and call temp.table from any report writer

    Dec 10, 2009 | HP Compilers & Programming Tools

    1 Answer

    I cannot load some programmes. I get an error 429 activex component message., Is there a free vista available to run over the top to fix any or all problems i might have on my system


    cause : This issue can occur when DAO dynamic-link library (DLL) files are mismatched or when there are incorrect registry entries. This issue can also occur when there is a missing DAO design-time licensing key. This key is required by Microsoft Excel, but is not required by applications created with Visual Basic

    Method 1 loadTOCNode(2, 'resolution');
    1. Click Start, and then click Run.
    2. In the Open box, type regsvr.exe.
    3. Re-register DAO350.dll.

      NOTE: You can obtain a copy of DAO350.dll at the following FTP address: ftp://ftp.microsoft.com/softlib/mslfiles/ To register DAO350.dll, follow these steps:

      1. Click Start, and then click Run.
      2. In the Open box, type Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao350.dll
      3. Click OK.
    4. Click Start, point to Settings, and then click Control Panel.
    5. Click Add/Remove Programs.
    6. Insert your Microsoft Office 97 CD, and then click Uninstall.
    7. Delete the DAO folder from the hard drive.
    8. Click Start, point to Settings, and then click Control Panel.
    9. Click Add/Remove Programs.
    10. Insert your Office 97 CD, and then click Install.
    11. Repeat steps 4 through 6 to uninstall Office 97.
    12. Click Start, and then click Run.
    13. In the Open box, type eraser97.exe. (This file is also available at ftp://ftp.microsoft.com/softlib/mslfiles/.)
    14. Repeat steps 4 through 6.
    15. Repeat steps 8 through 10 to reinstall Office 97.
    Please Rate Solution!

    Sep 08, 2009 | Compilers & Programming Tools

    1 Answer

    Drawing in Visual Basic 6.0


    Hi - You cannot scan directly into VB6 unless you use a third-party control (OCX). You would need to get the data into a database table and use ADO, or, hard-code the data directly into your source code. You can actually grab it from Excel too but that involves automation programming - not hard to do - just more to learn. Have fun!

    May 12, 2009 | Microsoft Visual Basic Enterprise Edition...

    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

    Write into excel format


    You can use ADO or SQL to open the excel file directly (provided it is constructed correctly, ie fields names) and write the data to it without Access.
    That might be eaiser thatn converting it from Access to Excel, if that can even be done.

    Feb 17, 2009 | Microsoft Visual Basic 6.0 for PC

    1 Answer

    How to run matlab .m files from visual basic 6


    can you help me how to solve the videp basic problem in matlab?

    Jan 25, 2009 | Microsoft Visual Basic 6.0 for PC

    1 Answer

    Type mismatch in MSFlexGrid Control


    type mismatch error occours when there is a mismatch between the value which you are trying to assign to a variable which is dimensioned to store values of another, first you check if the datatypes match each other by applying the break.

    Dec 19, 2008 | Microsoft Visual Basic 6.0 for PC

    1 Answer

    How can i print datas from MSFlexGrid in VB6


    I hear a lot of people are asking that question. I am sure its possible.
    Try this:

    For i = 0 To Form1.MSFlexGrid1.Col
    For j = 0 To Form1.MSFlexGrid1.Row
    Print Form1.MSFlexGrid1.TextMatrix(i, j)
    Next j
    Next i

    That should move the data. I think. This isn't my best area; however, It doesn't hurt to try it right?

    Hope it helps.

    Nov 21, 2008 | Compilers & Programming Tools

    Not finding what you are looking for?

    Open Questions:

    0 Answers

    Hai everyone, I am doing a project on Attendance Monitoring. I have two tables one master table called student and another table called att to store students daily attendance. I have four comboboxes in my form, by selecting the city,area,centre and batch the respective students satisfying this condition has to be displayed in the grid apart from that i have to display another column to mark attendance. I am using datagrid and mark P for present and A for absent. When i finished marking the whole data has to be stored in att table with the current date. The next day again the same class may be selected with the next date and has to be stored again. The problem is i am not able to store each person attendance. Please help me in this regard. The att table contains fields like Code: Student_ID,Date,Attendance The student table contains fields like Code: Student_ID,City,Area,Centre,Batch,Name etc The code that i have written is like this Code: Public ac As New ADODB.Connection Public ar As New ADODB.RecordSet Private Sub Command1_Click() Set ar = ac.Execute("select student.Student_ID,att.Attendance from student,att where City = '" & Combo1.Text _ & "' AND Area = '" & Combo2.Text & "' AND Centre = '" & Combo3.Text & "' AND Batch = " & Combo4.Text & "") Dim count As Integer count = ar.RecordCount MsgBox count Set DataGrid1.DataSource = ar End Sub Private Sub Form_Load() ac.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:v-tablesStudent.mdb;Persist Security Info=False" ac.CursorLocation = adUseClient Combo1.AddItem ("CHENNAI") Combo1.AddItem ("BANGALORE") Combo2.AddItem ("GILL NAGAR") Combo2.AddItem ("CHOOLAIMEDU") Combo2.AddItem ("EGMORE") Combo2.AddItem ("SOWCARPET") Combo2.AddItem ("KOTTIVAKKAM") Combo2.AddItem ("KILPAUK") Combo2.AddItem ("MOGAPAIR") Combo3.AddItem ("RANGA NURSERY") Combo3.AddItem ("V-KIDS") Combo4.AddItem ("1") Combo4.AddItem ("2") End Sub

    Jun 27, 2009 | Microsoft Visual Basic Enterprise Edition...

    Microsoft Visual Basic Enterprise Edition 6.0 (361-00667) for PC Logo

    Related Topics:

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