follower2020
New member
- Local time
- Today, 20:57
- Joined
- May 14, 2020
- Messages
- 9
Hello
we have a record for each patient
each patient will have patient number
my co workers prepare the documents needed , get them signed and then they scan in order to email them
when they scan , they name each file this way : the patient number then some description
e.g.1255 GOP
1255 Passport copy
etc
i want a code to copy all pdf files starting with e.g. 1255 to another folder
( i create a folder for each patient with the patient number as the folder name )
is this possible in access.
so i want access to copy all pdf files starting with the patient number ( i.e. the current record ) to a folder
e.g. copy all pdf files starting with 1255 to the folder "C:\"Patients\1255\"
source folder="C:\Users\mhm\Desktop\Sourcefolder"
destinationfolder= "C:\"Patients\" & me.patientnumber
Thank you
we have a record for each patient
each patient will have patient number
my co workers prepare the documents needed , get them signed and then they scan in order to email them
when they scan , they name each file this way : the patient number then some description
e.g.1255 GOP
1255 Passport copy
etc
i want a code to copy all pdf files starting with e.g. 1255 to another folder
( i create a folder for each patient with the patient number as the folder name )
is this possible in access.
so i want access to copy all pdf files starting with the patient number ( i.e. the current record ) to a folder
e.g. copy all pdf files starting with 1255 to the folder "C:\"Patients\1255\"
source folder="C:\Users\mhm\Desktop\Sourcefolder"
destinationfolder= "C:\"Patients\" & me.patientnumber
Thank you