VB Forum / General / November 2004

I have written an application which connects to an FTP site to send /
receive files. I need the FTP details such as the address and
username/password to be protected therefore I have hard coded them into the
program (they are unlikely to change). The problem is when I open the ...

Is there any way to get hundredths or even thousandths of seconds out of a
VB6 Format statement for the time?  If not, is it possible any other way?
If so, how?

I got this error messge with my VB6 generated application
Run-Time error '6':
Overflow
I could not point out any precise origin of the bug, and I suspect the

I am trying to handle errors associated with opening an Excel workbook in VB.
My error handler works if the workbook I want to open doesn't exist. However,
if the workbook is already open at some other location by another person, no
error trap occurs. How can I detect a "file ...

I'm looking for a way to program in VB6 to set the browser to open word
and excel docs inside the browser.  I know that I can set it manually
from inside windows explorer.  I need to implement the change on many
computers; and so I?m looking for a way to make a simple executable ...

I needed to un-install and re-install VS6.0 so I can work in an old VB6 app.
I have a new machine (new since September) where I first installed winXP
Pro, all windows updates, VS6, SQL Server 2k, and then VS 2003.  The reason
I'm re-installing vs6 is because I couldn't get the help ...

Could someone point me to a good place to research VB/ADO error numbers.
Example
-2147189544
I did the microsoft and google and found nothing.

I've read numerous posts here saying sp6 was a disaster.
I haven't seen anything recently, just wondering if it is still to be
avoided - or if they possibly fixed whatever the issues were?
I guess for now I'll just do sp5 to be on the safe side.

I currently have a product written in VB using SQL 2000 as the backend.  In
order to license this, I have an encrypted stored procedure with a hardcoded
number of users allowed.  The program simply checks the number of users
logged in to the database against this number in the ...

Looking for code to get Date/Time from Remote Windows 2000 computer.  Any
assistance appreciated.

Ok. I'll confess, I've been doing things in an undesirable way for a very
long time.  Instead of using an 'identity column' to automatically create a
unique value for a row in a table, I've done these steps:
1. Query the table to find the max value stored in a (unique but not

Our servers have a SOE that includes VB Runtime V6.0 SP6.
The developers are using VB with SP5. MSI's are created for installation on
these servers and they never include Microsoft or other common components.
What are some of the issues that are likely to cause problems in this

I would like to know if there is any way to display a form within another
form in VB6.
Let me explain what we're trying to do:
In our application we want to display the same functionality (UI wise) in 2

I migrated from NT4 sp6a to XP sp1 and to a much faster CPU.  However, the
startup time of my project within VB's IDE got much slower.  It takes about
90 seconds for my project to get to the first line of code when pressing F8.
This is after it has already compiled.  I have Compile ...

How can I check if printer queue is empty.
Below is the sample of my code:
Private Sub PrintDoc(sFileName as String, rst As ADODB.Recordset)
   Dim objWord As Word.Application