VB Forum / Database Access / February 2004

H
How can i pass a argument through variable to data object for retrieving data
Thanks

I'm using VB6 and ADO 2.6 to talk to an .mdb file created with Access 2000.
When I'm doing working with the database I need to compact it so I'm trying
to use the CompactDatabase command.
My DAO reference is set to DAO 3.6. The code is:

I have one user of my VB6 app who is unable to create an ADODB.Connection.
Any attempt to create the connection (via "Set oDB = New ADODB.Connection",
or "Set oDB =CreateObject("ADODB.Connection")" ) results in error 429 -
"Automation Error - The specified procedure could not be

I need a FAST way to put my sqlDataReader result set into an string
array. I have one Row and 21 columns. I need to put the values into an
Array quicker than I am doing it right now. The Pseudo for how I am
doing it looks like this:

The following is a test Sub that accesses a stored procedure that returns a
recordset.
How do I get the RecordCount of the records returned in the recordset?
The: "lngRecs = rstTags.RecordCount" line of code returns -1

The post that I found below works on windows forms but does not work
with ASPX pages. How do you modify the code I have provided to get
data fed from a SQL connection (taken care of by another function)
with an Image field to a Image web control? Thanks in advance!

When I run the code shown below, I can't get a proper record count. Instead, I get a record count of -1. Can someone tell me what syntax I need to retrieve a proper record count? Thanks - Ron
Dim MyConnection as New ADODB.Connection
Dim MyRecordset as New ADODB.Recordset

I can't figure out how to display the record that is found using the "Find" function of recordsets
Here is what I have in my search click event when the combo box value is "Submitter". The rest is just repetitive code in each IF with the different options in the combo box. I guess ...

I'm working on a project for a client using VB 6.0 for the front-end
file & SQL Server 2000 (MSDE) for the back-end file.  There are only
2-3 users that will be using the application, so the MSDE version of
SQL Server should work out just fine.

After banging my head against a wall I have been able to partially resolve
my problem of returning a recordset and a record count from my SQL server.
I changed my StoredProcedure to return the record count however, I have to
make two calls to the server in order to get both the ...

since i use access 2000 i reffrenced my project to dao 3.6
library, but when i do this i can't get help from msdn for
method and properties of the database (and records)
How can i have the msdn help for 3.6 objects?

Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim cmd As New ADODB.Command
cn.Open "Provider=SQLOLEDB.1;Data Source=serv-w;User ID=sa;" _

If I use the ADO data control on a form and at run time I want to set
the connection string (for example specify the path via code to an MS
access .MDB file) how can I do that?
I tried setting the connectionstring property during the form load

I have a recordset which I am printing. Some fields are empty and the
printer prints "NULL". I want it to print"" - nothing at all!
Help
Thanks

H
I have got a Stored Procedure on a SQL server that runs a query and write the data to a table and a DTS package to export the data to excel. I did a VB6.0 app that excecute the DTS etc etc
What I would like to do is to allow the user to pass some parameters to that query in the ...