TransferText Problem

G

godiva

I'm a bit baffled as to why this even makes a difference. I have a
transfertext import delimited line. When a text box on the form is
populated with a file path including full file name to import (on
update of an option group on the form) A2k3 kicks out a message that
the file can't be imported. However, if I use the browse feature and
browse to the file, populating the same text box that way, it imports
it without a hitch. Punctuation, capitalization, everything matches.
So why is it that A2k3 gives me a talk to the hand with the prefilled
but is perfectly happy with the file name provided by browsing to it?
Also, what stick do I beat this with (i.e. how do I fix this? the
client is a bit lazy and doesn't want to browse to the file *rolls
eyes*)
 
G

godiva

I can't say that I understand why this fixes the issue, but I changed
the transfertext line of code so that the location of the file to
import was inside Trim(). I even doublechecked the code that fills in
the text box. There are no spaces either before the drive letter or
after the last letter of the file extension.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top