VB Forum / Database Access / September 2007

I'm trying to make the following action in VB6 environment development:
create a link to some tables with ODBC.
I explain more:
1. In access, i'm goig on "table" section

I'm trying to make a linktable to a table in Oracle DB 10g by MS Access VBA
on the following environment.
- OracleDB 10g R2
- MS Access 2003 SP2

in my application I use a DataRepeater Control to show RecordLists.
Now I search a way to get the value of a Textbox in the DataRepeater
Control. The only thing I found until now is the Number of the current
record. Is there any way to get Values of the selected record?

i'm in final yr in electronic engineering majoring in computer...
my final project is to build database using VB..
the problem is I really dont have any ideas on how to do so..
so,i really2 need some helps..

im looking for a tool to learn sql, i've found GalaXQL
http://sol.gfxile.net/galaxql.html
is it any good to learn sql language or should i try something else?
Amy Dalton

I use this SQL string to create a column in a MsAccess database from VB:
CON.Execute ("ALTER TABLE Stocks ADD column BoutiquePrice DECIMAL(18,2)
NULL")
But I got this error:

Does anyone have SIMPLE instructions on how to create a connection string to
an Oracle database?  Our application already talks to Access and Sql Server
but we are being asked to do Oracle as well.
Thanks,

I'm creating VB6 DataEntry program and I need to show the description of a
field. I use a SQLServer 2000 database and defined a table there and filled
out a description for each field. Now I want my VB program to get that
description and show it on screen.

I need to modify a BIFF2 class to be compatible with BIFF5, and add extra
functions to add new worksheets to a workbook. I'm looking for a new class
file which already has the calls to create a new workbook, add worksheets,
and add information into the worksheets. It doesn't have ...

OK I have a new project created... only two components on the form
1) Data Control - no changes to any property settings.
Connect=Access2000
2) Label with datasource=data1 and datafield = Item_Desc (field in my

I am in the process of changing an app from DAO to ADO data controls.
The following used to work in the DAO version of the app
   'Originally Worked with DAO -
    Search$ = "' '&[Spell_Word]&' '&[Use_In_Sentence]&' ' LIKE '*" &