D
Dale
Hi, I have a hybrid Access/VB6 question which I asked in a VB forum but
was suggested to try asking here as well.
if I want to use in my VB code:
DoCmd.TransferText [transfertype][, specificationname], tablename,
filename[, hasfieldnames][, HTMLtablename][, codepage]
to export the contents of a query, I can go like:
DoCmd.TransferText acExportDelim, , _
"Query1", App.Path & "\test.txt", -1
and that all works fine.
My question now is, if I change my Query1 so that it takes parameter(s),
how do I pass parameter(s) within that DoCmd statement, if it is even
possible? Thanks.
was suggested to try asking here as well.
if I want to use in my VB code:
DoCmd.TransferText [transfertype][, specificationname], tablename,
filename[, hasfieldnames][, HTMLtablename][, codepage]
to export the contents of a query, I can go like:
DoCmd.TransferText acExportDelim, , _
"Query1", App.Path & "\test.txt", -1
and that all works fine.
My question now is, if I change my Query1 so that it takes parameter(s),
how do I pass parameter(s) within that DoCmd statement, if it is even
possible? Thanks.