Microsoft KB Archive/119846

PRA: A_EXPORTMERGE Constant Undefined in 1.1 Upgrade

Article ID: Q119846
Creation Date: 25-AUG-1994
Revision Date: 19-SEP-1996 The information in this article applies to:

Microsoft Access version 1.1

SYMPTOMS

When you upgrade to Microsoft Access version 1.1, and then use the A_EXPORTMERGE constant in a TransferText action in Access Basic code, you receive the error message:

   Variable not defined

CAUSE

The A_EXPORTMERGE constant is undefined in the Microsoft Access version 1.1 upgrade.

RESOLUTION

The A_EXPORTMERGE constant is equal to a value of 4. You can substitute the number 4 for the A_EXPORTMERGE constant in your function.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft Access version 1.1 upgrade. This problem no longer occurs in Microsoft Access version 2.0.

MORE INFORMATION

This article assumes that you are familiar with Access Basic and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information on Access Basic, please refer to the "Introduction to Programming" manual.

Steps to Reproduce Problem

Open the sample database NWIND.MDB.

Create a new module and enter the following line in the Declarations section of the module:

      Option Explicit

Create the following function in the module:

      Function ExportText ()
         DoCmd TransferText A_EXPORTMERGE, , "Products", "Products"
      End Function

From the View menu, choose Immediate Window.
Type the following line in the Immediate window, and then press ENTER:
```
      ? ExportText()
```
The error message stated above will occur.

REFERENCES

For more information about exporting data to a text format, search for "TransferText" then "TransferText Action" using the Microsoft Access Help menu.

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.

Additional reference words: 1.10 parameter argument
KBCategory: kbusage
KBSubcategory: PgmOthr