I'm using this to export data from a table to a cvs file:
I have tried adjusting the information in the data field as follows:
Field Size = Double
Format = Fixed
Decimal Places = 3
Field Size = Double
Format = [Blank]
Decimal Places = 3
Field Size = Double
Format = [Blank]
Decimal Places =[Blank]
I might see if I really need this as a number and maybe just change it to text but as of right now I'm not sure that I can.
Any help would be greatly appreciated.
Private Sub SaveAndClose_Click()
Dim PartNumber3 As String
PartNumber3 = Me.[Order Name]
DoCmd.TransferText acExportDelim, , "Rough Order", "C:\Cardinal Order\Rough Orders" + PartNumber3 + ".csv", True
The data in the table has 3 decimal places but the cvs file when viewed in notepad has only 2.Dim PartNumber3 As String
PartNumber3 = Me.[Order Name]
DoCmd.TransferText acExportDelim, , "Rough Order", "C:\Cardinal Order\Rough Orders" + PartNumber3 + ".csv", True
I have tried adjusting the information in the data field as follows:
Field Size = Double
Format = Fixed
Decimal Places = 3
Field Size = Double
Format = [Blank]
Decimal Places = 3
Field Size = Double
Format = [Blank]
Decimal Places =[Blank]
I might see if I really need this as a number and maybe just change it to text but as of right now I'm not sure that I can.
Any help would be greatly appreciated.