Programmatically Open File and Save As in Access 97

  • Thread starter Thread starter CSeifferly
  • Start date Start date
C

CSeifferly

Hi,

I currently have a function that reads the files in a parcitular directory
and writes them to a table. They are displayed to users in a listbox.

When the user selects a file from the list box and clicks a button, I'd like
the program to Save the file as a name and in a directory specified in other
fields and delete the original file.

I have Access 97, so the Office.FileDialog is not available. I do not know
how to create the functionality I want within the limits of Access 97.

Any suggestions would be greatly appreciated.

CSeifferly
 
Look up VBA Help on the following commands

Change directory or folder. ChDir
Change the drive. ChDrive
Copy a file. FileCopy
Make directory or folder. MkDir
Remove directory or folder. RmDir
Rename a file, directory, or folder. Name
Return current path. CurDir
Return file date/time stamp. FileDateTime
Return file, directory, label attributes. GetAttr
Return file length. FileLen
Return file name or volume label. Dir
Set attribute information for a file. SetAttr
Delete a file: KILL

Name can be used to move and rename a file AS LONG AS the file remains on
the same drive. If you want to move the file to a different drive you will
need to use FileCopy to make a copy of the file on the new drive and then
use KILL to delete the file on the original drive.
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top