"Jeff Pritchard" <je************ @asken.com.au> wrote in news:XpMnb.519
$_********@news .optus.net.au:
Anyone know where can I get the correct syntax for the SaveAsText function.
I found it once but can't now.
The one commonly seen is not correct
SaveAsText acForm, "FormName", "FileToSave To"
The last two args are fine but the acForm is wrong. I thought it was a
number from 2 to 6
Query 2
Form 3
Report 4
Script 5
Module 6
But the problem I posted earlier is throwing some doubt on this. I know the
intrinsic constants acForm, acReport etc don't work as they always generate
an error.
Jeff
Open any module. Click on the object browser in the standard tool bar. Right
click in the dialog whcih is opened. Select "Show Hidden Members". Click
(Turn on). In the search box type "SaveAsText "
In AccessXP I am rewarded with:
Sub SaveAsText(Obje ctType As AcObjectType, ObjectName As String, FileName As
String)
Member of Access.Applicat ion
Double Click on AcObjectType. The values of the AcObjectType enumeration will
be shown.
AcForm is 2. All of your values are one too great.
--
Lyle
(for e-mail refer to
http://ffdba.com/contacts.htm)