ACC1x: DoMenuItem Macro to Export Object Returns Error

ID: Q109946

The information in this article applies to:

SYMPTOMS

When you run a macro that uses the DoMenuItem action with an Export command to export an object from your database, you receive the following error message:

Command not available: Export


RESOLUTION

To work around this problem, use the TransferText, TransferDatabase, or TransferSpreadsheet macro action instead of the DoMenuItem action.


STATUS

This problem no longer occurs in Microsoft Access version 2.0.


MORE INFORMATION

Steps to Reproduce Behavior


  1. Open the sample database NWIND.MDB. Create and save a macro with the following action: 
    
      Action: DoMenuItem
         Menu Bar: Database
         Menu Name: File
         Command: Export


  2. Create a new, unbound, blank form.


  3. Drag the macro from the Database window to the form.


  4. View the form in Form view.


  5. Click the macro command button on the form.



REFERENCES

Microsoft Access "Language Reference," version 1.0, "DoMenuItem Action," pages 151-154, "TransferDatabase Action," pages 473-476, "TransferSpreadsheet Action," pages 476-479, and "TransferText Action," pages 479-481

Additional query words: DoMenuItem Export Transfer 


Keywords          : kbinterop McrActn McrHowto 
Version           : 1.0 1.1
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: April 2, 1999