Phucon
It depends what method you are using and if you warnings are on or off. First put this in the Immediate window and press Enter:
DoCmd.SetWarnings true
That will make sure your warnings are turned on.
But you still have to tell us how you are executing your INSERT statement before we can fully answer your question.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "cc" <saigonf7q5@...> wrote:
>
> Hi good morning
>
> I use "Insert INTO..." to insert records to a table. When the record is already exist in the table, the RecordsAffected is = 0, and when that happens, I expect it will give out some sort of error message , but it does not. Why is that?
>
>
> Phucon
>
Tidak ada komentar:
Posting Komentar