Set Hyperlinkaddress to field from query and loop

C

Chapman44

Hello,
I have created a form where I can enter parameters and then run a query
based on the parameters. One of the fields in my query is a hyperlink field.
I want to follow the hyperlinks for each row in the query. I am new to
programming so this may be a round about way to approach it. Any help is
appreicated.
Here is what I have so far:

Dim ctl As CommandButton

Set ctl = Me!Command18
With ctl
.Visible = False
.HyperlinkAddress = DLookup("dstfilepath", "SheetSelectionQuery",
"dstDatasheetID = " & Nz([dstDatasheetID], 0))
.Hyperlink.Follow
End With
 

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

Follow Hyperlink Function 2
Multiple Listbox selectin and query criteria 11
Open to Veiw(Read only) files from VB 0
VBA - for report footer field properties 0
Need VBA Macro to Loop through pages and print counter in footer of each page 9
Recordset from query 5
Copy & Paste A Row Using An Array in A2K 10
TransferText method -- pass parameterized query? 0

Top