VB Forum / Database Access / February 2005

i m developing application in vb 6 and sql server 7.
in my Customertable there r almost 700-800 records. i want to add all
these records in list box. i use getstring method of ado to get that
string in that i pass vbcrlf and also chr(13) function to seperate row but

I couldn't figure this one out:
my app lets users select records, that are displayed in a datagrid
They can then choose to delete the whole current selection.
i tried rs.delete, but that gave me an error.

I am using VB6.0 and trying to improve on the performance of some data being
retrieved.
The SQL looks like this:
SELECT * FROM tblTransaction WHERE CustomerId = 66 ORDER BY TransactionDate

Is it possible to read the structure of a query in SQL server, modify it and
then rewrite it back to the SQL Server under a different name?
I figure that I can write the query under a new name using a sql Create
command and ExecuteNonQuery, but how do I read the original structure ...

Hi, I'm doing a project in VB.Net and I need some help with it.
I have 2 forms on form 1 i have a combobox that is linked to a sql
server database it displays the customer name. Form 2 is a customer
details form that displays all the information about the customer.

Heya,
I am working on making a SQL database an exact mirror of a local
Access database. I check the .mdb database every few minutes for new
entries, if there are new entries, I retrieve them and write them to

     I have created a MS Access database with some hyperlink fields, my
problem is, I am having a trouble on how to display those hyperlink fields
and make it work into the VB6 Datagrid. Please help me with this.
Thanks in advance,

I would like to know how to force pagebreak in a datareport for example
after 5 records printed.
Thank you all

 I have a complex query that I hope I can explain it well enough for
everyone to understand.
 I have a table that contains information for work instructions.
Contained in the table are "MACHINE_PROC" these are groupings of

i've got an access table called 'submission_info', and in that table i've
got fields with names of people, and addresses. i want to show a list of
papers from a specific country. e.g. China.
this is what i've strung together so far;

In the code below i have an updatable ado-recordset. However it is not
working how i thought it would be.
Maybe someone can help me out here?
The global connection (Thanks to Brendan):

I have been accessing a database on a local drive thru an ADO connection.
The following is the code that I have been using.
cnCejco.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=Y:\Cejco.mdb;Persist Security Info=False"

I am writing a program using VB6 as a front end to a SQL2000 Database.  What
I want to do is to be able to drap emails from outlook over the program then
be able to save them in the database.  Any help would be great.
Thanks

Does anyone know how (or whether it is possible) to add a column to an
existing key for a column using ADOX?
pseudo code:
Dim cn as ADODB.Connection

This only happens on one PC (cannot recreate it on others), so I'm sure
it's something specific to the system, but I'm not sure what.
When this person tries to run my VB6 program (after successful
install), he first gets this message: