Solved

Hyperlink to record in Excel on network

Posted on 2014-10-21
5
122 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

706 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now