SQL di VBA (1)

Posted by bayu on 3 February, 2010
No comments yet
This item was filled under [ Tulisan ]

karena tuntutan permintaan :D

menggunakan String Variabl, contoh :

Dim strSQL As String
strSQL = "SELECT * FROM all";
DoCmd.RunSQL strSQL

atau singkatnya bisa kek gini :

DoCmd.RunSQL "SELECT * FROM all";

Tagged with: [ , , ]
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Comment

CommentLuv Enabled
:-)) :-) :-D (LOL) :-P (woot) ;-) :-o X-( :-( :-& (angry) (annoyed) (bye) B-) (cozy) (sick) (: (goodluck) (griltongue) (mmm) (hungry) (music) (tears) (tongue) (unsure) (highfive) (dance) (doh) (brokenheart) (drinking) (girlkiss) (rofl) (money) (rock) (nottalking) (party) (sleeping) (thinking) (bringit) (worship) (applause) 8-) (gym) (heart) (devil) (lmao) (banana_cool) (banana_rock) (evil_grin) (headspin) (heart_beat) (ninja) (haha) (evilsmirk) (bigeyes) (funkydance) (idiot) (lonely) (scenic) (hassle) (panic) (okok) (yahoo)
«
»