By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 2,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Building a form to copy and rename files

P: n/a
Dear forum,

I am currently building my first Access (XP) database from scratch, and
I would like to be able to enable users of this database to enter a
filename in an Access form so that, once the filename has been
specified, the (.dbf) file is copied and given a new name. Can anybody
help me with this?

(I then hope to use some borrowed code to link to the file from the
database and append the data it contains to a table in my database, but
that will have to wait until I've managed the first step, since I can't
link to the .dbf file unless the name is in the correct format - no
more than eight characters long, including spaces. )

May 16 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Paddy wrote:
Dear forum,

I am currently building my first Access (XP) database from scratch, and
I would like to be able to enable users of this database to enter a
filename in an Access form so that, once the filename has been
specified, the (.dbf) file is copied and given a new name. Can anybody
help me with this?
Look at DIR and NAME in help. Look at the examples in the help file for
each topic.

You might want to go to http://www.mvps.org/access/api/api0001.htm for a
FileOpen/Save dialog solution to get your filenames.
(I then hope to use some borrowed code to link to the file from the
database and append the data it contains to a table in my database, but
that will have to wait until I've managed the first step, since I can't
link to the .dbf file unless the name is in the correct format - no
more than eight characters long, including spaces. )

May 16 '06 #2

P: n/a
On Tue, 16 May 2006 15:52:36 GMT, salad <oi*@vinegar.com> wrote:

Also look at the FileCopy function to actually copy the file.
-Tom.

Paddy wrote:
Dear forum,

I am currently building my first Access (XP) database from scratch, and
I would like to be able to enable users of this database to enter a
filename in an Access form so that, once the filename has been
specified, the (.dbf) file is copied and given a new name. Can anybody
help me with this?


Look at DIR and NAME in help. Look at the examples in the help file for
each topic.

You might want to go to http://www.mvps.org/access/api/api0001.htm for a
FileOpen/Save dialog solution to get your filenames.
(I then hope to use some borrowed code to link to the file from the
database and append the data it contains to a table in my database, but
that will have to wait until I've managed the first step, since I can't
link to the .dbf file unless the name is in the correct format - no
more than eight characters long, including spaces. )


May 17 '06 #3

P: n/a
Thank you both! I'll give that a try right away.

Paddy

May 17 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.