C
Clint Marshall
I am looking for a way in Access 2000 to click a Command Button that will
copy and rename several files elsewhere in the same directory that the
Access database resides in. This could be done by having Access directly
rename and copy the files or by having Access run a .bat file that does the
work for us.
How do I do this? I am reasonably comfortable with Access Macros and VB
programming.
Perhaps another way of looking at this question is to think about what I'm
trying to achieve...
The end result I need is to change the icon for the directory in which the
file resides. We use the directory icon and icon color to track what
actions are needed for each directory (red icon needs immediate attention,
orange needs attention soon, green means the ball is in someone else's
court). I currently do this by using a set of batch files to copy in
different icons depending on the color needed. It works, but is primitive
and we'd like control from within Access.
Thanks!
-Clint Marshall
copy and rename several files elsewhere in the same directory that the
Access database resides in. This could be done by having Access directly
rename and copy the files or by having Access run a .bat file that does the
work for us.
How do I do this? I am reasonably comfortable with Access Macros and VB
programming.
Perhaps another way of looking at this question is to think about what I'm
trying to achieve...
The end result I need is to change the icon for the directory in which the
file resides. We use the directory icon and icon color to track what
actions are needed for each directory (red icon needs immediate attention,
orange needs attention soon, green means the ball is in someone else's
court). I currently do this by using a set of batch files to copy in
different icons depending on the color needed. It works, but is primitive
and we'd like control from within Access.
Thanks!
-Clint Marshall