I am trying to set up something to be able to take me to a folder that holds various forms for personnel. I have a query that generates the link for each person. I have tried to set it up as a hyperlink in ACCESS 2013 and it displays as one but doesn't act like one.
I want to be able to click the link and have it open up a personnel folder for that individual. I can't find a MACRO that I can create to do it and I have no idea how to program in VBA, which I know is how I will need to solve the problem, so if you give me something you need to be pretty specific in how to type it out. Example of my query is that it creates a link K:\Main Breakdown\Section Breakdown\Personnel Folders\Name and the name is the variable part.
My next problem will be to have it create that folder when we have new personnel arriving.
I would also note that I have not worked with ACCESS in many years and much of what I was able to do with 2002 and 2003 doesn't work with the newer versions of ACCESS.
I want to be able to click the link and have it open up a personnel folder for that individual. I can't find a MACRO that I can create to do it and I have no idea how to program in VBA, which I know is how I will need to solve the problem, so if you give me something you need to be pretty specific in how to type it out. Example of my query is that it creates a link K:\Main Breakdown\Section Breakdown\Personnel Folders\Name and the name is the variable part.
My next problem will be to have it create that folder when we have new personnel arriving.
I would also note that I have not worked with ACCESS in many years and much of what I was able to do with 2002 and 2003 doesn't work with the newer versions of ACCESS.