I have an access database whereby files will be stored against a project table/form via a hyperlink, i also have a dummy folder plan on a network drive.
What i'm wanting to do is when a record is created on the form to copy the dummy folder plan and rename the top level based on two of the fields from the record and then update the hyperlink to the new path.
e.g. dummy = c:\dummy\....
copy and rename to c:\Record ID\....
update hyperlink field on the record to c:\record id\
Is this possible?