how do i reference a pdf document in ms access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a list of pdf documents using a listbox and then by
double-clicking a row in the listbox access will open the appropriate pdf
document, any ideas?
 
Assuming your list box is set to Single select only, you can use:

Application.FollowHyperlink Me.MyListbox

(replace MyListbox with the actual name of your list box)

If it's set for Multiselect, try:

Dim varSelected As Variant

For Each varSelected In Me.MyListbox.ItemsSelected
Application.FollowHyperlink Me.MyListbox.ItemData(varSelected)
Next varSelected

(for that matter, you can use the second approach even if it is set to
single select)
 
Back
Top