Thanks for the nudge in the right direction. Between those and a few Google searches with my newly acquired proper terminology, I managed to get this working.
Private Sub Command11_Click()
DoCmd.TransferText acExportDelim, , "MyQuery", CurrentProject.Path & "\Folder\Folder\" & Format(Date...