Saturday, April 12, 2014

VBA untuk Menghapus Tabel

www.AstroDigi.com AstroDigi.com | sabtu, 12 Apr 2014 | Seorang siswa dalam kelas pelatihan MSAccess pernah menanyakan bagaimana cara untuk menghapus tabel? Sebelum menjawabnya saya lebih dahulu menanyakan apakah ingin menghapus record didalam tabel atau menghapus (menghilangkan) tabelnya?

Siswa saya menjawab bahwa ia ingin mengetahui bagaimana cara menghapus record dan juga bagaimana menghapus tabelnya. Jadi ia ingin mengetahui kedua cara tersebut dilakukan dengan menggunakan perintah VBA.

'Untuk menghapus ISI/RECORD tabel:

DoCmd.RunSQL "DELETE namaTabel.* FROM namaTabel"

'-----------------------------------
'Untuk menghapus (menghilangkan) tabel dari database:
'Cara 1

DoCmd.DeleteObject acTable, "namaTabel"

'-----------------------------------
'Cara 2

Dim cdb As DAO.Database
Set cdb = CurrentDb
cdb.Execute "DROP TABLE namaTabel", dbFailOnError

'-----------------------------------
'Cara 3

Dim cdb As DAO.Database
Set cdb = CurrentDb
cdb.TableDefs.Delete "namaTabel"
'-----------------------------------

Silahkan pilih VBA script mana yang sesuai dengan kebutuhan. Selamat mencoba  . . . Have a nice day :-)


 www.AstroDigi.com (Nino Guevara Ruwano)

Comments :

14 comments to “VBA untuk Menghapus Tabel”

hollister, north face outlet, michael kors, montre pas cher, nike air max, beats by dre, rolex watches, soccer shoes, ugg boots, nike free, burberry, hermes, ghd, vans, herve leger, ferragamo shoes, yoga pants, mulberry, reebok outlet, supra shoes, oakley pas cher, lancel, abercrombie and fitch, karen millen, louis vuitton, asics, jimmy choo, new balance shoes, converse shoes, juicy couture outlet, mcm handbags, marc jacobs, hogan, chi flat iron, nfl jerseys, p90x, ralph lauren, birkin bag, valentino, timberland, air max, louis vuitton, lululemon, soccer jerseys, bottega, ray ban pas cher, insanity, celine handbags, wedding dresses, mont blanc

Coach Factory said...
on 

oakley sunglasses cheap, moncler, cheap sunglasses, ray ban, moncler outlet, ralph lauren, oakley sunglasses outlet, canada goose, louboutin, oakley sunglasses outlet, cheap oakley sunglasses, oakley sunglasses cheap, oakley vault, moncler, ugg, cheap sunglasses, cheap sunglasses, ugg boots, oakley vault, cheap oakley sunglasses, moncler, cheap oakley sunglasses, oakley vault, oakley outlet, oakley sunglasses outlet, cheap sunglasses, oakley sunglasses cheap, tn pas cher, oakley sunglasses outlet, oakley vault, ugg boots, oakley outlet, canada goose, oakley sunglasses cheap, gucci, canada goose, oakley vault, canada goose outlet, canada goose, canada goose outlet, cheap oakley sunglasses, cheap oakley sunglasses, oakley outlet, oakley sunglasses cheap, oakley, cheap sunglasses, oakley sunglasses outlet, oakley outlet

Coach Factory said...
on 

tiffany and co, oakley sunglasses, nike air max, michael kors outlet, louboutin, air max, coach factory, true religion outlet, michael kors, polo ralph lauren, kate spade outlet, true religion, coach factory outlet, prada handbags, nike shoes, oakley sunglasses, gucci outlet, tory burch outlet, air max, ray ban sunglasses, louis vuitton, oakley sunglasses, air jordan, nike free, louis vuitton outlet online, oakley sunglasses, coach outlet, louis vuitton handbags, coach outlet store, chanel handbags, michael kors, ralph lauren, true religion jeans, coach purses, longchamp outlet, michael kors outlet, ray ban sunglasses, polo ralph lauren outlet, louboutin, burberry outlet online, ray ban, oakley sunglasses, nike air max, nike free, toms shoes, burberry outlet online, prada outlet, jordan shoes, longchamp

Coach Factory said...
on 

mulberry outlet
kate spade handbags
los angeles lakers jerseys
cheap nike shoes
soccer jerseys
cartier love bracelet
roshe run men
abercrombie and fitch
michael kors outlet online
michael kors outlet online
cheap oakley sunglasses
denver broncos jerseys
manchester united jersey
oakley sunglasses
pandora
vans shoes
kate spade handbags
louis vuitton outlet
nike free uk
the north face clearance
tory burch shoes
pandora charms
evening dresses
canada goose outlet
louis vuitton handbags
ray ban sunglasses
cleveland cavaliers jersey
coach outlet store
louis vuitton uk
louis vuitton
cheap mlb jerseys
chanel outlet
moncler coats
adidas shoes
mac makeup
kobe 9 elite
toms shoes
hermes birkin
michael kors outlet uk
rolex watches
cai2015627

Qing Cai said...
on 

2015-07-28song
air max 2015
longchamp pliage pas cher
ray ban sunglasses
longchamp outlet online
ralph lauren polo shirts
true religion jeans
soccer outlet
retro jordans
michael kors handbags
kate spade
michael kors purse
kate spade handbags
michael kors handbags
pandora charms sale clearance
michael kors outlet online
louis vuitton sito ufficiale
michael kors bags
air jordan uk
michael kors
cheap snabacks
football jerseys
rolex watches
coach outlet store online
cheap jordans free shipping
tory burch outlet
coach outlet
burberry scarf
prada shoes
cheap oakley sunglasses
burberry handbags
mcm bags
tory burch shoes
cheap oakleys
prada outlet store
ray ban outlet

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

ninest123 Ninest 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

ninest123 Ninest 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

ninest123 Ninest 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

ninest123 Ninest said...
on 

kobe shoes, http://www.kobeshoes.us/
new balance shoes,new balance,balance shoes,new balance outlet,new balance store,new balance store locator,new balance shoes for women,joe's new balance outlet,newbalance,newbalance.com,new balance walking shoes
oakley sunglasses cheap, http://www.oakley.in.net/
tory burch shoes, http://www.toryburchshoesoutlet.com/
chanel outlet, http://www.chaneloutletstore.us.com/
ray ban sunglasses,ray ban sunglasses outlet,ray ban,rayban,ray bans,ray ban outlet,ray-ban,raybans,ray ban wayfarer,ray-ban sunglasses,raybans.com,rayban sunglasses,cheap ray ban
michael kors uk outlet, http://www.michaelkorshandbag.co.uk/
michael kors outlet store, http://www.michaelkorsoutletusa.net/
nba jerseys wholesale, http://www.nbajerseys.net/
abercrombie and fitch, http://www.abercrombie-fitch.us.com/
iphone cases, http://www.iphonecase.name/
louis vuitton bags, http://www.louisvuittonbag.us.com/
marc jacobs, http://www.marcjacobs.cc/
michael kors factory outlet, http://www.michaelkorsfactoryoutlets.in.net/
nike store, http://www.nikeoutletstore.us/
nike free,nike free run,free running,free run,nike running
soccer jerseys, http://www.cheapsoccerjersey.net/
celine outlet store, http://www.celineoutletus.com/
ray ban sunglasses sale, http://www.raybansunglass.us.com/
tory burch handbags, http://www.toryburch.in.net/
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

Gege Dai said...
on 

2016-05-30keyun
replica rolex watches
discount jordans
nike air huarache
ray ban sunglasses wholesale
coach outlet clearance
abercrombie and fitch
ray ban sunglasses
ralph lauren home
cheap rolex watches
cheap oakley sunglasses
coach factory outlet
hollister clothing
cheap ray ban sunglasses
cheap jordans
polo outlet
asics running shoes
replica rolex watches
michael kors outlet
pandora charms
air jordan homme
oakley outlet
michael kors
fitflop sale
replica rolex watches
lebron 11
nike store outlet
michael kors outlet
hollister clothing
michael kors outlet clearance
replica watches
adidas superstar
kids lebron shoes
oakley canada
concords 11
nike running shoes
michael kors outlet
louis vuitton purses
designer handbags
cheap air jordans

柯云 said...
on 

ralph lauren uk
true religion jeans
oakley sunglasses
uggs for women
christian louboutin shoes
asics outlet
ugg store
timberland boots
true religion
mlb jerseys
canada goose sale
coach outlet store online
uggs on sale
coach outlet store online
ugg boots sale
nike outlet
uggs on sale
michael kors handbags
ugg boot uk
air jordan retro
ralph lauren uk
coach outlet
louis vuitton handbags
polo ralph lauren outlet
polo ralph lauren
air jordans
michael kors outlet clearance
oakley sunglasses wholesale
jordan 3
ugg outlet
louis vuitton outlet
louis vuitton outlet
uggs canada
cheap cartier watches
ed hardy clothing
air jordan pas cher
cheap oakley sunglasses
kate spade handbags
louis vuitton handbags
cheap oakley sunglasses
chenlina20160902

chenlina said...
on 

beats by dre
iphone case
cheap jordans
ugg outlet
louis vuitton
tiffany jewellery
louis vuitton outlet
michael kors wallets
michael kors outlet
louis vuitton bags
20161122caihuali

Hua Cai said...
on 

Post a Comment

Related Posts Plugin for WordPress, Blogger...