Bls: [belajar-access] Belajar recordset

bisa hasil query di jadikan recordset ,
cara nya
dim db as database
dim rst as recordset
dim qrytest as querydeff

set db=currentdb()
set qrytest =db.querydefs("qryabc")
set rst=qrytest.openrecordset

atau

set db=currentdb()
set qrytest =db.querydefs("qryabc")
qrytest.paramter(0)=me.txt1
set rst=qrytest.openrecordset

kalo mau readonly

 set db=currentdb()
set qrytest =db.querydefs("qryabc")
qrytest.paramter(0)=me.txt1
set rst=qrytest.openrecordsett(dbOpenSnapshot, dbReadOnly, dbReadOnly)

Best regard
Erwin Sugiawan

---

Dari: Sofyan Efendi <sofyanefendi@gmail.com>
Kepada: belajar-access@yahoogroups.com
Terkirim: Sen, 18 Oktober, 2010 10:01:28
Judul: Re: [belajar-access] Belajar recordset

Kalau action query setahu saya tidak bisa dijadikan recordset, hanya select query saja (plus kriteria), mohon koreksi ya bila saya salah, ....

 

Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi.
http://opi.110mb.com/

----- Original Message -----

From: Bambang Mahfudin

To: belajar-access@yahoogroups.com

Sent: Monday, October 18, 2010 8:24 AM

Subject: [belajar-access] Belajar recordset

 

Bapak moderator dan accessers...

Saya baru baca2 PDF sebuah buku dg judul 'Access2003VBAProgrammersReference'
Pada bab 6 dibahas tentang 'DAO'. Ada penjelasan yg menarik bagi saya,
kalau tidak salah begini :

Ternyata recordset bisa dijadikan kriteria sebuah query select

Kemudian timbul pertanyaan:
Apakah bisa recordset dijadikan kriteria query update/append/delete

Kalau jawabannya 'bisa' mohon referensi link/ ilustrasi coding sederhana

Terima kasih
BambangMahfudin

__._,_.___

SPAM IS PROHIBITED

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___