如何从Access中的链接打开浏览器 [英] How to open browser from link in Access
问题描述
我希望有人可以告诉我关于如何打开浏览器的错误
并从Access 2000中的按钮或链接转到网站。
我已经尝试将字段指定为超链接类型并输入一个URL。
我尝试使用Button Properties表上的Hyperlink字段，并且
我尝试过使用Visual Basic：
Application.FollowHyperlink" html：//www.websitename.com" ;, True
并且在所有情况下，Access只是锁定并具有通过任务关闭
经理。
我怀疑我需要打开一个浏览器实例，但我是
只是从VB开始（所有都是在需要知道的基础上学习的），所以我对这个有点模糊的
。
更多细节，如果有帮助：我想要做的是去一个
供应商的网站，根据他们的部件号查找他们的描述。我认为我会根据供应商搜索的第一部分构建网址
字符串（与供应商记录一起存储）与部件号连接
（存储在零件记录中）。有数百个部分，所以我想动态构建这个超链接，可能是使用一个按钮并在Visual Basic中连接
的URL。 />
我感谢任何协助或指导....
Alice
-
图书收集术语。偶尔出售的书籍。
http://www.mywingsbooks.com/
I''m hoping someone can tell me what I''m missing about how to open a browser
and go to a website from a button or a link in Access 2000.
I''ve tried designating a field as "Hyperlink type" and typing in an URL.
I''ve tried using the Hyperlink field on the Button Properties sheet, and
I''ve tried using Visual Basic:
Application.FollowHyperlink "html://www.websitename.com",,True
and in all cases, Access just locks up and has to be shut down via the task
manager.
I suspect I need to open an instance of the browser or something, but I''m
only just starting with VB (all learned on a "need to know" basis), so I''m a
little foggy on that.
More details, in case they are helpful: What I''m wanting to do is go to a
vendor''s website and look up their description based on their part number. I
thought I would build the url based on the first part of the vendor''s search
string (stored with the vendor record) concatenated with the part number
(stored on the part record). There are hundreds of parts, so I''d like to
build this hyperlink on the fly, probably using a button and concatenating
the URL in Visual Basic.
I appreciate any assistance or direction....
Alice
--
Book collecting terms illustrated. Occasional books for sale.
http://www.mywingsbooks.com/
推荐答案
也许这只是一个错字
也许这就是你的问题
Application.FollowHyperlink" http：//www.websitename.com" ;, True
Maybe this is just a typo
Maybe it''s you problem
Application.FollowHyperlink "http://www.websitename.com",,True
" lylefair" < LY *********** @ aim.com>在消息中写道
news：11 ********************** @ g44g2000cwa.googlegr oups.com ...
"lylefair" <ly***********@aim.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
也许这只是一个错字
也许这就是你的问题
Application.FollowHyperlink" http：//www.websitename.com" ,,真的
Maybe this is just a typo
Maybe it''s you problem
Application.FollowHyperlink "http://www.websitename.com",,True
我不确定我理解。这个网站并不真实...这只是一个例子
来显示我在代码中所做的事情。你看到了其他一些错字吗？
谢谢。
Alice
I''m not sure I understand. The website isn''t real...that was just an example
to show what I did in the code. Was there some other typo you saw?
Thanks.
Alice
你写了html：//而不是 http：//。
You wrote html:// rather than http://.
这篇关于如何从Access中的链接打开浏览器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
