CroteauB
02-14-2020, 08:02 AM
Hello all,
I am fairly new to access(at least programming in it) and was curious to pick your brains for the most effective solution to a problem
I work for an office where I am trying to keep records specific to individuals easily manageable and viewable
Basically I have a table that Identifies individuals through a number and their name and I want the form I am creating to be able to open a file dialog box to locate a particular PDF file that contains identifying information to that individual. I then want to be able to save that file location to the table and finally be able to view their entry in said table in a subform datasheet view after querying that individual, so that the location that is saved can just be clicked on and opens the pdf in the associated viewer on the users computer. I hope that I am explaining this well any clarification or questions please feel free to ask. Basically I am just looking for some guidance on the most efficient way to make this all work.
Thanks so much!!
Brian
I am fairly new to access(at least programming in it) and was curious to pick your brains for the most effective solution to a problem
I work for an office where I am trying to keep records specific to individuals easily manageable and viewable
Basically I have a table that Identifies individuals through a number and their name and I want the form I am creating to be able to open a file dialog box to locate a particular PDF file that contains identifying information to that individual. I then want to be able to save that file location to the table and finally be able to view their entry in said table in a subform datasheet view after querying that individual, so that the location that is saved can just be clicked on and opens the pdf in the associated viewer on the users computer. I hope that I am explaining this well any clarification or questions please feel free to ask. Basically I am just looking for some guidance on the most efficient way to make this all work.
Thanks so much!!
Brian