VB Forum / Database Access / February 2007

This is code I created to add a record where the user inputs the new
text in textboxes:
  Private Sub btnAdd_Click(ByVal sender As Object, ByVal e As
System.EventArgs) Handles btnAdd.Click

I am not a VB6 programmer but I need to execute some changes to an existing
program.
My problem is evoking a storeprocedure with receives a datetime variable, I
send a Date but I always receive a Type Mismatch error

I am trying to validate the value entered in a text box with the value in
the database using ado.net by the click of the Check button. For eg: If
someone enters a domain name in the text box and they click the Check button,
I want to validate that value with the value in the ...

I am trying to validate the value entered in a text box with the value in
the database using ado.net by the click of the Check button. For eg: If
someone enters a domain name in the text box and they click the Check button,
I want to validate that value with the value in the ...

I didn't see a ADO board so I thought I would try this.  Sorry, if it's
wrong.
I setup a Access database (for various media) and I'm using a VB 6 ADO
control to access it.  I have an Artist, Album, and Tracks form in the

I have created a VBA application in PowerPoint that concludes with a
comma-delimited text string as output. I would like to place an ADO
command after that point that appends the data into an Access table.
MSFT help files are helpless in this particular area!

Is it possible to write an update uqery that would add/subtract to
selected records?
For example, I have selected ten items via select query, all with
different prices.  I want to add $15 to all ten of these prices.

I have migraged a VB6 system to Vista, upgrading the Access DB to Office
2007
A single copy of the code addresses 7 instances of the database all kept in
a common folder in C:\Program Files\BridgeResults\Databases. None of the

Our VB6 app uses ADO 2.7 to work with an Access database.  Although 90% of
the ado-related code continues to work fine when our app is installed on
Vista, any code where we bind controls to an ADO recordset fails (e.g, Set
Text1.DataSource = adoRS).  The controls just remain empty.

I have an existing project that is quite extensive and I wanted to
add
one more module, but in the module I use:  dim cn as new
ADODB.Connection

Hi,
When i run my program and go to my add new record page, i get runtime error
'3706'. I know it has something to do with the connection to the database but
everything i have tried has not worked. I am using VB6 with an access97

Select
'0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93 ...

I have an Access 2000 database.
I am connecting to it via web page through an aodb connection
****code snipped****
dim Cn

I'm trying to narrow down whether we have a problem in our ODBC
drivers.  One test script that checks field type is returning
different values between VB6 and VBscript.  Does anyone know whether
this behavior is common?  Is the does it gauge the difference between

I have code that adds, deletes, updates etc records.
But, I do not understand how to get a result of a function from an open
database.
I need to get the result of the MAX(column) into a VB6 variable but cannot