Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    renaming a saved query (Access 97)

    I have a module which saves a query as file with a .txt extenstion to my hard drive. I would like to know if there is a way I can, in access, rename this file once it's been saved to the hard drive. Really I just need a way to rename a saved file on my hard drive.
    Let's say my saved file is called myquery1.txt

    Thanks for the help..

  2. #2
    5 Star Lounger
    Join Date
    Jul 2002
    Toronto, Ontario, Canada
    Thanked 0 Times in 0 Posts

    Re: renaming a saved query (Access 97)

    The Name command will give you what you need

    Name oldpathname As newpathname

    And it must be the FULLY QUALIFIED PATH. (C:FullPathtomyfile.ext)

    As an added bonus, if the paths are different, you effectively move the file.
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

Posting Permissions

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