VB Forum / Database Access / November 2003

I'm curious to know if anyone has any experience with using RAISERROR from
within their SQL Server stored procedures and somehow trapping the error and
message from within a VB application.
When an ADO control is used to execute a stored procedure and there is an

I developed a VB application which kicks off a DTS
package.  It worked perfectly in Test, but when the .exe
was moved to a different machine they got the following
error...

I'm looking for a means to detect if a particular System
DSN exists, detect by name.
Any help is appreciated,
Dean

I have made a small component (dll) which imports data
from an Excel File to SQL SERVER...
I invoke this component through an asp program. There are
about 60K records in the Excel file and i am able to

hello helpers
tempComp-recordset, sqlComp-string, strComp-string
i wrote
sqlComp="select *from tbl where compType=" & strComp

I declair
dim db as database
dim cust as recordset
Sub form_load()

A dumb question, I'm sure, but should a (VB) program that's being used
on a network by a number of users have only one program on the server that
everyone uses, or should each work station have its own copy of the
program?

I am using VB 6 and connecting to an access database via odbc, and am having
problems using the ALTER TABLE statement to add a hyperlink field to a
table.
The SQL is

I am working on something that pulls up information out of a client table
when I select that client on a combo box. What line can I use to get that
displayed? Essentially now I am using:
Dim NewOrderClient As DataRow =

Hello -- I have a ListView on my form that displays records in a particular
order for how they should be displayed or executed, such as
1(A)-2(B)-3(C)-4(D), etc.  I would like to have an Up/Down control below the
ListView so users can hilight a particular row in the listview, and ...

I have this stored procedure:
CREATE PROC sp_Invoice
@Vendor Char (4) = '%'
AS

I am looking for a dependable way to apply filter on a recordset to set
number of records=0. In other words I need to apply a filter, which makes
rst.eof and rst.bof both equal to true. Additional important requirement -
it should be generic procedure, which means recordset's schema ...

I have a ListView control on my form that has a rows of data with a number
of subitems().
Currently, when I select a row, only the first column cell hilights.
How do I make it so the entire row highlights when a row is selected?

Can someone please tell me the best way to populate the MSFlexGrid control
when using unbound ADO controls.
I have a few books on the subject, and cannot seem to get it to function as
expected.

I know how to return a list of the TABLES in a jet database using DAO
and VB but how can I return a list of the FORMS from a jet database?
the MySysAccessObjects id field returns the number of objects in the
database but know name reference. Any ideas? Thanks