VB Forum / Database Access / August 2004

My application uses several datagrids.
Looking on the internet, i found an excellent free(!) printing module
on www.adit.co.uk
Unfortunately this module only works with the plain Flexgrid (and not

I want to sum 300,000 records for one year data for each client out of
800,000 records (Total 08 years data) from Sql Server Database.
I have two tables, one is master and other is detail.
Here is the code I want to run in VB-6, but its taking too much time to run

I have a class using SQL DMO called ClassSQL
Here's the sub I'm having problems with (as far as implementation goes):
Public Sub CreateUser(strLogin As String, strRole As String)
 SQLUser.Login = strLogin

How can i rename a SQL Server database using VB6? Is it possible?
Any help is appreciated. (code, tips, links, articles, etc.)
Jonathan

I am trying to insert records to a single Foxpro .dbf file from Visual
Basic 6.  On a Windows 2003 Server machine it works fine both through
the VB IDE and as a compiled dll.  On a XP Pro machine it works fine
through the VB IDE, but not as a compiled dll.  Both machines have

I wished to develop a vb6.0 app to connect to an access
db (.mdb file).
Could someone please give me an overview with the
following in mind:-

I am trying to compact an Access database in VB 6.0 using code for jro.  
I found the right code, but I get "could not find installable ISAM" when I execute.
I'm seeing articles that indicate I have a dll not correctly entered in Windows registry.
I am not comfortable with changing ...

I'm a new learner to VB 6.0. I creeated a program  on VB run some test
and have the data save into a predesigned data sheet that was created
on MS Word.
After developing, I made an executable file for the program. And

If I run a bulk select query in VB-6 using Sql Server Database, is it
possible to start filling and display the initial records in grid, while
query is still running, same like Sql Server Query Analyzer, instead of wait
for the query to run completely and then fill the MSHFlexGrid.

Hi, folks.
I've been wrestling with this for MONTHS! I have a VB6 SP5 app hitting a SQL2k database. The app has never made it past the first test user, as she continues to have problems...
Here's what happens in a nutshell:
All connections and recordsets are handled via code (no ...

I have used SQL to sort out the data that I want and show it in the
datagrid. Now, I want to export those data to excel, what is the code
about?
Furthermore, I want to display the information in a more organized

Does anyone know of a way to copy all the data from recordset and dump it to
another recordset, without iterating through each row in the recordset?
Thanks In Advance
Gunner

I have an app that accesses FoxPro tables that belong to another
application. From my app, I open a connection to foxpro then open a
recordset to one of the tables and perform updates. After the updates are
done, I close the recordset and set it to nothing. Then I close the

I'm using ADO in VB6 to work with an SQLServer 2000 DB. I'm opening
recordsets Asyncronously and then processing the returned data in the
_ExecuteComplete event.
The queries are initiated by the receipt of data from a barcode

This somehow goes against hierarchical recordsets but I like to fabricate a
disconnected hierarchical recordset with the main recordset having 1 date
column and 5 child recordsets. The children are not related to each other
and not even to the parent. But I would like to do this so ...