How to Filter Hyperlink

Topic

New Reply

Some URLs contains “.pdf”.
For example: “c:ABCAccess.pdf”
How to filter records with the field containing “.pdf”?
Currently I use:
Me.Filter = “ like ‘*pdf*'”
Me.FilterOn = True

but it won’t work.
Armstrong

Reply | Quote

Replies

In what sense doesn’t it work? Do you get too many records? Or too few? Or the wrong ones?

Reply | Quote

In what sense doesn’t it work? Do you get too many records? Or too few? Or the wrong ones?

No record is shown.
Armstrong

Reply | Quote

The screenshot shows after clicking PDF (button), not a single record is shown.
Armstrong

Reply | Quote

The subprocedure for the PDF button:

Private Sub CmdPDF_Click()
Me.Filter = “ like ‘*pdf'”
Me.FilterOn = True
End Sub

Armstrong

Reply | Quote

Try changing

Me.Filter = “ like ‘*pdf'”

to

Me.Filter = “ like ‘*.pdf*'”

(A hyperlink field that refers to a file C:DocsTest.pdf actually contains #C:DocsTest.pdf#, so you must use a * after pdf too)

Reply | Quote

Try changing

Me.Filter = “ like ‘*pdf'”

to

Me.Filter = “ like ‘*.pdf*'”

(A hyperlink field that refers to a file C:DocsTest.pdf actually contains #C:DocsTest.pdf#, so you must use a * after pdf too)

Hi HansV,
Your solution works instantly. Yes, now I got tons of pdf records. Thanks a lot.
Armstrong

Reply | Quote