I am using MS access database for my research projects.
I am kind of self taught do it yourself as far as Access goes.
This time round I am doing a literature review and have created a database of all the search results. I have a table of all the articles. The table has fields for Article Title, Author, Year, Full Doc Found, Attachment for the article which at present is setup to store the actual pdf in the database.
I have however come across various online tutorials which advice against saving the file in the tutorial but instead create a path to it etc. What I actually aim to do is to be able attach the file or the link and then click a button and be able to open the attached file in the access form.
I am therefore looking for someone to create a short step by step video tutorial for the best way to achieve this.
I appreciate it may involve some VBA codes. I don't have that skill but if clearly explained I can follow the steps to replicate it in future.