Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    2

    Unanswered: Transfer Database

    In copying tables i use the command Transferdatabase shown below.It is a good command, but i need the following refinement.
    I want to copy the table only when the Yes/No field "accepted" in the table Unis is set to Yes.Can i do it in the command, and if not,
    how can i set the condition ?


    DoCmd.TransferDatabase TransferType, "Microsoft Access", appath, acTable, "Unis", "Unis"

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Have a look at the DLookup function in the help file.
    oh yeah... documentation... I have heard of that.

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

Posting Permissions

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