I'm working on a database for work and there is a need to be able to open PDF files linked to clients in our database. For security reasons we have our database on a secured server and we use a remote desktop to log into our database, this also helps prevent people from making changes that they shouldn't or snooping around where they shouldn't.
We store PDF files on the server using the unique Claim ID generated in Access, however We also use the person's name as well. What I would like to do is have an access form generate a hyperlink directly to all the files linked to the claim, and I've been able to get a link to generate with the Claim ID, but I have not been able to get a wildcard symbol to work.
Is there something I'm missing? Am I using the wrong wildcard symbol? Am I even able to use a wildcard symbol in this instance?
An example of what I'm doing is this: "D:\My File Path" & [ClaimID] & * & "" & [ClaimID] & *
We store PDF files on the server using the unique Claim ID generated in Access, however We also use the person's name as well. What I would like to do is have an access form generate a hyperlink directly to all the files linked to the claim, and I've been able to get a link to generate with the Claim ID, but I have not been able to get a wildcard symbol to work.
Is there something I'm missing? Am I using the wrong wildcard symbol? Am I even able to use a wildcard symbol in this instance?
An example of what I'm doing is this: "D:\My File Path" & [ClaimID] & * & "" & [ClaimID] & *
Last edited: