Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    88

    Unanswered: export spec with DoCmd.RunCommand acCmdExport

    I'm trying something simple I think. I want to export the results of a query. I want to call up the export dialog so that users can enter the file name, path and file type.

    I'm using: DoCmd.RunCommand acCmdExport

    And it works fine except I get quotes aroung each field value. I'd like to use and export spec to eliminate the quotes but I don't know the syntax and haven't had any luck finding it.

    Can you use an export spec with this method? and how?

    Any other ideas?

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    Here is an Example using a button to browse for a folder in which the user want to store his Export file.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •