VB Forum / Database Access / April 2005

I have a combobox  which lists Keywords.
When a button is clicked, the application adds the data - via DAO - to the
mdb file. I then populate the list box with the updated list by clearing the
list box and re populating it via DAO.

I assign a variable in Form1, like this:
public jType as string
If optD.Value = True Then
jType = "D"

I posted a question about how to handle the error when my recordset returns
zero row on March 23.  
And I was suggested with the solution:
If rs.EOF = False

I am trying to gather information from a selection of records selected by a
SQL string and can't figure out how to do it.
My SQL =  "Select * from MAIN Where Curve_ID=123456"
Then I need to be able to read a field ("Test_ID") from each record whose

I am using VB6 and SQL server 2000.
From my application I can update and insert the backend SQL server using
Stored Procedures just fine.  When I try to use a delete SP it always times
out.  I thought it was the SP but it also times out using hardcoded SQL

Hello --
We currently have a multiple web server farms that have approx. 5 servers
per farm.  We run third party applications on these servers that install
multiple modules for various components.  There are literally 40+

Dim MyMail
Set MyMail = Server.CreateObject("CDO.Message")
MyMail.From = "justme@myaddress.com"
MyMail.To = "friend1@address1.com;friend2@address2.com"

whow can i connect with sql server

I am looking for the most efficient solution for this problem.
I have two tables, Products and Scales, with a common field, ScaleID.
From the Scales table I need the value in the Name field (there are
approximately 50 records in the Scales table).

I have used recordsets quite a bit to hold the results of SELECT
statements and then added records with that recordset.
I would like to be able to build a recordset just for inserting w/o
ever using a SELECT statement.  Can that be done?  If so, can you tell

Hopefully someone can give me a hand with this, I've run out of ideas
to fix this error and I haven't found much info online regarding the
issue.
I have a procedure that runs through a listview and for each row in the

I know it is not the right place to go but I am learning DAO (always been
afraid to learn it as I am giving up bound data controls)
I am having a problem with the MovePrevious and MoveNext using DAO
Here is the code segments.

List:
Are there any good references for optimizing my queries?
Most of them are simple, but a few are real doozies.
Thanks

In VB.NET,
I made a connection to a database, created a data adapter(daOleDB1) and
dataset (DsTransaction.xsd and *.vb)
I have no idea how to export some columns' value to text file. I tried

bueno la cuestion es que tengo una base de datos en la cual aparecen unos
determinados importes
necesito que en un textbox aparezca la suma de las cantidades de una de las
columnas de la consulta,