Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2008
    Location
    Suffolk, United Kingdom
    Posts
    308
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Deploy txt file from access (2003)

    Hi,

    I have a database I use to maintain templates and a tollbar which are used by secretaries through MS Word. I use the databsase to create the txt files from tables within the database.

    I would like to know how I can copy these templates to more than one location at the same to. I would like to use tick boxes to decide which locations I want deploy to then click the button and have it copy the text file to the ticked locations.

    The bit I'm stuck with is the code to pickup the source txt file and copy to the destination locations.

    Many thanks
    Regards
    Gerbil (AKA Kevin)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Deploy txt file from access (2003)

    You can use FileCopy to copy a file to another location, e.g.

    FileCopy "C:AccessMyFile.txt", "H:CommonMyFile.txt"

    You'll have to use one such line for each destination.

Posting Permissions

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