Docmd.Transfertext AcExportDelim problems with a 3 digit integer

[CD Tom]

I have a table with columns Data Type as Number they are formatted Field Size Double, Format standard, Decimal Places 3. I export this table using the docmd.transferText acExportDelim to a .txt file. when I look at the .txt file the table only show 2 decimal. My question is why and how can I get the export to put out 3 decimals.

[SioSio]

The default for displaying "No. of digits after decimal" when exporting is depends on Windows settings.
Ex.)
Change Number Format in Windows 10.
Open the Control Panel in Large or Small icons view. Click on Region.
When the Region window opens, click on the Additional settings button.
The Customize Format window opens. In the Numbers tab, you can customize "No. of digits after decimal".

<Other than using the control panel shown above>
Click the [Settings] button in the text export wizard, and when the export definition dialog appears, field information will appear in the lower half.
Here, only the field name is visible, but if you double-click the right end of the item title line [| field name] many times, [| field name | data type | start position | width | index | skip ].
Change this "data type" from double-precision floating point type to text type and save. Specify this saved text export definition in a text conversion macro to get the desired format.

[NeoPa]

When exporting, if you want the data in a specific format, export a Query instead of a Table and make sure the data is formatted text rather than Numeric where you rely on the system to format the data for you.

So, if you have a Field in your output that needs to be formatted as "#,##0.000", for instance, use :

Format([YourNumericField],'#,##0.000') AS [FieldName]

[CD Tom]

NeoPa
I have created a query with the format in the fields that require 3 decimals. This works on some machines but on others I get a function not available. I know this error is caused by a missing reference, here's the problem, I have one machine that has Access 365 on it I'm using Access 2007 runtime. I've opened the program with Access 365 and the program runs fine, however I've compiled the program in Access 365 but when I run the compiled program I get the Function not available error. Do you have any ideas about what causes this to happen.

[CD Tom]

Sio Sio
Changing the Windows 10 region works fine however I can't find any of the settings you are talking about in the export wizard Remember I'm running Access 2007 so what I have is on the top menu "External Data" I click on it, then click on the "Text file" in the export section. I have nothing that will let me set any of the fields. Do I even have this option in Access 2007

[CD Tom]

SioSio
Ok after playing around I was able to get the field names to appear in the Advanced screen however I can't get anything except the Field Name and no matter where I double click I get nothing.

[NeoPa]

Hi Tom.

It's advisable always to develop your project at the lowest level (IE. The oldest version you expect it to be used on). Access will handle upgrading automatically to newer version libraries, but not the other way around.

I suspect if you do it that way around you should find it works everywhere.

[NeoPa]

As for exporting Text files - the options available tend to be different depending on whether or not you choose the option to Save formatted. If not, then you should get the Export Text Wizard Dialogue Box. From there you can do the basics by stepping through from one screen to the next.

There is also an Advanced... button which opens a separate wizard that allows you more control over everything. It also allows saving, as well as using previously saved, specs. In this wizard it shows your Fields in a column, but there may be more columns which are simply invisible. To see the full set simply drag the mouse across from the Field Name column to the right (beyond where the column stops) and then double-click the right-hand bar at the side of the column title. This will ensure all the other columns show in the wizard. Mostly they're irrelevant but it does allow a little more control and visibility.

[CD Tom]

I am using Access 2007, but my problem is in the references I show "Microsoft office 16.0 Object Library" and "Microsoft Access 12.0 Object Library", "Microsoft office 16.0 Access Database engine Object"
and some others. I've looked in the non-checked references and there isn't one for Microsoft office 12.0 Object Library. I can browse and find it but when I check it, it doesn't show up in the references anywhere. No sure what to do.

[CD Tom]

Ok I just figured out how to expand those other columns that were hidden. What a pain. Thanks for all your help.