coba script dibawah ini, dengan asumsi ID faktur berdasarkan jumlah
data yang ada di tabel transaksi
mSQL = "select count(*) as jmldata from ftransaksi"
set rs = con.Execute(mSQL)
no = rs.Fields("jmldata") + 1
Text1.Text = "F/" & Format(Date, "MM") & "/" & String(5 - Len(Trim
(Str(no))), "0") & no
hasil :
F/02/00001 -> kalau data di tabel transaksi masih kosong
F/02/00002 -> kalau data di tabel transaksi berisi satu
record dan seterusnya.
moga sukses,
if01k
--- In [email protected], "green_id81" <[EMAIL PROTECTED]>
wrote:
>
> mau buat ID faktur dari Months(sistem)+ ID Faktur (otomatis)dan
Months
> muncul di Form Load pada Text box..ad yg bisa bantu kawan-kawan?
>
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
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
