VB Forum / General / March 2006

I am using the following code to pull some data from a SQL Server table.  
I need to know how to fin dout the # of rows that were returned.  Thanks
With cn1
       .Provider = "SQLOLEDB.1"

I have a combo box on my form that when I change the value, the Change event
never fires.  Could someone please explain to me how this works?  I've read
the help files and it seems like I'm doing it right.
Basically, what I want to do is when a certain combo box is changed, run

Please be kind as I'm new to VB 6.  I've created an VB 6 ActiveX control
that will be deployed to our corporate Intranet. We have lots of vendor
applications that rely on VB 6 runtime dlls. How do I distribute the
control without creating dll incompatibilities?  The set of VB 6 ...

I would like the output of my code to start in "A1" and either store
data laterally "B1", "C1" etc or vertically i.e. "A2", "A3" etc etc.
could someone help me with the relevant command?

I was wondering if there is a command to extract a specific string from
a sentence.
Let's say, I have the following sentence:
"One two three four five six seven eight"

Could you help me please to find out how to read the harddisk serial
number in java ?
Thanks a lot!!

greetings pros,
im wondering how can i send an email via outlook using vb6 without prompting
the Outlook's confirmation window?  or is there any way?
thanks in advannce,

Does anyone have any code to unlock a keyboard?  
I have code to lock a keyboard which I can do at the end of a program,
however for it to work I need to unlock the keyboard at the beginning of the
program as it has keyboard events in it - it does not run if the keyboard is

Need better way to save and load an array of types.
Private Type tStuff
 tStuffName as String
 tStuffAddress as string

If you are reading a field from a database in a loop and then adding the
value in the field to a variable, how do you test that the value is not
null before adding it?  This code gives a type mismatch error :
if rs("FixedGP") <> "" then

I just ran across a shortcut key in the VB6 IDE that many of you may know,
but was new to me.  When modifying a control property in the design window,
select the control so it has focus.  Now, to quickly go to that control's
desired property in the Properties Window, press [Ctl] ...

Does anyone know if this company is in business?  They removed their
phone number from their website and using the one in the phone book
always goes to the same voicemail that is never returned.
I'm in desperate need of some support from them.

Hallo everybody. I have a problem in VB6: i want to find a file, having as
output the normal visualization of WIN.
In VB I wrote:
Private Sub Command1_Click()

I am trying to schedule a macro that makes some cosmetic changes to all
open excel workbooks and the saves each of them under a slightly
diferent file name.  My code works well when I open the macros
manually.  However, I want to schedule a few files to run each day.

I am using the following RAPI version RemoteCE 0.1.0.3.
I have made a connection using Rapi but how do I copy a file to a target
directory to the handheld using Rapi.
I am trying to have some function that can be called once Rapi is intailized