<div>
maybe it is better to link to the linked table instead of the excel file on the network?
</div>


maybe it is better to link to the linked table instead of the excel file on the network?

<div>
I'm not sure what &quot;ID&quot; is, or how it's related to your Excel file. Can you give more information on what you're trying to do?
</div>


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?

<div>
Scott, when you open a form with a where condition it is sometimes where ID = ID. &nbsp; <br />
<br />
Docmd.openform,,,&quot;id=&quot;id<br />
<br />
Something like that but instead of opening a form I am opening an excel file on the network. &nbsp;I have counted each row and labeled the column as ID. &nbsp;<br />
<br />
It might be a lot easier than I have explaines<br />
<br />
Thank you
</div>


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

<div>
<div class="content wysiwyg-content">
Experts, what is the code to open an excel file on the network where ID = ID?<br />
<br />
I have an excel linked report and I want to make an &quot;on click&quot; event procedure. <br />
<br />
thank you
</div>
</div>


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

Hyperlink to record in Excel on network

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.