[belajar-access] Re: Membuat msgbox jika memasukan duplikat data

Wah ternyata bisa, terima kasih atas bantuannya....

Best Regards

Piko

--- In belajar-access@yahoogroups.com, Aksan Kurdin <aksan.kurdin@...> wrote:
>
> Private Sub Form_Error(DataErr As Integer, Response As Integer)
> On Error GoTo errHandle
>
> errHandle:
> If DataErr = 3022 Then 'Primary key violation
> MsgBox "Data yang anda masukan sudah ada, mohon di input
> IDPelanggan yang lain", vbInformation, "Duplikasi key"
> Response = acDataErrContinue
> End If
> End Sub
>
>
>
> Aksan Kurdin
>
>
>
>
> On 3/21/2011 9:10 AM, Piko wrote:
> >
> > Dear pakar access, mohon bantuannya..bagaimana membuat pesan box jika
> > kita memasukan data yang duplikat, misal :
> > Isi tabel
> > IDPelanggan Nama Alamat
> > 12B Joko Jl. Singa
> > 13B Ali Jl. Bangau
> > dll
> >
> > Jika kita memasukan data di form lalu kita memasukan lagi data
> > IDPelanggan 12B, lalu saat mau disimpan di command button, muncul
> > pesan the changes you requested to the table were not succesful bla
> > bla bla....
> > gimana caranya mengganti pesan error tadi menjadi messagebox misal :
> > "Data yang anda masukan sudah ada, mohon di input IDPelanggan yang lain"
> >
> > Terima kasih
> >
> >
>

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

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/