access+training - Output To within Access Macros

Resolved · Low Priority · Version Standard

Output To within Access Macros

Doug has attended:
No courses

by - delegate Doug [1 post] (2008 Jan 15 Tue, 09:39) Reply

Hi,

I am using 'Output To' in my macro to run a query and then export it into an Excel sheet.

The Excel file I am exporting into is the same one each time, hence I get the message:

"The file 'xxxxx' already exists. Do you want to replace the existing file?"

How can I set this to 'yes' as a default so I don't have to click 'yes' everytime?

Best wishes,

Doug.

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu + 9 Fri	Southwark	5	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
2003	2009 Jun 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 11 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Output To within Access Macros

by - trainer Carlos gold contributer [479 posts] (2008 Jan 29 Tue, 14:02) Reply

Hi Doug

There is a line of code in VBA that suspends any Warnings/Alerts.

In the Macro just before your Output To code line try using

Application.DisplayAlerts=False

And immediately after the Output To code line use

Application.DisplayAlerts=True

Hope this helps

Carlos