adodc1.recordsource = "select * from tabelnama where code = '" & text1.text & "'"
adodc1.refresh
if adodc1.eof then
MsgBox "Code Doesn't Exist, Please Try Another One"
else
.....
semoga membantu
Milis <[EMAIL PROTECTED]> wrote:
dear miliser,saya sedang mencoba membuat aplikasi dengan menggunakan adodc sebagai koneksi ke databasekebetulan mentok pada command sql nya, yang ingin saya tanyakan bagaimana syntaq yang benar dari perintahcari code dari adodc1 where code = text1.txtjika code tidak ditemukanMsgBox "Code Doesn't Exist, Please Try Another One"else(tampilkan pada field2 yang ada di form)
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
SPONSORED LINKS
| Programming languages | Programmer | C programming language |
| Computer programming languages | Java programming language | C 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.
