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 :

9 comments to “VBA untuk Menghapus Tabel”

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

oakleyses 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

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 

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 

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

Unknown 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 

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

Unknown said...
on 

Post a Comment