[AccessD] A couple of macro questions

Kaup, Chester Chester_Kaup at kindermorgan.com
Wed Aug 12 12:36:05 CDT 2009


You are right about the query. That fixed it. Thanks.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
Sent: Wednesday, August 12, 2009 8:27 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A couple of macro questions

Arthur, as for the report are you sure you're not opening the query yourself
in an earlier step of the macro? Then it would be in view behind the report.
If the report is bound to the query you don't need to open the query
yourself. If it's not that then I'm puzzled.

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] A couple of macro questions
Date: 12/08/09 11:20


> 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


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

________________________________________________
Message sent using UebiMiau 2.7.2

-- 
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