VB Forum / Database Access / July 2004

We have a app installed at 100+ sites and one of them keeps getting error 91
object variable not set.
The app is VB6 connecting to Access DB via DAO. The database seems ok and
there was no errors during install.

using vb.net and mssql2000
Imports System.Data.SqlClient
Connecting fine.
Create a database fine.

What is the custom format to avoid to print Zeros
Ex.
I Get this:
Day                Tim         Ana         Peter

I have a problem displaying images on a form. The situation is a follows:
There is a folder containing cd-covers. I want to display them on a form.
Each time I open the form the folder must be scanned to check which
cd-labels are present.

I am maikng one database in MS Access and I need to make a button in form
which button will create a folder on a hard drive with name of primary key
of that record. In this way i would create folders for each record and store
related documents for that record in seperate folder  ...

Does anyone know where I can find example code for VB.NET that I can use
to create an application that attaches and detaches databases to MSDE using
osql scipts.
(I think SQL-DMO is typically used)

   How can I delete a record without requery and restart from record 1?
I'm a newbie to ADO and SQL.
   I have a ADO recordset bind to a form and a toolbar for moving around
the recordset, not using grid, just plain textbox.

I've run into an interesting problem.
For some reason when I try to insert a record into a SQL table that has a
Text column, the returned autogenerated Identity is wrong.  This only occurs
if the length of the value inserted for the text column is >= 8002.

I've run into an interesting problem.
For some reason when I try to insert a record into a SQL table that has a
Text column, the returned autogenerated Identity is wrong.  This only occurs
if the length of the value inserted for the text column is >= 8002.

I have a table with a field that contains the priority number
of a question. How can I change these fields when one of them
has been changed?
Example:

On a rs.movenext I get this error:
Runtime error -2147467259 (80004005): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Which is quite strange because:
- I can access the first ...

i have a problem... when i execute an insert or update or whatever, long
time operation on a
database located at a distance my application freeze, not at all, only when
i want to move the window,

I'm having problems with an ADO connection to a folder that has an
apostrophe in it.  The connection works fine if the paht doesn't have
an apostorphe but if the folder contains one I get an error.  I've
tried replacing the "'" with "''" that works with fields and values

I'm new to using the adodc control.  I am trying to link to a sql server table to view and update records.  I can view the records, but have been unsuccessful in updating them.  Is there a property on the adodc that needs to be set for me to be able to update records?