Im not very experienced in programming with Access, and I have a question about the export delimiter. I have two tables:
I made a query called Email, that gives the user a dialog box and allows them to enter a workshop number. It then retrieves the email address of each person enrolled in that particular workshop. I have a form created with a button that runs this query using the TransferText action, then outputs it to a textfile named Email located on my C drive. I need the output in this format though: email@example.com
; etc. etc. I cannot figure this out. If someone could help me, I would really appreciate it. I already tried using the Export Text Wizard and creating delimiters through that, but it's not working out too well.
This is the code I currently have in the button procedure:
Private Sub buttonEmail_Click()
On Error GoTo Err_buttonEmail_Click
Dim stDocName As String
stDocName = "C:\Email.txt"
DoCmd.TransferText acExportDelim, , "Email", stDocName, True
MsgBox "The following error was encountered:" & Chr(13) & Err.Number & ": " & Err.Description, vbOKOnly, "Error"