/* */

Wednesday, January 26, 2011

Bls: [belajar-access] cara mendeteksi record yang double???



Coba jawab ya...., ada beberapa cara bapak , mis : buat aja field tsb Primay Key atau buat jadi field dg setting Uniq ( kalau langsung gak mau ada yg double ) atau pakai code mis :

Private Sub InputRecord_BeforeUpdate(Cancel As Integer)
Dim A
A = Dlookup("Record","tblabc","Record=Input.value")
If Not Is Null (A) then
MsgBox"Maaf , record udah ada"
end if
End Sub

Salam,
~ Sioon ~

--- Pada Rab, 26/1/11, afon stmr <afon_s@yahoo.com> menulis:

Dari: afon stmr <afon_s@yahoo.com>
Judul: [belajar-access] cara mendeteksi record yang double???
Kepada: belajar-access@yahoogroups.com
Tanggal: Rabu, 26 Januari, 2011, 8:17 AM

 

bagaimana cara mendeteksi record yang double pada saat input record?

thx..




__._,_.___


SPAM IS PROHIBITED



Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___

No comments:

Post a Comment