SQL填充MS Access中的超链接列 [英] SQL to populate a hyperlink column in MS Access

问题描述

我想象SQL必须传递2个值，即表中显示的值和该值导航到的链接.

I imagine the SQL must pass 2 values, the value shown in the table and the link to which that value navigates.

我非常感谢指向SQL脚本的指针来实现这一目标.谢谢.

I'd appreciate a pointer to the SQL Script for achieving this. Thanks.

推荐答案

超链接列(字段)的格式为:

The format for a hyperlink column (field) is:

Description#Address#

Description#Address#

例如:

This is StackOverflow#http://stackoverflow.com#
Mr E Xample#mailto:[e-mail]#

在大多数情况下，我更喜欢避免超链接字段(列)，因为编辑它们是一个真正的问题.带有一些代码的文本或备注字段要简单得多，尽管您将需要一个表单.

For the most part, I prefer to avoid hyperlink fields (columns) as editing them is a real problem. A text or memo field with a little code is much simpler, though you will need a form.

这篇关于SQL填充MS Access中的超链接列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！