S
S Vassmer
I'm trying to export a record set from a query based on a
form.
I'm using this:
DoCmd.TransferText acExportDelim, "qryNameChgs Export
Specification", "_qryNameChgs", "c:\\Documents and
settings\All Users\Desktop\New Name Changes.tab", True
The specifications are set at: File Format=Delimited,
Field Delimiter=tab, Text Qualifier=none, Date Order=MDY,
X=Four Digit Years, Date Delimiter=/, X=Leading Zeros in
Dates, Time Delimiter=:.
On my query, _qryNameChgs, I have a field = Birthdate:
Format([qryPerson_Info]![Birthdate],"mm/dd/yyyy")
The file exports as tab delimited, but the Birthdate field
includes time (example: 06/15/1952 0:00:00)
How do I get rid to the time? It's driving me nuts!
Using Office 2000, ACCESS 2000, and Notepad to open the
exported file. Any help is appreciated.
S Vassmer
form.
I'm using this:
DoCmd.TransferText acExportDelim, "qryNameChgs Export
Specification", "_qryNameChgs", "c:\\Documents and
settings\All Users\Desktop\New Name Changes.tab", True
The specifications are set at: File Format=Delimited,
Field Delimiter=tab, Text Qualifier=none, Date Order=MDY,
X=Four Digit Years, Date Delimiter=/, X=Leading Zeros in
Dates, Time Delimiter=:.
On my query, _qryNameChgs, I have a field = Birthdate:
Format([qryPerson_Info]![Birthdate],"mm/dd/yyyy")
The file exports as tab delimited, but the Birthdate field
includes time (example: 06/15/1952 0:00:00)
How do I get rid to the time? It's driving me nuts!
Using Office 2000, ACCESS 2000, and Notepad to open the
exported file. Any help is appreciated.
S Vassmer