• Creator
  • #2269205

    Copying files in another application using a form in MS Access


    by pashby ·

    I am trying to find out if there is a way to copy and rename a file in a different application using a form / macro in Microsoft Access (version 2003).

    My purpose is this:
    I am trying to use access to set up a small navigation system for a few computer illiterate people at my office. I want them to simply enter a job name and date (already set up in a form – using combo boxes & a calendar) and then push a button to open a seperate application (Microsoft Journal in this case) and have a template file be saveas’d to a new file location and file name based on the project and date chosen.

    I have already successfully set up a button to open Microsoft Journal and open a specific file using the same paramaters (Project Name and Date) if the file already exists. Now I simply need a button to create the file in the first place.

    Any help would be greatly appreciated!!

All Answers

Viewing 1 reply thread