Use "GetFileOpen" and Link Access to a Folder
Posted on 2004-10-20
I want to be able to use the code originally written by Ken Getz or any other good codes to "GetFileOpen".
I want this code to be able to compare a field in the current table, compare for possible Match.
For Example, if the txtPermitNo is 311134, and the stored FileNo in a directory of C:\DlookUp\ filename is "311134.pdf", Compare the the PermitNo with the .pdf file but ignore the (.pdf) reference. If filename matches the PermitNo field, then, lauch Adobe Acrobat Reader, Do FileOpen as shown below.
If the two files match then open the file in Acrobat reader,
"NodataMatch" do nothing and do "Requery to refresh form"