View PDF Files from Ms Access Form

[papic1972]

Hi All,

I store PDF copies of all invoices that are printed from an access form in a folder 'C:\Invoices'. I have had a look at & used the method (of creating a form that lists files in a folder) devised by Allen Browne called 'Listbox recursive list files' which is found here:

http://www.allenbrowne.com/ser-59.html

& it is quite good, but it is missing one final part that i'm looking for.

I name my PDF files by a combination of the record number that it is generated from & 'CI'. For e.g, a PDF may be named as '43687CI'.

Referring to Allen's listbox example:
If i have a form that relates to record '43687' (for example), does anyone know how i can filter my listbox so it shows only '43687CI' & not all the PDF's stored in 'C:\Invoices'.

 

[Remou]

If this is a single invoice, why bother with Allen Browne's code at all?

[tt]Me.txtFileName= "C:\Invoices\" & Me.RecID & "CI.pdf"[/tt]

Then, in the click event:

If Dir(Me.txtFileName)<>"" Then
   FollowHyperlink & Me.txtFileName
Else
   'Missing
End If

 

[papic1972]

Hi Remou,

Thanks.