running append query without showing some alertes

[afshin]

I have a one Append Query in attached file, when I want to run that, three forms appears that have "yes","no" keys.in Form1(attached file) i want without showing this forms, ACCESS presume all forms: "yes" key clicked.

[June7]

I only use VBA, which could be one of the following:

DoCmd.SetWarnings False
DoCmd.OpenQuery "Query1"
DoCmd.SetWarnings True

Or

CurrentDb.Execute "Query1"

The first version does have macro equivalent.

However, this query will fail to append records because of key violations.

Why do you need to duplicate records?

[afshin]

very very tanks.