Search results

One thing I have discovered (or maybe my system isn't working correctly) I can only create a export spec from a table. When I attempt to do it using a query I get an error of "Too few parameters." I gave up on getting the number fields to format correctly and created a table with all text...

Ahhh Thank you I will try that right now and let you know how it works.

I'm sorry, I don't understand what you just said. If it would help I can attach screenprints or code that show what is going on.

I am using an Export Specification. Here is the code: DoCmd.TransferText acExportDelim, "Standard_Spec", _ "qryFilteredEDIForRowCount_2003", "C:\EDI\" & strFilename Standard_Spec is my Specification

I am having issues when exporting records to a comma delimited text file. I have 4 numeric fields that are having the formatting changing during the export process. Below is a sample. My numeric fields are of double size and fixed at 4 decimals with the exception of the final column which is...