Hello, I am a self taught access user trying to build a simple database to act as a central repository of information for our projects dept, basically to replace a 102 column excel spreadsheet. We have a number of live projects, each one has a set number of supporting documents stored in individual project directories on our intranet.The Excel spreadsheet had columns of schedule data, cost data, resources and general references, so I have split this data into four tables (schedule, cost etc) with a direct relationship based on unique project ID numbers in each table. So, each project in the general reference table have a direct one to one relationship with corresponding fields in the other tables. One of these tables contains fields with hyperlinks to the locations of the projects supporting documents.
I would like to create a form with the supporting project documents represented by labels. As the user moves through the projects (different records in the projects list) using the navigation buttons I would like to assign the correct hyperlink for that specific project directory to the labels. I have tried using macros, code builder and text fields instead, but I can't get this to work.
Ideally I could display the label as an hyperlink IF the corresponding hyperlink field was populated, and only load the correct hyperlink and follow it when the label was clicked. However that is the ultimate dream, and I would be very happy with any method that can assign hyperlinks on the fly to these labels. Can anyone help please?