Access table from form

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

Guest

I have a form which i use to create data .... but i want to create a
recordset (ADO) then insert it into a table in the access database. I dont
see any way to reference a table in the current access database. Is it
possible?
 
from Rainbow01 Hong Kong

are you suitable to use UpdateQuery?
eg. DAO--->CurrentDb.Execute "SQL statement"
ADO--->CurrentProject.Excute "SQL statement"

"Michael Dawson" 來函：
 
Yeah. ... i have actually found some more info since i started this thread,
and hadnt seen Execute yet. Execute procedure would probably suffice, but i
would still like to deal with asnc type recordsets, if anyone wishes to
supply that sort of info i would really like that.

Thank you very much Rainbow01 :-)
 
Back
Top