rajeshsarin
Registered User.
- Local time
- Tomorrow, 03:08
- Joined
- Sep 25, 2009
- Messages
- 50
Folks,
I run a small access database in-house, the database has a front end for each client and backend is on windows server 2008. Attached screen shot.
On the same server there is a folder called 1PR which houses folders for various clients. Each client folder then has various subfolders (most are standardized). One of the folders is called Visa -- Has a subfolder called uploaded. This uploaded folders contains pdf files for each client that have been uploaded manually to an online government database.
Attached is a screen shot of folder structure.
Now the problem.
I want to run a report, whereby for each client I can list the client ID and the documents that have been uploaded for each client. This will then help me determine on a daily basis what docs are pending or missing. Client details I can get from the database, plus the database has a link to each client folder, I need some code to ensure that the system can then look at the file names in each of the Uploaded folder (1PR/John Smith/Visa/Uploaded) and then spit these out in form of a report or excel sheet.
How can I achieve this?? I am VB dyslexic.
Cheers
I run a small access database in-house, the database has a front end for each client and backend is on windows server 2008. Attached screen shot.
On the same server there is a folder called 1PR which houses folders for various clients. Each client folder then has various subfolders (most are standardized). One of the folders is called Visa -- Has a subfolder called uploaded. This uploaded folders contains pdf files for each client that have been uploaded manually to an online government database.
Attached is a screen shot of folder structure.
Now the problem.
I want to run a report, whereby for each client I can list the client ID and the documents that have been uploaded for each client. This will then help me determine on a daily basis what docs are pending or missing. Client details I can get from the database, plus the database has a link to each client folder, I need some code to ensure that the system can then look at the file names in each of the Uploaded folder (1PR/John Smith/Visa/Uploaded) and then spit these out in form of a report or excel sheet.
How can I achieve this?? I am VB dyslexic.
Cheers
