Andy Lacey
andy at minstersystems.co.uk
Wed Aug 12 13:00:03 CDT 2009
Oops sorry Chester. I looked and thought the original question was from Arthur. Anyway, glad it's fixed. Andy -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: 12 August 2009 18:36 To: Access Developers discussion and problem solving Subject: Re: [AccessD] A couple of macro questions 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com