dear all,
minta bantuan,
bagaimana coding agar progress bar jg jln, sewaktu kita jg sedang load database.
berikut ada potongan code:
Set rec = New ADODB.Recordset
rec.CursorLocation = adUseClient
rec.Open "SELECT Location.swh_codsh, TransSize.tr_code,
TransSize.tr_codep,TransSize.tr_size, TransSize.tr_categ,
SUM(TransSize.tr_totqty) AS tr_qty FROM TransSize INNER JOIN Location ON
TransSize.tr_shop = Location.lc_code WHERE (TransSize.tr_status <> 'VOID')and
tr_date >=" & TxtDate1.Value & " and tr_date<= " & TxtDate2.Value & " and
tr_shop='" & Trim(xLoc) & "' GROUP BY Location.swh_codsh, TransSize.tr_code,
TransSize.tr_codep, TransSize.tr_size, TransSize.tr_categ ORDER BY
TransSize.tr_categ", cn, adOpenStatic, adLockReadOnly
If rec.RecordCount > 0 Then
Set Flxdata.DataSource = rec 'disini loadnya lmyn lama.. biar user tahu kalau
sedang proses data.
End If
please advice..
terima kasih,
(\__/)
(='.'=) Agus Sudana
(")_(")
____________________________________________________________________________________
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.
http://tv.yahoo.com/
