VB Forum / General / October 2004

JUst upgraded from VB6 to VB.NET
Where as before I would have
      Dim cnN As Connection
      cnn.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &

Free Music Point of Sale Retailer www.netstair.com/download/bcis 

Is there a way to print a list of modules in a project?
tod

Any help on this would be appreciated cos its driving me insane.
I have a function in VB.NET that takes in an excel range and tries to
delete rows where the first column starts with a string. Only it
doesnt work and all i get is "Delete method of Range class failed"

I have a VB6 app with several Access databases.  These dbs will likely be
stored on a network.  I have corresponding .udl links on the local PC which
will point to the location of the databases.
Question...how do I programically...set the .udl to point to the installed

Hi, can anyone help?
Two questions really:
i) Is there any way of timing out a workbook.open command? (Some workbooks
on my system don't seem to respond to the command [in fact they do the same

I am looking for a code snippet that would allow me to browse to and select
a folder.  I am currently using some code that uses
   Declare Function SHGetPathFromIDList Lib "shell32.dll" Alias
"SHGetPathFromIDListA" (ByVal pidl As Long, ByVal pszPath As String) As Long

Anyone know how to get a scroll wheel to work in the VB 6 SP3 IDE?  I've had
it working on one workstation but not another. Dell Optical mouse
Thanks,
Tom

Is it possible to store arrays in property prpcedures inVBA (specifically
Excel 2002) like it is possible to do in VB.NET?  I tried this post in the
excel.discussion group but haven't had any luck.  I'm hoping some of you
dotnetters will have tried this in VBA.

I am trying to build a small application in VB which emails out an auto-gen
email populated with the recipient, subject, and body I specify through combo
or textboxes.
If my system is running Outlook 2003, what is the best way to compose and

I've been using a product from Rainbow Technologies to prevent multiple
installations of my app.  However, the process is cumbersome and expensive
(several thousand a year).
Does anyone have a suggestion on code or inexpensive software I can use

Im using VB6 to return values in an SQL 2000 table and get the following
error:
Error in ScrollBox.refresh
Maximum row count of 50389 exceeded

I was wondering if there was a way to add text in a footer format to any
page that is printed from the computer.   The program would have to be able
to do both local and network printers, I am assuming you could do both no
matter what.

I have a vb6 program to connect database and query some information.
I also have a Cancel button in the form.  If user click the Cancel
button, the program should stop doing connecting database or querying
information.  Is there a way to force the program to stop?

   I made a VB6 program on my WinXP. Il like to install it on an old pc
with win95. What file should a add to win 95 to run my program.
Thank you