pdf thumbnail in access report

  • Thread starter jocasio via AccessMonster.com
  • Start date
J

jocasio via AccessMonster.com

I need help getting a .pdf file to show in a report.

I've used the following code for .jpg files, but have no idea what control or
how to preview .pdf files.

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Dim sFileName As String
sFileName = Me.ImageTxt

See if this photo exists
Returns a zero length string if file does not exist
sFileName = Dir(sFileName)

If Len(sFileName & vbNullString) = 0 Then
Load "Not Available" Photo
Me.loglinkview.Picture = "F:\NotAvailable.BMP"
Else
Load the matching Photo for this StudentID
Me.loglinkview.Picture = Me.ImageTxt

End If
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Export to PDF 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
parse a Text file 2
Working outlook via vba code with xlsx - error 0
Word macro that can call cells out of Excel for a find and replace 0
help with/for pivottable code 0
Word Macro 2003-2007 problem 0
Print pdf file from a form 8

Top