Word 2003 - eliminating SQL dialog box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Candace - 19 Jul 2007 13:56 GMT

When I attempt to perform a particular merge, I get a dialog "Microsoft
Office Word" dialog that says

"Opening this document will run the following SQL command ... Data from your
database will be placed in the document. Do you want to continue?"

And it gives the options "Yes" or "No"

Since I will be performing this merge several times a day every day, I do
not want to have to respond to this dialog box each time. Is there a setting
that can be adjusted so that these documents open without performing this
check? Or maybe a way to set "Yes" as an automatic default, so that it does
not prompt me to respond?

Reply to this Message

Peter Jamieson - 19 Jul 2007 15:22 GMT

You probably have to implement the registry change described in the
following article:

http://support.microsoft.com/kb/825765

Peter Jamieson

> When I attempt to perform a particular merge, I get a dialog "Microsoft
> Office Word" dialog that says
[quoted text clipped - 12 lines]
> does
> not prompt me to respond?

Reply to this Message

Janfry - 19 Jul 2007 17:06 GMT

Look at "Application.DisplayAlerts", setting the value to wdAlertsNone.

Returns or sets the way certain alerts and messages are handled
while a macro is running.

WdAlertLevel can be one of these WdAlertLevel constants.
wdAlertsAll All message boxes and alerts are displayed; errors
are returned to the macro.
wdAlertsMessageBox Only message boxes are displayed; errors are
trapped and returned to the macro.
wdAlertsNone No alerts or message boxes are displayed. If a
macro encounters a message box, the default value is chosen and the macro
continues

Janfry

> When I attempt to perform a particular merge, I get a dialog "Microsoft
> Office Word" dialog that says
[quoted text clipped - 9 lines]
> check? Or maybe a way to set "Yes" as an automatic default, so that it does
> not prompt me to respond?

Reply to this Message

Rate this thread: