VB Forum / Database Access / July 2007

I have a large Access db linked with Visual Basic. Its purpose
is to calculate company profit margins for the gypsum industry.
Thus, in my program resides a calculation process which
is executed by the click of a command button. The command button

I'm beating my head against the wall trying to do something that should be
fairly simple, I just can't figure out how to make it happen. I have a
routine that uses 2 recordsets from a SQL table. The first gets a unique
list of each field in the table and the seconds takes that ...

I'm testing the below code with Sql Server 2005 and ODBC:
Private Sub TestSqlServer2005()
   Dim cnn As New ADODB.Connection
   cnn.ConnectionString = "Provider=MSDASQL.1;" & _

Wondered if you could help.
I have 2 tables of data like so:
PUPILS
PID    PNAME

Hello, I'm having fits trying to use the SHAPE sql statement command.  I am
using this:
strSQL = "SHAPE {SELECT IDCUST, NAMECUST FROM ARCUS WHERE AMTBALDUEH<>0} "
'& _

Is it possible to call an ACCESS macro from a VB6 program ?
Could you give me some example ?
Thanks in advance.

Could you please help me in the following issue i am facing...
i have a listbox which display the search result...now what i want is
if i have selected a wrong search criteria or if the search is too
long. i want to stop the search...the search could be taking time

I would like to be able to redirect a dataset "binding" from one database to
another during runtime. The database makeup will be identical, but the
actual files will be located in different folders, depending on current
projects.

I've tried to use the MS Chart com for what I thought was a simple
requirement, but I'm just completely dumb-founded by it.  It may be that I'm
asking too much of it, but I just can't get the result I want.
If will explain my requirements as follows and see if I am asking for

I haven't used "arrays" as such at all in my db programming, so please
excuse this rather simple question.
I have a table containing records from 2 populations of data. The data is
identical except for a particular comparison method that is used for the

Hi - I'm trying to teach myself VB, so if the code looks really wrong that's
why. feel free to laugh out loud.
I'm using Access 2003, I'm trying to use mutiple Recordsets to get data from
queries. Each Recordset uses the same ADOB.Connection, the Connection is

when i want to compile a program that is white vb.net and it connect
to access database
white connection of oledb whit code ,
it has warnning that sayes exception in system.oledb

I'm having difficulty getting this Disconnect event to fire.  I have
WillConnect and ConnectComplete event subs which fire as expected when
the connection is opened, but the Disconnect sub is never entered.
I've anyone tell me what I've done wrong?  I've tried this against two

we have one realy strange problem with VB6 and data-environment.
We define some global Recordset in our form and fill that recordset on
FormLoad.
Afterwards we use the same function of our DataEnvironment to fill

I am new to VB2005, but have used VB6 for a few years.
I have a simple web form in an asp.net project consisting of a DropDownList
and a TextBox.
I have managed to set a datasource for the DropDownList so that it will