DoCmd.TransferText acExportFixed

[vbaInet]

I tired it with the Claims Export but that didn't work so I put the ClaimsExports in "" and that did it. So I have
DoCmd.TransferText acExportFixed, "ClaimsExport", "qryExport", "C:\Users\RGreene.LINNCNTY\Desktop\ExportTest.txt"

Yes, that's right. That part of the TransferText method requires a string so good job for figuring that out.

You're welcome!