Possible to open all .pdf files through access vba that match specified criteria?
Posted on 2012-03-16
I am creating a form where after a box is updated it takes the [jaDrawNum] and another field [jaRevisionNum] and concatenates them with '*' and ".pdf" to select and open all files with the matching info from jaDrawNum and jaRevisionNum within a folder and it's subfolders.
I'm open to other suggestions as to how to do this as well.
So the filename string would look like 2S56634-5454*(A00A)*.pdf and would open all the pdf files in the folders that have 2S56634-5454 and (A00A) appearing in the file name. (Both criteria would have to meet per file name, not one or the other).
I was building off of another code where I opened up a specific file.. Here is what I just through together as an example of what I'm trying to accomplish;
Private Sub txtAssemblySeq_AfterUpdate()
Dim strLink As String
Me.Filter = "[jaJobNum] = " & "'" & Me.txtJobNum & "'" & " and " & "[jaAssemblySeq] = " & Me.txtAssemblySeq
Me.FilterOn = True
If IsNull([jaDrawNum]) Then
MsgBox "No Drawing was attached to this record."
strLink = "C:\Drawings\*\" & [jaDrawNum] & "*" & [jaRevisionNum] & "*" & ".pdf"
Thanks in advance for the help