VB Forum / VB Syntax / April 2004

Hi, I am having a problem with getting Shell() to work in vb6. I want to click on a button and then run an .exe file that converts a unix.txt file into a dos.txt file
This is the cod
Private Sub Command1_Click(
Dim strDoIt As Strin

I have the following line of code for a criteria statement when opening a form
currentAppt = ("AppointmentID= " & Me.AppointmentID) & Me.LSNeeded >
The report opens without regard to the above criteria statement. How can I open the report only when there is a match
on ...

I was wondering if anyone had any idea of how to use a control like text box to display text in different colors instead of one uniform color.  I'd like to have certain words be blue, lets say, and the rest be black.

Some programmers like to change the Tab Width and their code is difficult to further support by the other programmers (with have standard 4 characters tab).
So, how to change the Tab Width to the standard one (4) for already written code
What simple decisions can someone suggest? ...

Such as "if... then" or other VB keyword and each keyword's description,
I think this is a way to learn VB's syntax, anybody could give me such a list file?
thanks:)

I have a question that I can't find the answer to concerning freezing cells
in Excel from my VB6 app.
My app exports a sizable chunk of data to an Excel spreadsheet, (Excel 2003
and 2002).

I have to confess I get all my Word VB Syntax from the Word Macro Generator.
The following routine writes a word document. It runs once ok and then when
repeated halts on the second instruction under 'Table formating.
The Error Message is  Run Type Error 42 The remote server does ...

.

   i am working with an application in vb6 that uses an ActiveX control
(drag drop). the activex control listens for telephony events. i make
multiple instances (objects) of the form for different modems that are there
in my system. the form created last listens for the events only ...

I have a compiled C file that I would like to execute when a user presses a Command Button from within a MS document. Anyone know the VB syntax?

Reading its Index property leads to the error 'The control is not an array' when the control is not an array
How to correctly check without turning to the Index prop
The IsArray function does not help.
Thanks in advance.

I am trying to write some custom code for a client to export a table into a text file that is pipe delimited.  He does not ant to manually use the wizard and so I am trying to by-pass this.  I have the transfertext method of the DoCmd but the help file is not at all clear on what ...

Is there any function in VB like "SizeOf()" in C/C++ ?
Best
Kevin Tang ( kevintang@ieee.org )

I don't know if I am in the right news group, so I will apologise now if I
am
I am using excel and I want to filter down data automatically
i can do this in excel if i write approx 6000 formulas (few to many)

We are working in VB6 with Windows 2000. We wish to launch an
application when a PC comes out of the hibernate state, something
equivalent to Run and RunOnce type of registry keys that gets
triggered when Windows is restarted.