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 :

4 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 

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 

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