VB Forum / Enterprise Development / May 2005

I'm being a good VBee and I'm using a Let sub to call the same form from 2
other forms to show different variable data depending on the ID that I send
to the Let.  My only problem is, how do I retrieve the status of the sending
form so that my generic 'Go Back' can take the user ...

In essence I have 2 arrays.  One array contains 6 (0 - 5) random integer
values ranging from 1 to 10 and the other array (same 0 -5 range) is used in
a loop to flag all of the integers that are above 7, eg:
array 1 consists of:

Hello again.  I am having a problem with VB and a run
time error.  The error says "'Run-time error 3170':  
Could not find installable ISAM."  I am trying to link an
excel file and a access database and for some reason I

How can I know which database it is currently?
What is the query to find all the tables in the database?
Madhivanan

I get this message by simply call a form_load in the IDE Debug.
Works fine in the executable?
frmPreference.Show vbModal, Me
any ideas?

Is there a way to test connectivity to a SQL SERVER on another machine
without using "On Error resume next" then checking length of
err.description?
asking because if it cant even access the remote host through SQL SERVER it

I have a VB Script that will open an instance of IE and write various
information to the IE window during the execution of the login script.  
After the login script exits I have the script wait 30 sec. prior to closing
the IE window, so users can see the output if needed and read ...

I have Visual Basic 5 and I am trying to learn Visual Basic 6.
I am reading "Visual Basic 6 Unleased Professiona lReference Edition"
published by SAMS.
This code does not compile.

How do i assingn a Build number to a version?
I need Version 1.0.0.1001
Where 1001 is the build number
-Lou

I've created this app that extracts data from 1 table in an SQL DB.  The
connection and extraction works fine, its just a problem of doing loops
correctly that is causing me some grief.
In essence, the person who created the DB had an app in another IDE that

This might sound simple, but I'm stumped.
In essence I have a 2 form app that connects to an SQL db and extracts info
from it.  This works fine.  The problem is with my 2nd form.
The 'run through' is that the user can select an inv no from a combo box on