1. The Name of the QueryDef is ExpRec_q and the SQL of it:
Code:
SELECT tbl_Zeichnungen.* FROM tbl_Zeichnungen WHERE (((tbl_Zeichnungen.F23)=[forms]![ZeichnungSuchen_f]![dwgname]));
vittorio0
Last Activity: Nov 30 '15, 02:07 PM
Joined: Nov 29 '15
Location:
-
The QueryDef runs ok when the form is opened and Returns the proper record.
1. The Name of the QueryDef is ExpRec_q and the SQL of it:
The Error comes up after Rightklick - Export - Textfile, I can set the Output file and after the error pops up. I like to specify that the first... -
I managed to have the form open and tried to create the exportspecifica tion, however the error remains the same :(Leave a comment:
-
Yes, thats right, how can I have the form open and at the same time be in edit mode at the querydef.Leave a comment:
-
Thansk a lot for your answer, I have tried that and it works. When I try to create the Exportspecifica tion with the filter in place, it comes up with the errormessage "1 Parameter was excepted, to few were supplied" (translated from German) any idea?Leave a comment:
-
TransferText, but only spec. record
I'd like to Output a certain record from a table into a Text file. GlbLastWip is the criteria
why does this not work?, i'm getting error 3011Code:Dim strSQL As String strSQL = "SELECT * FROM [tbl_Zeichnungen] WHERE ([F23]='" & GlbLastWip & "');" doCmd.TransferText acExportDelim, "ExpRec_q", strSQL, "C:\temp\ExpRec_q.txt"
Thanks for your help
vittorio0
No activity results to display
Leave a comment: