VB Forum / General / November 2004

I have a grid with First Name, Last Name, Address, City, State, Zip.  There
are about 1500 records.  I would like to be able to start typing the Last
Name and depending on how many characters I type, go to the record that
matches what I type.  I was thinking of using KeyPress to ...

I tried searching google for "count character" and "count characters" and
"count characters in string" and didn't find any discussions except for
references to Len(sStringVar)
purpose: count number of occurances of sCharToCount in string sSource

In a Validate event for a VB6 textbox I would like to check a naming
convention that allows for a either a two character prefix or the absence of
the prefix.  In other words, the pattern should match an optional "C_"
prefix before the remainder of the string.  Can someone help me ...

What is the best way to read rows and columns out of excel and transfer them
to a flexgrid.
The rows and columns will be different for different excel files read in.
Any suggestions.

I have the need to manually set the Created and Modified properties of files
programmatically.
Any ideas?

I originally posted this to the vb.ole.automation group, but by the end of
the day, I didn't see any activity in the group...so I'll try here.  PNK
----------------
I need to add a function to an existing VB6 app to print a mailing label on

I am using VB6 and ASP  as my development tools (old as me)
I have two question actually.
1.  How to write a function with return value which is an array of a varible
a self-defined type

i would like to create data access class that i could use throughout my vb6
and access applications.  i would like to be able to switch between DAO and
ADO type databases.
My plan is to have an Interface that has the methods and properties that i

I have a file which contains the following text.
ECHO OFF
REM PL16045.BAT #161915 RATE CHANGE EFF 12/15/04                
REM PL16045.BAT #153842 SIZE FACTOR EFF 12/15/04              

What I need is a generic HTML file viewer to plug into my VB application,
but not the IE or Netscape.
What is it?

I'm trying to modernize some code and came to a long routine
that has about two dozen nested If-Then's in it. Using my
non-Politically-Correct style, I had it laid out like this:
If Not Boogy1 Then GoTo ExitThisSub

I need to pass through a directory and select the files with a creation date
after a specified point.
There are 1000s of files so passing through them all checking the date and
time will be a bit cumbersome.

How?
GIGAMAIL by X-Privat: http://www.x-privat.org/gigamail.php

In VB6, I have added a reference for Excel.  How do I open a specific Excel
workbook in order to add new data, all in code.  I do NOT want the Excel
workbook to be displayed on the screen (or even in minimized format) during
the data add process.

We have an old legacy database program, and one of the reports is about 600
characters long per line (text file).  I wrote a simple VB program that
reads the file and breaks the fixed length file at the 310 mark.  On a 11x17
landscape paper, it works as needed; however, I have to ...