VB Forum / Database Access / August 2006

I am programming a form that will allow a data entry operator to key in
data into our database.  I am trying to control what the person actually
keys into a table.  I have two combo boxes that contain information from
two different tables in our database.  1st is the ...

I began deveoping using a pre-defined DSN based on the MS Access Driver.  It
was suggested to me earlier this month that I change over to the Jet OLEDB
provider instead (Access driver getting old and all).  However I have found
that using JET with a simple Connection String, ...

I open a recordset in my VB app. If a user changes the data in the database
(Access) how can I get a
callback to be notified of the change? I never receive the
RecordsetChangeComplete event?

I'm trying to load the data from an access db into a combo box, and this
error is display when the table is empty:
No value given for one or more required parameters.
When I try to debug the error appears in this line:

    CSV header conating "." dot and after loading it into dataset its
converting into "#" LIKE. First.Name First # Name waiting for your
reply

I have a treeview control allowing me to allocate school classes to a
program of study using Drag and Drop.  (Deep Thanks to Mark J McGinty!)
Instead of relocating the treeview node in the control (by reassigning the
dragged node's parent property), I capture the details of the ...

I am using ADO RS as a datasource for a MSHFLEXGRID object in a VB6
project.
When I loop through columns of the Grid, i get the error : "subscript
out of range"

Using Access 2003 as a development database in a VB project, I have some
strange results with ActualSize.
I had populate a table (tblHTTP) with some dynamic field (strCache). Those
fields could be over 512 chars so I define strCache as TEXT (SQL) or MEMO

I have an application that return a large amount of data into a grid
(500.000 record). The grid shows 20 records. Is possible to obtain the first
20 records and show them when the grid opens and the other records in
asincronous mode?

i can't find the connection string (and the def of the options) to
access a flat file from SQL Server 2005.
I guess it is something like:
Provider=Microsoft.Jet.OLEDB.4.0; Data Source=MyFlatFile; Extended

I am using the following routine to compact and repair a database but i get
an error message saying
Cannot start your application. The workgroup information file is missing or
opened exclusively by another user.

Would appreciate some assistance in modufying the select statement so I can
add a null value to a date/time field in an access database using an iif
statement.
..."INSERT INTO SLATE (s_Date) VALUES (s_Date = #" & IIf(TextReturn.Text =

I created a dll control which utilizes (among other things) ADO recordsets.
The control properly reads the database catalog and can pull an empty
recordset, but when passing records to a listform (seperate form with a
gridview - as Friend) within the control, no records are ...

I need to create the following table, however when I try to set the reference
column to Autoincrement I get problems. Also I am unsure how to add a primary
key oran index. All he exmaples seem to fail
   If pbUseMicrosoftAccess Then

i've reach a very strange sql server hung up when executing the following
code. I modified a table with an alter table, the sql server locks the table
with SCH-M and it hung up whe using a locktype greater than
ADODB.LockTypeEnum.adLockReadOnly when making a select to that table ...