Plz tell me, how to read data from table using VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI
I have a table named as "optable", like this:
+--------+--------+
| option | value |
+--------+--------+
| opt1 | 1 |
| opt2 | 0 |
+--------+--------+
Plz, write a example code howto change data in table using VBA. Main trouble
is in to read data from table using SQL-query. VBA code is a standart event
for the button click
 
I want to read the data as easy as posible... Simply i write data to table in
my database using DoCmd.RunSQL(myquery)... I want same easy to read data from
tables using SQL too ...... Simply my table is contain options for making my
form and queries .....
 
Back
Top