Hyperlink in query?

C

CW

Is it possible to make a value displayed in a query into a hyperlink?
For example we have a query that lists the sales invoices relating to each
of our orders, and it would be great to be able to click on a sales invoice
number and fire up the saved image of that invoice. Can do?
Many thanks
CW
 
A

Arvin Meyer [MVP]

Sure. But not in a query. Use a form based on the query. You can even use
datasheet view so it looks like a query output. Now you need to tell me what
the output is. I'll assume and Access report, and it could be as simple as:

DoCmd.OpenReport "Invoice", acViewPreview, , "InvoiceNumber =" &
Me.txtInvoiceID
 
C

CW

Arvin - that's great, thanks, and your guess at the doc I want to open was
very close - I modified that just slightly to suit my actual structure and
that was it
Thanks again
CW
 

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

Top