Re: Output to a text file
- From: "Ken Snell \(MVP\)" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 17 Feb 2006 08:39:05 -0500
The second argument of the TransferText method is the name of an export
specification that you created and stored in the ACCESS database. This is
done manually by beginning the export process (File | Export), going through
all the screens to set the field specs, field names, etc., then on the last
screen of the wizard click the Advanced button at bottom left of the screen.
There you can save the specifications as an export specification. Then use
the name under which you store them as the export specification argument in
your code.
--
Ken Snell
<MS ACCESS MVP>
"Alec M1BNK" <AlecM1BNK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D5A9E58D-693E-4BF0-B243-14D81D413C23@xxxxxxxxxxxxxxxx
Hi all (again)
Once again i find myself having to dip into the pot of
wisdom...............
I have a multi user access databse. it's stored on a network server and
people access it by a mapped network drive.
I have a specific need to output the results of a query as a tab delimted
text file. So, I defined a spec, in this case called "samfileout" and
added
this code to an on click event
DoCmd.TransferText acExportDelim, "samfileout", "q_SamUpload",
"samupload.txt", False
When I exported this from my dev copy to the working one on the network it
doesn't work. Users get a runtime error that the filespec "samfileout"
does
not exisit. Where do i find this filespec and how do I export it to other
users?
I've searched the helpfiles and knowledge base but what help there is is
on
Import not export, and does not seem applicable in this case.
Alternatively, is there a better way to this, where everything is
contained
inside the database.
.
- Prev by Date: Re: Database or Project?
- Next by Date: Re: Auto Numbering or Typing my own Number
- Previous by thread: Performance improvement in displaying records on a form
- Next by thread: Re: Output to a text file
- Index(es):
Relevant Pages
|
