VB Forum / Database Access / April 2004

anyone know how to get SQL queries to use a variable that's declared when a
form is loaded?
WHERE "tblStoreAddress.fldStoreName = "variablehere"

I am writting an app that uses three combo boxes to collect
parameters from a user. I am using the parameters in an sql statement
"where" clause
to filter the results.

I'm maintaining a legacy VB6/Access 2000 business application. While our .NET/SQL Server migration is in development, I am considering converting the existing application to use SQL Server to buy some more time. The application is a data consolidation and reporting tool using DAO ...

Hi,
 My question is simple and im sure it has been asked hundreds of
times, but i cant find any of these previous posts, so here it goes.
I am wanting to write an App in VB to use a MDB back end. I have had

I have a SQL 2000 stored procedure which builds a XML document using "FOR XML EXPLICIT". I can run the stored procedure directly from IE, and the results are fine. Now, if I use ADODB.Recordset to execute the stored procedure, the resulting recordset is not returned formated as ...

We have a VB6 application that opens several forms that use adodb recordsets
getting data from SQL Server. Many use Infragistics data grids.
All the recordsets are set to nothing when the form is unloaded.
The problem is that the memory usage increases with every form opening with

I was running MDAC 2.71 .. and have a VB 6.0 app that writes a crystal
report file to a SQL Server 2000 database (SP3).
I recently I upgraded MDAC to 2.8
My client has mdac 2.8 and my install kept displaying messages about old

are there any examples of the correct way to use commit tran in
a stored procedure  and then
set an output parameter with the result
in this example rs does is not a valid object - but the record is commite

Hi!!
Im facing some different kind of problem with my code. Im using
MSHFlexgrid in my project when Im trying to set DataSource Property it is
giving the error "Object Variable or with block variable not set"

I am using SQL Server2000. my question is what the different between
Stored Procedure and user defined function? I find user defined function
can't add some output parameter, SP can return recordset, Is it the all
difference?

Can anyone help me with the code to delete multiple rows using DBGrid.
Maybe using shift select or Ctrl?
Thanks

I have a report in Access that has fields that are populated automaticly
from a database.  
The report gets called when a command button in VB is pressed.
The problem is that it prints the report for every record in the database

I am using an ADO object to access a FoxPro table (DBF file).
The problem is when I insert new records in the table, the indexs of
the table are not reajusted. I expect that I must recreate or rebuild
the indexs but neither drop index and create index queries work.

I got some data problem with a software in VB6 that write in a access97
Database.
The software use DAO binded controls. Sometimes (randomly) when creating
records, I find some bad values in some fields like "<èÿ~$< ". It seem to be

I have an image stored in a database table which I wish to display on
a VB form.
My first attempt at the code is
   Dim cn As ADODB.Connection