Microsoft KB Archive/187890

= WD97: Confirm Data Source Dialog Box Not Accessible in VBA =

Article ID: 187890

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Word 97 Standard Edition

-



This article was previously published under Q187890



SYMPTOMS
The Confirm Data Source dialog box is not displayed when you do either of the following in Microsoft Visual Basic for Applications for Microsoft Word:


 * You set the ConfirmConversions argument to True in the OpenDataSource method. -or-


 * You use the InsertDatabase method.



CAUSE
This behavior is by design of Microsoft Word. The Confirm Data Source dialog box is not exposed (accessible) to the Word Visual Basic object model or Wordbasic.



MORE INFORMATION
The ConfirmConversions argument in the OpenDataSource method has no relationship to the Select method check box in the Open Data Source dialog box.

When you record a mail merge in Word, and then run the macro, it will run without displaying any of the dialog boxes you saw during the recording of the macro. You cannot select a different method for opening the data source without rewriting or re-recording the macro.

Additional query words: access convert dbase foxpro interop odbc office97 paradox sql VBA

Keywords: kbdtacode kbprb KB187890

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.