common dialog boc for open/save as

[Guest]

I have a text box to save the image path for the picture that I insert into
the Image Box. I also create a folder to store all the image related to my
database. How do I copy the picture from the old folder and put it into my
Image folder and rename it.

 

[Douglas J. Steele]

You can use the Name statement to "move" a file, with the following
provisos:

Both newpathname and oldpathname must be on the same drive. If the path in
newpathname exists and is different from the path in oldpathname, the Name
statement moves the file to the new directory or folder and renames the
file, if necessary. If newpathname and oldpathname have different paths and
the same file name, Name moves the file to the new location and leaves the
file name unchanged. Using Name, you can move a file from one directory or
folder to another, but you can't move a directory or folder.

If you need to delete the file once it's been copied (because you tried to
move to a different drive), use the Kill statement.

 

[Guest]

Douglas J. Steele

do you mind to give me some example. I've no idea about the this. thanks

 

[Douglas J. Steele]

See whether http://www.fmsinc.com/free/newtips/Access/accesstip31.asp is
enough to get you going.