Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    112

    Unanswered: TrabsfareText Vb Command

    Could anyone tell me, instead of having undefinedundefined to specify a file name in the vb code could i put an inputbox code in there so when the transfertext code is run it will ask me for a file name???

    Thankyou

  2. #2
    Join Date
    Aug 2004
    Posts
    13

    Thumbs up

    You could simply nest an InputBox statement within the TransferText method as follows. Please keep in mind that the following syntax was created solely as a sample to your question. (no word wrap) You MUST have specifications defined in order for this to work.

    Private Sub Command0_Click()
    DoCmd.TransferText acImportDelim, "TestSpecs", "tblTest", "C:\" & InputBox("Please enter a file name")

    End Sub

Posting Permissions

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