doubts regarding SQL queries for oracle tables linked in MS access

[shandoo27]

Hi,

I have till now used MS access tables for database and thus peacefully used Dlookup for selecting a particular column value and insert and delete and update for row modifications.

Now I am going to destroy these tables and link my MS access forms to oracle database. I would like to make the specified modifications to the VBA code of the buttons .

1. Is dlookup also applicable to Oracle or should i write a select SQL command. If so how to retrieve just a column value using SELECT command and assign it to a text box. ( Problem here is that the SQL when run returns a record set not just a single variant.

2. What modifications should i do before i execute a SQL command for insert delete and update. could you please give the syntax for connecting to oracle database.

thanks in advance for the help provided.

 

[namliam]

1. DLookup is acceptable ONLY and ONLY in exceptional situations, where you only need 1 value one time from 1 table with no inter depencies.
Storing you recordset into a recordset value and retrieving the values is the way to go.
Using it goes something along the lines of:
dim rs as dao.recordset
Set RS = currentdb.openrecordset("Select...")
Me.YourText = rs!YourColumnName
rs.close
set RS = nothing

2.
You use an odbc connection, google will help you far faster and better than I can.