Dear All,
as first let me say that I am NOT an expert programmer and I use to prepare some applications for my personal usage.
Now let's go to the point.
By means of a push button I want to rename and move some JPG files, which are normally located in different directories & subdirectories, depending on the values of two text fields present in a main form. In other terms, changing the values of such fields, I need that the file names and their directories change accordingly.
So I was thinking to launch SHELL "COMMAND.COM" and then send to the command line the needed DOS commands by means of SendKeys, but it does not work.
At last, I cannot prepare a .BAT file to perform the whole job, as the names of the directories are variable and determined by the values selected in the Access form.
Can you suggest me how can I send several commands on the DOS screen after I opened in with the SHELL ? Different solutions to my problem are certainly welcome. Thanks. Alberto
as first let me say that I am NOT an expert programmer and I use to prepare some applications for my personal usage.
Now let's go to the point.
By means of a push button I want to rename and move some JPG files, which are normally located in different directories & subdirectories, depending on the values of two text fields present in a main form. In other terms, changing the values of such fields, I need that the file names and their directories change accordingly.
So I was thinking to launch SHELL "COMMAND.COM" and then send to the command line the needed DOS commands by means of SendKeys, but it does not work.
At last, I cannot prepare a .BAT file to perform the whole job, as the names of the directories are variable and determined by the values selected in the Access form.
Can you suggest me how can I send several commands on the DOS screen after I opened in with the SHELL ? Different solutions to my problem are certainly welcome. Thanks. Alberto