Results 1 to 5 of 5

Thread: docmd.transfer

  1. #1
    Join Date
    Jul 2004
    Location
    Blackburn, UK
    Posts
    169

    Unanswered: docmd.transfer

    Is it actually possible to use SQL in a docmd.transfer*** and whatever method you are using to transfer?

    At current it only allows me to use tables or queries, i dont like having queries in my database id rather just have the code built in?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Quote Originally Posted by ChrisGolden
    i dont like having queries in my database id rather just have the code built in?
    Uhh... why?

    DoCmd.Transfer if for tranfering objects. No object, no transfer. You could create temporary queries and export those if you have an extenuating need to do so.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jul 2004
    Location
    Blackburn, UK
    Posts
    169
    Because i dont like cluttering up the program where it really doesnt need to be?

    I just wanted to create an SQL query that does the same job as the query in the query window.

    If i had to create a query for every SQL statement i wrote then my query windows would be about a mile long!

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Temp queries/tables are probably the way to go then. I use them for random I/O stuff that I have to export on occassion and therefore need to push into a table or some sort of temp object.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Jul 2004
    Location
    Blackburn, UK
    Posts
    169
    Thanks, ill look into that then

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •