VB Forum / Database Access / June 2004

Group:
I am getting a runtime error that says "Data type mismatch in criteria
expression." The error is with the following line:
    oRS.Open sSQL, oConn, adOpenForwardOnly, adLockReadOnly, adCmdText

i have problem when reading data from database (MS SQL 2000) when the field
is empty or null value... it stops my code and says "Invalid use od null
values"
then i created small if then and it still stops at the same place

Please help an aging and not-quite so agile brain. I've looked through MSDN
and Googled the planet.
I have a very simple structure and want to get full records for distinct
combinations of various fields. I just don't know the correct syntax. If

I am converting an RDO app to ADO.
Please can anyone tell me if there is an equivalent property in ADODB.Connection (or elsewhere) to RDO.Connection.hDbc?  In the code it is used as a parameter to the ODBC32.DLL function SQLSetConnectOption.
TIA
Paul

I have code that looks like below.
I get this error:   Run-time error -2147217904 (80040e10)   No value given
for one or more required parameters.
I know it is in the CMD string that is wrong.  Can anyone help.

Thank you in advance for any and all assistance. This is my fourth attempt to
get a straight answer.
I have a program form that I would like to display images from the file folder:
C:\Program Files\NEKennel\Images. The Application directory (app.path) is:

I am migrating a project designed using VB6 and mdb to Oracle 8i or 9i. I
would like to know the best way for VB6 to connect to Oracle. The first
option I can think of is to use OleDB provider from MDAC, but is this the
best option? I don't want to use a buggy driver.

I have never done any programing whatsoever and my boss
has given a problem to fix in visual basic. I need to
figure out how I can  set up a field to sort multiple
instances of a last name... by those (with that last

Is there a way to programmatically export an Access database table into
an csv or MS Excel file in Visual Basic 6.0 please?
Any useful API out there?

I'm converting a VB6 DAO project to ADO that talks to an Access database.  I
find that when I close the application that the locks remain and the .ldb
file stays and is not deletable.  I'm using .close for the recordsets
although I may have missed one or two.  But in the Form.Unload ...

I'm going to develop no of One - Many  Details forms..
1. Which is the best to use for Details capturing - Data Grid or Ms Flex
Grid.
2. In the Details i should be able to use the List Box or Combo Box.

I have strange problem.
I have opened a DBF database and i cant update it.
When i perform simple operation
rs![NR] = "2222"

any gru can tell me the connection string to open a secure access 2000
database file..
I am using the following one but getting error..
Dim cn As Connection

I have tried several different methods of getting this done but none
have worked. Here is the very small section of code that I cannot get to
work.
Function Item_Open()

I'm writing a small database app in VB6.  I'm not using the Data
control, instead I'm using unbound controls and doing all the database
access myself.
Everything is working great but I'd like my navigation controls to