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

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:

1 Answer

Do you have a formula in Microsoft Excel that a value can convert to a word...(Ex. 15,000 then it will convert to in words fifteen Thousand..)thanks. need immediate reply.


Hi enelrah_mel0,

You can create a function called SpellNumber using the Visual Basic Editor in the Microsoft Excel to spell the number.

  1. Please Open Microsoft Excel. Then press Alt + F11 to open the Visual Basic Editor.
  2. Then, click "Insert" option above the Visual Basic Editor window and select "Module".
  3. Then, in the Book1 Module1 (Code) window, paste the below code there. (pasted in the next post separately for your convenience)
  4. Then, press Alt+Q to close the Visual Basic Editor window.
  5. After that, please type the formula " =SpellNumber( * )" in the Excel Sheet and press the Enter Key.
  6. Then, save the Excel Sheet.
eg: =SpellNumber(A1)

Where A1 is the first cell in the excel sheet.


Good Luck!

Please post back the result and let me know if you require further assistance.

Thanks for using Fixya.

Oct 29, 2010 | IBM ThinkPad T30 2366 Notebook

1 Answer

How to make tally charts on my laptop?


To create a tally chart in a laptop,the laptop must a spreadsheet package like Microsoft excel

these are the steps involve
-select the data to be use for graph.include the column and row label in sections
-select data
-click on number tab
-click on text
-click ok
-click on chart wizard icon on the tool bar
or
click on insert on menu bar
click on standard tab or custom types tab
under chart type list ,click to select the desire chart type eg tally.
under chart sub -type list,click to select the chart desire.
click on next button.
click on data range tab under series to select rows or columns.
click on next button.
that solve it.I hope you"ll find the solution post useful,dont forget to leave your comment by saying hope hopeful this post is to you

Oct 07, 2010 | Computers & Internet

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 Computers & Internet

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

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

How do i use date in visual basic 6


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.

Mar 06, 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

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

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

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:

580 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18384 Answers

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

Answer questions

Manuals & User Guides

Loading...