VB Forum / General / August 2005

could you pls give a simple example of how to read from a excel file that
have two columns and some rows and plot the values to a chart in a worksheet.
Thanks guys.

Is there some way I can display some text in the top row of an
MSFlexgrid such that it spans across several columns? Like so:

I just wonder if anyone can tell me the usage of Keep Together in
datareport.
I want to keep from Group Header, Details to Group Footer together.
For e.g., the forth record, if the Total Amount and Remarks cannot be

Heres one i am trying to think of the best way of doing.  I have a text file
that I want to read and parse.  Only problem is there are a varible number
of spaces between the text.  I am looking at fill in a datagrid with this...
file looks like

could someone please tell me or refer me to a nice resource on how to do
multithreading?  I was told it existed in vb6.0.  And some advices on how to
avoid race condition?  And also, is there way to write for 64bit codes?
Thanks.

I would like to recode the file mapping API functions in VB6.  The MSDN
lists them:
-CreateFileForMapping    
-CreateFileMapping    

How can you do a dir for files with a space ?
For example: I have files called "PPP 20050802.txt", "PPP 20050801.txt",
etc.
When I do Dir("PPP 200508*.txt"), it returns null.

Hi i want some help here.
I want an example about the code of
FindFirst to find a record in a form that
using records of an access database.

   I have an problem in using Timer control .
   I have 2 option button control the form and 2 timer control.
   When 1st option button is selected , 1st timer control is enabled.
   And when user select 2nd option button , the 1st timer control still

Hello --
We need to synchronize 7 DataGrids so they scroll together when the user
scrolls through one of them.
For viewing and maintaining the table PriceList, we want an array of

  I have Oracle Database installed in the different computer .
  My question is how to use ADO object to connect to Oracle DB ?
  Is my code below correct ? Do i need to specify IP address of the
Oracle Database ?

I have a VB 6 timeclock app that records the clock punches made by
employees. Each punch is automatically assigned a "TransactionID" by VB and
is set as the primary key.
I allow the store supervisor to edit the clock punches. When a punch is

Im relatively new to VB but learning fast.
I would like to have custom command buttons on my forms.
What is the best way to acheive this.
At the moment Ive just done a little test using my current knowlege, where I

We want to be able to loop though 64 checkboxes in code, and set/reset their
checked status.  Is there a way to address the checkboxes by some kind of an
index?  We can't use the name as a variable.  Can we?
Thanks.

Here's my first post. I read much on DoEvents(), and could not find the
answer to this. I use DoEvents during some long loops in my program,
and I found if TWO loops call DoEvents at the same time, neither loop
ever exits!