Kaya gini bisa gak yah ?
Buat 1 tombol, terus pake script ini
Asumsi KOneksi CN
Dim iVariable as integer
Dim iData as integer
Dim rs as adodb.recordset
set rs=new adodb.recordset
iVariable=10 ' MIsal, karena anda gak nyebutin NIlai variable dari mana
rs.open "Select Nilai from tableNya order by nilai",cn
For idata = 1 to rs.recordcount()
if iVariable - rs!Nilai =0 then
msgbox "Hasilnya sudah 0 di data ke " & iData
exit for
else
rs.movenext()
end if
next
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| Hasan <[EMAIL PROTECTED]>
Sent by: [email protected] 30/11/2005 08:39 AM
|
|
Morning all....
Saya mo tny neh, gmn y cara ngurangin nilai dalam
tabel per record dengan variabel, kira2 metodenya
gini,pertama kita lihat record pertama trs kt kurangin
variabel dengan nilai direcord pertama,kl nilai
variabel blm jadi nol, maka die akan pindah ke record
kedua dan ngurangin lg, trs ke record brkt nya smp
variabel bernilai nol....Tolong saya y, gmn seh script
nya dlm vb,o iy utk database saya pake sql2k....
Thanx....
__________________________________
Yahoo! Music Unlimited
Access over 1 million songs. Try it free.
http://music.yahoo.com/unlimited/
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
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/
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
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.
