设为首页收藏本站Access中国

Office中国论坛/Access中国论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

返回列表 发新帖
查看: 4215|回复: 4
打印 上一主题 下一主题

Introduction to Hyperlink fields

[复制链接]
跳转到指定楼层
1#
发表于 2005-9-19 20:36:00 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
文章标题:Introduction to Hyperlink fields

文章来源:http://allenbrowne.com/casu-09.html

原文:

Access 97 introduces this field type for storing links to files on:

your computer (a file name);

a network (a UNC name);

the internet (a URL address).

A hyperlink entry contains three parts separated by pound signs (#). The template is:    display text # file name # any reference within the file

Use the Insert menu to add a hyperlink entry, and Access takes care of the three parts. Only the "display text" part of the field is shown, and clicking on the field executes the link.

So how can you view its full contents or edit the field?

Click the attached label, to move the cursor into the hyperlink field. (If the field has no label, use the Tab key.)

Press F2 to edit the field. All three parts of the hyperlink are displayed for editing.

Some examples may help show how this works:



Hyperlink ContentsDisplaysWhen ClickedMy photo#c:\pix\photo.bmp#My photoLoads picture into MS Paint.SS data#ss.xls#Sheet 1!G9SS dataLoads spreadsheet into Excel, selecting cell G9.Do labels#\\jane\pub\label.doc#Do labelsLoads the network document into WinWord.Edit Clients##ClientsEdit ClientsOpens Clients form in current database (no file specified).Sales info##Query SalesSales infoRuns the Sales query in the current database.*IBM#http://www.ibm.com#IBMLoads your web browser and opens the URL.#www.canon.com#www.canon.comLoads your web browser, assuming prefix of "http://".* The word "Query" in this hyperlink is optional. However, if the current database had a form named Sales, Access would open the form in preference to the query.



译文:

超级链接入门

ACCESS97中介绍存储超链接:

你的电脑(一个文件名)

一个网络(一个UNC名)

INTERNET(一个URL地址)

一个超链接包含三部分被#号分离的标记。模板是:

display text # file name # any reference within the file

使用插入菜单输入超链接,然后ACCESS能够照顾好三部分。仅仅“显示文本”部分关闭,然后点击执行链接。

所以你怎样访问完整的满足需要的编辑领域?

1.       点击附上的标签,去移动指针指向超级链接。(如果没有标签,你可以使用TAB键)

2.       按F2到编辑领域,所以的三项都显示正处于编辑状态。

一些例子可以帮助你查看这种工作:



Hyperlink ContentsDisplaysWhen ClickedMy photo#c:\pix\photo.bmp#My photoLoads picture into MS Paint.SS data#ss.xls#Sheet 1!G9SS dataLoads spreadsheet into Excel, selecting cell G9.Do labels#\\jane\pub\label.doc#Do labelsLoads the network document into WinWord.Edit Clients##ClientsEdit ClientsOpens Clients form in current database (no file specified).Sales info##Query SalesSales infoRuns the Sales query in the current database.*IBM#http://www.ibm.com#IBMLoads your web browser and opens the URL.#www.canon.com#www.canon.comLoads your web browser, assuming prefix of "http://".

“查询”这个词是一个超级选择。如果当前的数据库是一个以销售命名的。那么ACCESS就能够打开一个窗体中优先的查询。



翻译人:飞天业

[此贴子已经被作者于2005-9-19 12:38:28编辑过]

分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 分享分享 分享淘帖 订阅订阅
2#
发表于 2006-10-20 00:04:00 | 只看该作者
谢指正, 因为是多位作者合写, 各人负责各自的章节,可能审稿时有疏漏, 虽然每个章节我都有修改和审稿,但可能有些章节我疏漏了。我会在后面勘误表更正. 非常感谢您的指正!
3#
发表于 2008-3-22 11:46:00 | 只看该作者
谢谢, 正为这个发愁. 用DAO写进HyperLink数据时不能FOLLOW UP. 原来加个#就可以了.
您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|站长邮箱|小黑屋|手机版|Office中国/Access中国 ( 粤ICP备10043721号-1 )  

GMT+8, 2024-5-3 09:54 , Processed in 0.098032 second(s), 26 queries .

Powered by Discuz! X3.3

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表