[AccessD] A couple of macro questions

Asger Blond ab-mi at post3.tele.dk
Wed Aug 12 06:22:59 CDT 2009


> When it runs in the macro what happens. Does it append only the records it
> can or what?

Yes it appends only the records it can, conflicting records being ignored.
This is the same behaviour as when the append query is run outside the
macro, and it's the same behaviour as when you in T-SQL use the clause WITH
IGNORE_DUP_KEY = ON when creating a unique index.

Asger 


On Tue, Aug 11, 2009 at 10:19 AM, Kaup, Chester <
Chester_Kaup at kindermorgan.com> wrote:

> I have a macro with warnings turned off. One query when I run it outside
> the macro and it tries to append records to a table I get the message key
> violation cannot append 3 records do you wish to continue. When it runs in
> the macro what happens. Does it append only the records it can or what?
>
> In this same macro I run a number of queries and then open a report in
> print preview. The report has a close form button on it. When I click the
> close form button the results of the query that the report is based on
comes
> up. I thought it should go back to the form that called the macro to run.
> How do I get it to close the query and go back to the first form.?
>
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list