VB Forum / Database Access / June 2004

I used the following sql statement in an ADO connection to an Oracle
database, however I received "the query has not been properly closed". Any
advise on what the problem is?
SELECT H.id, H.x, H.y, H.insert_date

I used the vbDataform Wizard to create a Master detail from. The form desplays fine, however, im trying to refine it slightly.  This form is part of a project that already has a 'trusted connection ' to a SQL server, and rather that make a new connection ech time this form is ...

Hi,
I used to have a Wizard installed with VB6 that automatically set up
code for using a given procedure in a database.
"Stored Procedure Wizard"

Well I have a question
How can I make a selection from table from a X database and create a table
with this result in a Y database?
Help! please!

I am using vb5 to control my database and use the following code:
(This is all of the database related code for the application)
I only need to be able to change the text boxes listed and have the
alterations saved.

I want to take record from table of two different database and save it into the third database of similar structured database's table

I am using VB6 to read some data, can somebody show me how to read data inside the Microsoft Access table using ADO connection and place the result in the Microsoft Excel text box
Regard
Leo

When I run the code below I get an error message of : "Compile error: invalid outside procedure
Below I'm trying to open an Access 2003 database. Why do I get this erro
Dim Cnxn As ADODB.Connectio
strCnxn = "Provider=Microsoft.Jet.OLEDB.4.0" & ";Data Source=" & "C:\TravelandStop.mdb

Hi all, I'm trying to load two fields from a table into a listview - I
have the following code in the form's load event and it's deadly slow
popping up.  What's the best way to populate a listview with table
columns?  Thanks.

i've got a Fox Pro tabela an d I would like to creat a new field in that
table, but I can't find that option.
i've got Mircosoft Visul Studio 6.0
Help me, please

Hi, I am looking for a way to get the DSN data from windows ODBC Data
Source. How can I pop up the ODBC Datasource windows and retrieve the data
from one of the DSN which is selected.
Cheers

   How to write the function of Edit,Update and delete though ODBC in the vb?
Many Thx!

Hi al
I am having some difficulty at the moment and I'm not quit sure if this is the right group to ask. I have so far connected to a sql database and queried the database for information on a certain month. I have also populated the resulting data in Excel. What I need now is the ...

I'm building a database application with a Visual Basic 6.0 frontend and an Access database using ADO
As a security measure, I'd like to make sure that users can only access the database through the frontend. To achieve that, I've put the DB in a folder that can only be accessed ...

I am looking for help working around null values in
an update routine.
My form provides users the opportunity to supply values
for some fields which may not be available at data entry time.