Re: [belajar-access] cara mendeteksi record yang double??? [1 Attachment]

<*>[Attachment(s) from Mansur Widayat included below]

Maaf Mas, ikutan.
Klo misal filenya kayak gni gmn mas?

----- Original Message -----
From: "Sioon Mandra" <msioon@yahoo.com>
To: <belajar-access@yahoogroups.com>
Sent: Wednesday, January 26, 2011 9:01 PM
Subject: 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..

<*>Attachment(s) from Mansur Widayat:

<*> 1 of 1 File(s) http://groups.yahoo.com/group/belajar-access/attachments/folder/1161938046/item/list
<*> TEST.mdb

------------------------------------

SPAM IS PROHIBITEDYahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)

<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/