ypma, I appreciate your reply, suggestion and effort in code. The mobile.txt is located in same folder and drive as db. I have tried different drives, different folders and paths, even tried root of different drives each time getting same result, that is mobile.txt is deleted and then get...
Debug identified code as DoCmd in following:
Private Sub cmdMobileExport_Click()
DoCmd.TransferText acExportDelim, "Mobile_Export", "qryMobile", "R:\FltMaint\Mobile.txt"
End Sub
Prior to executing code the Mobile.txt file existed in path reflected in code line DoCmd which happens to be on a...
I'm Kerry Jensen (a guy, though sometimes the name is mistaken for a gal) from USA in Tehachapi, CA (where we have blue skies and can see stars at night and we get snow in the winter, which is why we moved here and will retire here). I spent several years in military (USAF) where I began...