please see insertion...
On 3/15/06, Hasan <[EMAIL PROTECTED]> wrote:
Rekans, saya mo tanya neh, saya kurang ngerti sama
vba, n sekarang saya mo rubah script di vba ke vb6,
ini neh scriptnya...
Private Sub Run_Query_Stock_Location_Click()
On Error GoTo Err_Run_Query_Stock_Location_Click
Dim stDocName As String
stDocName = "StockLocation"
'DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.OutputTo acOutputQuery, stDocName,
acFormatXLS, "C:\RECALL_NZMI\StockLocation.xls", False
kalau dibahasa indonesiakan:
simpan hasil query "stocklocation" ke dalam file dg format excel dg nama dan alamat C:\RECALL_NZMI\StockLocation.xls
kalau mau cari referensi fungsi2 vba diaccess, biasanya disimpan disini:
"C:\Program Files\Microsoft Office\Office10\1025\VBAAC10.CHM"
Exit_Run_Query_Stock_Location_Click:
Exit Sub
Err_Run_Query_Stock_Location_Click:
MsgBox Err.Description
Resume Exit_Run_Query_Stock_Location_Click
End Sub
Setau saya, script ini mo jalanin query yg namanya
stock_location y? tapi kalo
C:\RECALL_NZMI\StockLocation.xls ini apa y, apa
artinya hasil query dilempar kesini or apa y??
Tlg kasih tau dong, saya lg mo + wawasan vba neh, or
mgkn ada yg bs kasih tau beda nya sama coding di vb6,
kaya apa seh codingnya, keliatan bgt ga seh bedanya???
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
