Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 133
  • Last Modified:

Hyperlink to record in Excel on network

Experts, what is the code to open an excel file on the network where ID = ID?

I have an excel linked report and I want to make an "on click" event procedure.

thank you
0
pdvsa
Asked:
pdvsa
  • 3
  • 2
1 Solution
 
pdvsaProject financeAuthor Commented:
maybe it is better to link to the linked table instead of the excel file on the network?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'm not sure what "ID" is, or how it's related to your Excel file. Can you give more information on what you're trying to do?
0
 
pdvsaProject financeAuthor Commented:
Scott, when you open a form with a where condition it is sometimes where ID = ID.  

Docmd.openform,,,"id="id

Something like that but instead of opening a form I am opening an excel file on the network.  I have counted each row and labeled the column as ID.  

It might be a lot easier than I have explaines

Thank you
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I see ... in that case, it would very likely be much simpler to link the Excel workbook, as you suggested above.
0
 
pdvsaProject financeAuthor Commented:
Thank you
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now