Programmatically Open File and Save As in Access 97

[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

 

[Alex Dybenko]

Hi,
to show a Save dialog you can use this API
http://www.mvps.org/access/api/api0001.htm

to copy file - FileCopy
to delete file - Kill

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[John Spencer]

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
..