VB Forum / Database Access / November 2005

I need help with a sql update query using adodc data control in vb 6
sp6 with ms access 2002.
I have two text boxes: namei and spaceno1
table = gas_bill

       This is one thing on which im repending for
guys i have developed application but just a smaller one in which i
didnt bothered to follow the basics
Result

I have successfully been using an ADO stream to upload local files to a web
server through a vb6 interface, but i would like to be able to check the
existance of a file on that webserver before uploading (it doesn't even have
to be one file in particular - if ANY files exist, i ...

I am very familiar with VBA programming in Access, but am writing my first
VB6 app.  (We are not using .NET because the rest of the app is written in
VB6.)  I have two questions.
1. The target machine will not have Access installed.  Is it recommended to

I have some SQL that I can run successfully in Query Analyzer against a
remote SQLServer 2000 (sp3a) database.
However, when I run the exact same SQL using ADO (2.8) in VB6 (sp6) (on XP
sp2) as the source for an ADODB.Recordset, I get the following error:

I have an ADO recordset (rs1) in memory and want to run a query off of
it, creating a new ADO Recordset (rs2) containing a subset of the
records from the original ADO Recordset (rs1).  Would anyone be kind
enough to provide a small code snippit in VB which would allow me to

My VB6.0 app suddenly has problem accessing an Access97 database. The error
is "Method or data member not found!"
I even reinstalled VB 6.0 but still didn't help!
Any help is greatly appreciated!

I have a number of CSV File with a number of fields 2 of them are a phone
number, and a Hex formated number ie: 2105555555,3FF65515
These files are delivered via an automated process, and I need to parse
them.  Now, with some of the files, it processes them correctly, however on

I'm currently using adodc for my program.
Usually adodc is setup using adodc properties.
In properties I setup :
1. the driver (I'm using MS SQL)

   I have to read a text file, a csv file but it not works. Voila the
source code:
Dim oConn As New ADODB.Connection
Dim oRs As New ADODB.Recordset

I'm trying to forge ahead with Visual Basic .Net but recently I've suffered
several major set backs in demonstrating VB is the future and we should move
from Visual FoxPro.
I really need to find help on this is.  My current problem is I've got to

I execute a VB function stored in an Access Database from a VB6
Application :
Public Function RunFunction(Index As Integer) As Integer
      Dim A As Object

What is the most efficient way to update Qty inhand in a multiuser
environment .(VB6-MS Access)
Scenario:
1.Batch No.  implimentation for products not possible.

Here's code that uses DoEvents to ensure that a keyboard-initiated
abort signal can be received within a processor intensive loop. But I'm
getting intermittent problems on some machines, specifically "Error 91:
Object variable or With block variable not set". Just as strange, these

i have Access 2002 website based ,
i am trying to execute query that using replace() function ,
and i ger error message :
"Undefined function 'REPLACE' in expression "