PC Review


Reply
Thread Tools Rate Thread

DBR cell w/hyperlink ?

 
 
Frank
Guest
Posts: n/a
 
      21st Jun 2008
Simple DBR from an Access table where one of the fields is a file name.
In the DBR, for that field, I want to have a hyperlink to open the named
file.
I cannot remember the syntax, something like a combo of rs-fp FieldLink

This is wrong <a href="=FP_FieldLink(fp_rs,%22igcfile%22)">

can somebody get me on the right track?
 
Reply With Quote
 
 
 
 
Frank
Guest
Posts: n/a
 
      21st Jun 2008
Ok, got this code working now, but have another problem.... the file
opens in the window.

When the user clicks on the file name I do not want the file to open ...
I want the User to have a download/Save option in lieu of Open.


Frank wrote:
> Simple DBR from an Access table where one of the fields is a file name.
> In the DBR, for that field, I want to have a hyperlink to open the named
> file.
> I cannot remember the syntax, something like a combo of rs-fp FieldLink
>
> This is wrong <a href="=FP_FieldLink(fp_rs,%22igcfile%22)">
>
> can somebody get me on the right track?

 
Reply With Quote
 
Stefan B Rusynko
Guest
Posts: n/a
 
      22nd Jun 2008
What is the file type of the link
- if it is a known browser type file it will always open in browser window
(unless it is in say a zip file or a file that can be a server side generated type file)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


"Frank" <(E-Mail Removed)> wrote in message news:%23F0YgE%(E-Mail Removed)...
| Ok, got this code working now, but have another problem.... the file
| opens in the window.
|
| When the user clicks on the file name I do not want the file to open ...
| I want the User to have a download/Save option in lieu of Open.
|
|
| Frank wrote:
| > Simple DBR from an Access table where one of the fields is a file name.
| > In the DBR, for that field, I want to have a hyperlink to open the named
| > file.
| > I cannot remember the syntax, something like a combo of rs-fp FieldLink
| >
| > This is wrong <a href="=FP_FieldLink(fp_rs,%22igcfile%22)">
| >
| > can somebody get me on the right track?


 
Reply With Quote
 
Frank
Guest
Posts: n/a
 
      22nd Jun 2008
It is an xxx.IGC file which is a GPS log file used to record a flight.
The actual internals of the file are just text.
I can always get around this by right-click on the link and "Save Target
as.... "
But you know how Users are, so I was looking for a way to only offer a
Save when clicking on the link

Stefan B Rusynko wrote:
> What is the file type of the link
> - if it is a known browser type file it will always open in browser window
> (unless it is in say a zip file or a file that can be a server side generated type file)
>

 
Reply With Quote
 
Kathleen Anderson
Guest
Posts: n/a
 
      23rd Jun 2008
You could add a bit of JavaScript to the link that will "force" them to do a
right-click:

<a onclick="alert('Please right-click, Choose Save Target As...'); return
false;" href=

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others


"Frank" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> It is an xxx.IGC file which is a GPS log file used to record a flight.
> The actual internals of the file are just text.
> I can always get around this by right-click on the link and "Save Target
> as.... "
> But you know how Users are, so I was looking for a way to only offer a
> Save when clicking on the link
>
> Stefan B Rusynko wrote:
>> What is the file type of the link
>> - if it is a known browser type file it will always open in browser
>> window
>> (unless it is in say a zip file or a file that can be a server side
>> generated type file)
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a hyperlink to a cell with the hyperlink function =?Utf-8?B?Uy4gQmV2aW5z?= Microsoft Excel Worksheet Functions 2 20th Jul 2006 08:06 PM
script to hyperlink and reference a cell value in the hyperlink =?Utf-8?B?TmF0YXNoYSBELg==?= Microsoft Excel Programming 5 17th May 2006 07:43 PM
How make hyperlink refer to cell content rather than cell address. =?Utf-8?B?T211bmVuZQ==?= Microsoft Excel Misc 3 2nd Mar 2006 01:07 AM
Copy hyperlink from one cell to/as hyperlink in another cell YogS Microsoft Excel Worksheet Functions 6 12th Jan 2006 11:57 PM
Using paste link infromation in cell to hyperlink to source cell? Wayne Microsoft Excel Worksheet Functions 7 27th Feb 2005 07:38 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:04 AM.