ProphetBob
New member
- Local time
- Today, 06:21
- Joined
- May 19, 2015
- Messages
- 3
I have not been able to find a solution to my dilemma in these forums of via Google/Bing. If anyone can re-direct me to a thread or advise how to accomplish I would greatly appreciate. I am self-taught so don’t always understand the coding.
I am using Access 2010 with Win-7. Shared, split database with several users.
Database Purpose: PM Procedure for Medical Equipment
Goal: To be able for the user to copy the file name of 1 or more technical manuals and paste into a table used for a subform on the procedure parent form. Users can then open the related files stored in a common directory that are related to the procedure when later reviewing the procedure .
Problem: File path on the common drive for our group remains static “\\Syspro_5\VOL1\BIOMED\COMMON\Equipment (Service Manual)”. The subfolders are not static. There is an unlimited number of sub folders by vendor, model, or make. The subfolders sometimes get renamed as vendors change ownership. The file itself usually does not get renamed. New subfolders get added as needed. Everyone in our group has access to this area of the server.
Question: Is there a way in VBA that when a user opens the procedure record form and dbl-clicks the name of the file in the subform, Access can start at the parent folder and keep searching through all the subfolders until it finds the file? I cannot depend on people in my group to be able to correctly update hyperlinks so I need a way people with no Access knowledge can even use – even if it’s a little slow.
Thanks for any help!
I am using Access 2010 with Win-7. Shared, split database with several users.
Database Purpose: PM Procedure for Medical Equipment
Goal: To be able for the user to copy the file name of 1 or more technical manuals and paste into a table used for a subform on the procedure parent form. Users can then open the related files stored in a common directory that are related to the procedure when later reviewing the procedure .
Problem: File path on the common drive for our group remains static “\\Syspro_5\VOL1\BIOMED\COMMON\Equipment (Service Manual)”. The subfolders are not static. There is an unlimited number of sub folders by vendor, model, or make. The subfolders sometimes get renamed as vendors change ownership. The file itself usually does not get renamed. New subfolders get added as needed. Everyone in our group has access to this area of the server.
Question: Is there a way in VBA that when a user opens the procedure record form and dbl-clicks the name of the file in the subform, Access can start at the parent folder and keep searching through all the subfolders until it finds the file? I cannot depend on people in my group to be able to correctly update hyperlinks so I need a way people with no Access knowledge can even use – even if it’s a little slow.
Thanks for any help!