VB Forum / Database Access / October 2004

hi myself avinash ,a programmer
i am using vb as front end , ADO library and sql server 7 as back end
i want  to copy records from one table to another table and i dont want to
use do while or while loop bcaz it takes too much time to execute.

I have a search form which loads names and addresses and other info, all
thsi info is held in a disconnected database so that when a record is
selected it can then update another form with the selected information. When
I then update the form and save it I want to the be able to ...

What is the right command to delete a selected item in a listview?
Thanks
IAK

I am trying to write a small program using VB6 SP5 to remove selections of
data from one MS Access database and store it in another.
I've tried several methods
by Programing

I know there's a way to attach to an asp page and step through my code, i
just don't know how to do it.  Does anyone know how to debug asp using the
script editor?
Thanks!

List:
I'm using (mostly) DAO methods to manage a Jet 3.x database.
I need to copy a table from one database to another.
The databases exist in different workspaces.

I was wondering what commands I would need to use to get the time (in
minutes) to display in a label untill say 12 pm, what commands would I
need to use? I have been expermenting around, would i need a DTP?

Visual Basic front-end, Access 2000 backend
I  found that once a client machine has accessed a datareport (created in
Visual Basic) , slowness begins. (Most transactions that would normally take
6 or less seconds, now are 30-40 seconds or more).  The .ldb file for the

Help Please,
    I'm using VB6 with SQL Server 2000 SP3a.  I can't figure out why this
code aborts to the error handler at execute.  I've changed different things
and read till my eyes are bleeding.  This is embedded in a class module.

Ok....I'm just a novice in VB but... it's seems imposible to me that I can
do nothing with ListView...
I'm tryin to create a form in which i have put  a listview.
I would like to select from the entire recordset only few records after a

I am a professional vb software developer, i develop software in tradiotnal
way, i often listen and read in various forums and books about Client /
Server  and Disconnected , but i still unaware with these techniques and
their benifits, can any one of you guide me each of them

Can someone please give me a hand? I have a stored procedure which I
want to pass some parameters. In other parts of my code, I just set a
string variable to "Execute spname var1, var2, etc..." and then run
the sql cmd. From what I've read so far, it seems that if I want the

Hi! ... I send you my cordial regards, I'm looking for a sugestion about a
situation, using the component ADO (adodc), "Microsoft ADO data control".
Once upon a time, I finished my database aplication using VB6. The
connection strings points to my local hard drive C:\ .... When I ...

I have built a simple form with a listbox some textboxes and a datagrid.
I have connected the form to the db with ADO.
It works fine during the form loading during all the classical operation
"Move Next, Move first,...etcetc...(code omitted)

I have SP in SQL Server:
CREATE PROCEDURE Admin_BuySellCompanyInsertUpdate
@CompanyName varchar(50)
@Address1 varchar(50),