Solved

Hyperlink to record in Excel on network

Posted on 2014-10-21
5
128 Views
Last Modified: 2014-10-22
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
Comment
Question by:pdvsa
  • 3
  • 2
5 Comments
 

Author Comment

by:pdvsa
ID: 40395667
maybe it is better to link to the linked table instead of the excel file on the network?
0
 
LVL 84
ID: 40396771
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
 

Author Comment

by:pdvsa
ID: 40396824
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
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 40396902
I see ... in that case, it would very likely be much simpler to link the Excel workbook, as you suggested above.
0
 

Author Closing Comment

by:pdvsa
ID: 40397593
Thank you
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question