Import Export Specifications

[shreev]

I am trying to work with Import Export Specifications and can create them and
store them with the Export Wizard. However, if I try to use them in
transfertext command in code it does not recognize the name of the spec. I
tried in a macro but it does not included in the list. Why won't it
recognize that they are there?

 

[Dirk Goldgar]

I am trying to work with Import Export Specifications and can create them
and
store them with the Export Wizard. However, if I try to use them in
transfertext command in code it does not recognize the name of the spec.
I
tried in a macro but it does not included in the list. Why won't it
recognize that they are there?

Did yu enclose the name of the specification in double-quotes (") ? Please
post the code that isn't working.

 

[shreev]

Private Sub Command3_Click()
DoCmd.TransferText acExportFixed, "RptExp", "Report", "c:\ups\pdfreport.pdf"
End Sub

In Saved Exports I have two "specs" RptExp and ExPdf

Trying from a macro design the arguments are:
(Export Fixed Width, , Report, c:\ups\reports\rdfreport.pdf, No, , )
but in the properties it won't let me add either.

Thanks fo the quick response!

 

[Dirk Goldgar]

Private Sub Command3_Click()
DoCmd.TransferText acExportFixed, "RptExp", "Report",
"c:\ups\pdfreport.pdf"
End Sub

In Saved Exports I have two "specs" RptExp and ExPdf

Trying from a macro design the arguments are:
(Export Fixed Width, , Report, c:\ups\reports\rdfreport.pdf, No, , )
but in the properties it won't let me add either.

I'm confused. Are you trying to export a table or query, or are you trying
to export a report? Export specifications wouldn't apply to a report.

 

[shreev]

I am sorry. Poor choice for the test. Report in
DoCmd.TransferText acExportFixed, "RptExp", "Report",
is actually a table named Report

 

[shreev]

And I am sorry again. It must have something to do with my install. I ran
the same scenario on another machine and it works as described.
Thanks.