Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get Path to TransferText from Textbox

Status
Not open for further replies.
laman

laman

Technical User
Jan 24, 2002
44
0
0
US
What's wrong with the following:

DoCmd.TransferText acExportDelim, "sdf", "acc", "Forms![sdffiles]![txbfolder]acc1.sdf", False, ""

I'm tring to get the destination path from a textbox on a form. The file transfers but always to A:\drive no matter what I have in the textbox.

Thanks.
 
Sort by date Sort by votes
Try....

DoCmd.TransferText acExportDelim, "sdf", "acc", Forms![sdffiles]![txbfolder] & "acc1.sdf", False, ""

It looks like you've got the concatenation wrong....

Craig
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
135
dhookom
dhookom
btamsgn
  • Locked
  • Question
How to add lines from textbox to table 1
Replies
8
Views
71
MattGreer
MattGreer
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
92
Viswa.R
Viswa.R
OzFoxy
  • Locked
  • Question
How to get AttachmentCount from a field in a table
Replies
2
Views
73
OzFoxy
OzFoxy
feipezi
  • Locked
  • Question
How to get the macros back as they vanish somehow in a AccessDB?
Replies
8
Views
159
combo
combo

Part and Inventory Search

Sponsor

Back
Top