VB Forum / VB Syntax / November 2003

This may be really simple but its driving me mad.
I've added several combo boxes to my form.
Im using setting 2 to display a fixed list of choices from
which the user can select one. This stops the user

With vb6, access97 is there an SQL statement that would
eliminate any duplicate records from one column of data or
do I need to write some code to pull out each record and
compare it to the rest of the column? Let's say column1

My VB program uses an export process to send data from a
database to an Excel spreadsheet, and I require the output
to begin on the first blank row it occurs.
Is there a quick way to determine the first blank row in a

Are there any math functions in VB6 that work specifically
with arrays?  I have an array loaded with double precision
values and I would like to find the Max, Min, Standard
deviation, Mean, etc.  What is the best way to handle

I get a compile error ,"Invalid Qualifier", on the word SubItems in the
below code.
The listview is multiselect.  I need to find out which items are selected
and what is the third subitem of each.

Are there any math functions in VB6 that work specifically
with arrays?  I have an array loaded with double precision
values and I would like to find the Max, Min, Standard
deviation, Mean, etc.  What is the best way to handle

With this code I can delete the recent line which was drawed.
How do I do to delete the line that is just became the most recent line
by pressing command2 again and so on?
Thanx

I can easily use the dir function to get all the files in
a particular directory on a drive.  But how do I easily
get ALL the files in ALL the directories on a selected
drive?

I am trying to set a variable in one vb6 application to a form in a second
application.
Want to access the form's controls collection to get the value of a label
control.

I am looking at more syntax and cannot find a answer for.  -day() What is the - mean in -day()

I've got the following two statements inside a class method which is
internal to an EXE.
App.LogEvent "BEGIN SQL: " & sSQLCommand
...

Is there a way in VB6 to trap an event when the user
cancels an application via Task Manager?
I just want to write to a log file "OS Terminated Job" or
something like that.

I need to write several Visual Basic program that perform standard file
input/output processing with no user interface. How do you code a basic
batch program using MS/VB. Is this possible? Could someone point in the
right direction .

I am trying to use FileCopy to copy selected files to the
floppy drive. I keep getting "Run Time error 70:
Permission denied". I have looked up the meaning if this
and generally MS states that you cannot use the FileCopy

I am looking for a more elegant way to sequence counters.  
I have ascii data files (serialized reports) being created
on two computers at irregular intervals (Computers A and
B).  The data files have to be combined into a single