KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

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

Article: Q187890
Product(s): Word 97 for Windows
Version(s): WINDOWS:97
Operating System(s): 
Keyword(s): kbdta kbdtacode word8 word97
Last Modified: 14-NOV-2000

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft Word 97 for Windows 
-------------------------------------------------------------------------------

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          : kbdta kbdtacode word8 word97 
Technology        : kbWordSearch kbWord97 kbWord97Search kbZNotKeyword2
Version           : WINDOWS:97
Issue type        : kbprb

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.