Re: Using TransterText

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: John Viescas (JohnV_at_nomail.please)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 15:56:37 -0600

The answer is you can't. One solution is to modify the QueryDef object and
insert the parameter values directly before you execute the TransferText. 

-- 
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
"Dale" <dale0610@hotmail.com> wrote in message
news:%23Xe3RjrCEHA.2556@TK2MSFTNGP12.phx.gbl...
> 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.

Relevant Pages

  • Re: Selecting data with CHOOSE
    ... "Running Microsoft Access 2000" ... > If MyValue Like "B" then the description should be "Second Value" ... > "John Viescas" skrev i melding ... >> "SQL Queries for Mere Mortals" ...
    (microsoft.public.access.queries)
  • Re: Query referencing dialog box
    ... "Running Microsoft Access 2000" ... > "John Viescas" wrote in message ... >> "SQL Queries for Mere Mortals" ...
    (microsoft.public.access.queries)
  • Re: IF U ceate query dynamically, can U create query description t
    ... creating a new query, which should not have a Description property in A2000. ... John Viescas, author ... "Building Microsoft Access Applications" ... >>> Dim prp As DAO.Property ...
    (microsoft.public.access.queries)
  • Re: how do you do "if record doesnt exist create otherwise update" in one SQL statement?
    ... Yup, I tend to hang out only in the Access groups, but Mike also sent me an ... email pointing to the thread, so I thought I'd pop in here and answer it ... John Viescas, author ... "Running Microsoft Access 2000" ...
    (microsoft.public.inetserver.asp.db)
  • Re: iif condition
    ... It would help if you posted the SQL for your query. ... John Viescas, author ... "Building Microsoft Access Applications" ... >> arguments (Retirement Trvl). ...
    (microsoft.public.access.queries)