Coba anda taro fungsi ini di modul anda
Public Function fc_Null(sValue, Optional pType As Integer = 0) As String
if IsNull(sValue) Then
If pType = 0 Then
fc_Null = ""
Else
fc_Null = 0
End If
Else
fc_Null = sValue
End If
End Function
nah di form nya tinggal anda tulis
fc_null(rs!datanya) --> akan menghasilkan "" bila data nya null --> string
fc_null(rs!datanya,1) --> akan menghasilkan 0 bila data nya null -->int
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| "thoyib" <[EMAIL PROTECTED]>
Sent by: [email protected] 07/02/2006 09:25 AM
|
|
Dear VB-ers,
Halo VBers tolong bantuannya...
Aku mo menampilkan database dari Ms.Access ke List View...
Tapi aku menemukan masalah jika Record dari database tsb ada yg kosong (Null) maka di List View tidak mau tampil... muncul pesan error "Invalid Use Of Null"
Tolong bantuannya...
Soalnya aku maunya data yg kosong tsb di tampilkan di ListView, karna nantinya akan di Update...
Tolong bantuannya yachh.. Sebelumnya maap kalo p'tanyaanya bikin ribet...
Salam,
Thoy
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.
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.
