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.
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.
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?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
very very tanks.