Thursday, October 9, 2014

Operasi ADODB Recordset Pada MS Access

www.AstroDigi.com AstroDigi.com | Kamis, 9 Okt 2014 | Dalam melakukan manipulasi data pada tabel pada MS Access, user bisa melakukan dengan 2 cara yaitu secara langsung ataupun tidak langsung.

Secara langsung berarti tinggal membuka tabel, dan lanjutkan dengan manipulasi data (Add, Edit, Delete). Secara tidak langsung biasanya menggunakan query atau recordset untuk mengisi data hasil penghitungan atau operasi logika kedalam tabel.

Khusus untuk manipulasi data yang "unbound" (tidak terikat dengan tabel), akan lebih fleksibel bila dilakukan dengan operasi recordset (buka tabel dan manipulasi dengan menggunakan coding).

Berikut ini adalah contoh operasi recordset pada tabel bernama "tabel_contoh" :

'-----------------------------
Dim isiData As ADODB.Recordset
Set isiData = New ADODB.Recordset
isiData.CursorLocation = adUseClient
isiData.Open "select * from tabel_contoh;", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
'-----------------------------
    With isiData
    .AddNew
    .Fields("IDcontoh") = dataID01
    .Fields("dataContoh") = data01
    .Update
    End With
'-----------------------------            
isiData.Close
Set isiData = Nothing
'-----------------------------

Contoh coding VBA diatas saya bagi dalam 3 blok, blok pertama untuk membuka tabel, blok kedua memanipulasi tabel, blok ketiga untuk menutup tabel.

Untuk operasi update dan delete, menurut saya masih lebih enak menggunakan query. Operasi recordset akan lebih cocok digunakan untuk penambahan data.

Akhir kata, semoga tips dan tutorial singkat diatas bermanfaat, selamat mencoba, have a nice day :-)

 www.AstroDigi.com (Nino Guevara Ruwano)

Comments :

15 comments to “Operasi ADODB Recordset Pada MS Access”

gucci shoes
tommy hilfiger outlet
nike running shoes
hermes belt
kansas city chiefs jerseys
air max 2015
the north face clearance
mizuno running
north face jackets
ralph lauren uk
philadelphia eagles jerseys
hermes birkin
atlanta falcons jersey
coach outlet
bottega veneta outlet
michael kors uk
mulberry uk
air jordan shoes
mulberry outlet
nike trainers
chanel handbags
tory burch outlet
dallas cowboys jersey
custom mlb jerseys
cheap football shirts
seattle seahawks jerseys
baltimore ravens jerseys
new york giants jerseys
kate spade outlet
golden state warriors jerseys
boston celtics jersey
air max 2014
the north face uk
christian louboutin uk
ugg boots
michael kors uk
nike air max uk
mbt shoes
chicago bulls jersey
san francisco 49ers jerseys
a chang 0609

Unknown said...
on 

2015-07-28song
ray ban sunglasses
true religion
ray ban outlet
replica watches rolex
polo ralph lauren uk
christian louboutin
mont blanc
pandora bracelets
louboutin femme
ed hardy uk
longchamp
ralph lauren pas cher
michael kors
michael kors
gucci borse
michael kors outlet online
ray bans
snapbacks hats
soccer jerseys for sale
abercrombie and fitch
toms outlet store
kate spade
michael kors uk outlet
nike pas cher
replica watches for sale
ed hardy uk clothing
ralph lauren uk sale
louis vuitton borse
ed hardy outlet
oakley sunglasses cheap
mont blanc pens
polo ralph lauren
toms shoes for women
cheap air max
chanel online shop

750unique said...
on 

ninest123 07.31
true religion jeans, oakley sunglasses, louboutin, michael kors outlet, michael kors outlet, coach outlet, longchamp outlet, tiffany jewelry, christian louboutin outlet, michael kors, kate spade outlet, prada handbags, ray ban sunglasses, gucci outlet, tiffany and co, replica watches, michael kors outlet, coach outlet, nike air max, polo ralph lauren outlet, louboutin shoes, ray ban sunglasses, tory burch outlet, michael kors outlet, jordan shoes, nike air max, oakley sunglasses, chanel handbags, coach purses, kate spade handbags, nike free, coach factory outlet, burberry, longchamp outlet, burberry outlet online, nike outlet, prada outlet, oakley sunglasses, polo ralph lauren outlet, longchamp, michael kors outlet, louboutin outlet

Unknown said...
on 

true religion outlet, mulberry, lacoste pas cher, true religion jeans, nike air max, new balance pas cher, abercrombie and fitch, lululemon, hermes, nike blazer, longchamp pas cher, air force, vans pas cher, michael kors, nike free run uk, north face, sac guess, nike air max, air jordan pas cher, burberry, converse pas cher, north face, louboutin pas cher, nike air max, nike free, vanessa bruno, ralph lauren pas cher, sac longchamp, michael kors, ralph lauren uk, ray ban uk, air max, hollister, oakley pas cher, michael kors, hogan, tn pas cher, hollister pas cher, ray ban pas cher, nike roshe run, true religion jeans, timberland

Unknown said...
on 

wedding dresses, soccer jerseys, nike roshe, abercrombie and fitch, iphone 6 cases, ferragamo shoes, reebok shoes, soccer shoes, ghd, asics running shoes, nike huarache, lululemon, vans shoes, instyler, nike roshe, oakley, insanity workout, p90x workout, mcm handbags, north face outlet, beats by dre, celine handbags, bottega veneta, baseball bats, north face outlet, longchamp, giuseppe zanotti, hollister, valentino shoes, new balance, nfl jerseys, hollister, jimmy choo shoes, babyliss, herve leger, mac cosmetics, birkin bag, timberland boots, chi flat iron, nike trainers, mont blanc, nike air max

Unknown said...
on 

swarovski, replica watches, toms shoes, ugg boots, supra shoes, marc jacobs, montre pas cher, links of london, thomas sabo, vans, hollister, ugg pas cher, ugg,ugg australia,ugg italia, nike air max, ray ban, ugg boots uk, ugg boots, ugg,uggs,uggs canada, karen millen, gucci, bottes ugg, lancel, uggs on sale, ralph lauren, hollister, converse, wedding dresses, pandora charms, louboutin, juicy couture outlet, converse outlet, juicy couture outlet, pandora charms, swarovski crystal, ugg boots, coach outlet, pandora jewelry, ugg boots
ninest123 07.31

Unknown said...
on 

polo ralph lauren, http://www.poloralphlauren.us.org/
celine outlet store, http://www.celineoutletus.com/
basketball shoes, http://www.basketballshoes.us.com/
pandora jewelry, http://www.pandorajewelryoutlet.us.com/
green bay packers jerseys, http://www.greenbaypackersjersey.us/
football shirts uk,soccer jerseys uk,cheap soccer jerseys uk
michael kors wallet, http://www.michaelkorswallet.net/
nba jerseys, http://www.nbajerseys.us.com/
oakley sunglasses, http://www.oakleysunglassesdiscount.us.com/
nike air force 1, http://www.airforce1.us.com/
north face jackets, http://www.thenorthfaceclearances.us.com/
oakley outlet online, http://www.oakleyoutlet.in.net/
hermes outlet online, http://www.hermesoutletstore.us.com/
oklahoma city thunder jerseys, http://www.thunderjerseystore.com/
mizuno running, http://www.mizunorunningshoes.us/
louboutin uk, http://www.christianlouboutinoutlet.org.uk/
ralph lauren polo shirts, http://www.poloralphlaurenshirts.us.com/
air jordan 13, http://www.airjordan13s.com/
michael kors outlet,michael kors outlet online,michael kors,kors outlet,michael kors handbags,michael kors outlet online sale,michael kors handbags clearance,michael kors purses,michaelkors.com,michael kors bags,michael kors shoes,michaelkors,cheap michael kors
dansko clogs, http://www.dansko-shoes.us/
the north face outlet, http://www.northface-outlet.cc/
the north face uk, http://www.thenorthfaces.org.uk/
kk0915

Unknown said...
on 

longchamp handbags, http://www.longchamphandbag.us.com/
nike air max shoes, http://www.nikeairmaxshoess.co.uk/
michael kors outlet store, http://www.michaelkorsoutlet-store.us.com/
toms outlet, http://www.tomsoutlet-stores.com/
cheap wedding dresses, http://www.cheap-weddingdresses.net/
soccer jerseys,cheap soccer jerseys,cheap soccer jerseys for sale,soccer jersey,usa soccer jersey,football jerseys
lululemon outlet, http://www.lululemonoutletstore.in.net/
beats headphones, http://www.beats-headphones.in.net/
mont blanc, http://www.montblancpensoutlets.com/
fred perry polo, http://www.fredperrypoloshirts.com/
nike mercurial, http://www.nikemercurial.org/
cheap michael kors handbags, http://www.cheapmichaelkorshandbag.in.net/
louis vuitton outlet online, http://www.louisvuitton.in.net/
ysl outlet store, http://www.ysloutletonline.com/
kobe bryant store, http://www.kobebryantshoes.in.net/
longchamp bags, http://www.longchamphandbag.us.com/
bottega veneta outlet, http://www.bottegaveneta-outlet.net/
washington redskins jerseys, http://www.washingtonredskinsjersey.com/
rolex watches, http://www.rolexwatches.in.net/
giuseppe zanotti sale, http://www.giuseppe-zanotti-outlet.org/
mm0917

mmjiaxin said...
on 

20151116xiaodaige
oakley canada
toms outlet store
canada goose coats
michael kors outlet online
canada goose jackets
mont blanc pens
coach outlet store
winter coats
air jordan 11
abercrombie and fitch
mac cosmetics
denver broncos
christian louboutin shoes
coach outlet store
louis vuitton handbags
rolex watches,rolex watches,swiss watches,watches for men,watches for women,omega watches,replica watches,rolex watches for sale,rolex replica,rolex watch,cartier watches,rolex submariner,fake rolex,rolex replica watches,replica rolex
air jordan 13
golden state warriors
snow boots
nike roshe
michael kors factory store
los angeles clippers
michael kors handbags sale
pandora outlet
michael kors handbags clearance
prada outlet
louis vuitton outlet store
mlb jerseys
nike mercurial
puma outlet
ray ban outlet
camisetas futbol baratas
moncler outlet
lacoste pas cher
designer handbags,handbags outlet,cheap handbags,purses and handbags,wholesale handbags,designer bags,bags outlet,handbags wholesale,cheap purses,discount handbags,handbags sale,wholesale purses,handbags and purses,designer purses
michael kors outlet online

Unknown said...
on 

marc jacobs
nike foamposite
vans shoes
calvin klein outlet
ralph lauren outlet
michael kors outlet online
swarovski crystal
ferragamo outlet
cheap nike shoes
michael kors handbags sale
oakley,occhiali oakley,oakley italia,oakley occhiali,oakley sunglasses
moncler outlet store
the north face outlet
michael kors factory online
ralph lauren uk
nike air max
asics,asics israel,asics shoes,asics running shoes,asics israel,asics gel,asics running,asics gel nimbus,asics gel kayano
longchamp outlet
michael kors wallet sale
michael kors outlet
mm1203

mmjiaxin said...
on 

2016-05-30keyun
michael kors outlet online
michael kors outlet online
michael kors outlet clearance
louis vuitton handbags
toms shoes
louis vuitton bags
louis vuitton purses
michael kors handbags
louis vuitton bags
coach outlet clearance
michael kors outlet
michael kors bags
louis vuitton outlet online
giuseppe zanotti outlet
michael kors outlet online
michael kors handbags
gucci handbags
coach outlet
supra footwear
louis vuitton purses
supra shoes
oakley sunglasses
coach factory outlet
hollister clothing store
timberland boots
coach outlet store online clearances
louis vuitton bags
nfl jerseys wholesale
louboutin shoes
nike store
nike free 5.0
louis vuitton outlet
cheap ray ban sunglasses
air jordan 4
michael kors purses
polo ralph lauren outlet
michael kors handbags
nike sb dunks
cheap ray ban sunglasses

柯云 said...
on 

kobe sneakers
air jordan shoes
coach outlet online
cheap oakley sunglasses
ralph lauren uk
yeezy boost 350
kobe byrant shoes
air jordan retro
michael kors outlet online
http://www.oakley-sunglass.in.net
nike huarache
adidas nmd
michael kors handbags outlet
louis vuitton handbags
tiffany and co
toms outlet
christian louboutin shoes

Anonymous said...
on 

michael kors outlet
michael kors handbags
cheap michael kors handbags
michael kors handbags clearance
nike outlet store
nike store
jordan shoes
nike trainers
michael kors outlet
michael kors handbags

raybanoutlet001 said...
on 

kate spade
michael kors outlet online
tory burch sale
birkenstock sale
ysl outlet store
cheap oakley sunglasses
pandora charms sale clearanc
uggs
canada goose parka
polo ralph lauren outlet
20161114yuanyuan

John said...
on 

eagles jerseys
cheap jordan shoes
coach outlet store
jets jersey
san francisco 49ers jerseys
ralph lauren outlet online
michael kors uk
canada goose jackets
omega watches for sale
ed hardy

Unknown said...
on 

Post a Comment