来自组合框数据 - >使用用户名和密码打开网站 [英] from combo box data - > Open website with username and password
问题描述
我有一个带有名为cmbWebsites的组合框的表单。
组合框行源来自返回行的选择查询：
0.WebsiteID
1.网站名称
2.网站URL
3.Username
4.Password
仅限网站名称出现在组合框中。其他列设置为零长度。
当用户选择网站时，AfterUpdate事件将触发代码以构建包含所选网站的URL，用户名和密码的字符串，并通过FollowHyperlink方法运行它。
我唯一不知道怎么做的是格式化超链接，以便网站接受用户名和密码并自动获取进入网站;就像Roboform一样。
即使这不是纯粹的MS Access问题，我也无法想象其他Access开发者也没有做过类似的事情。 />
有谁知道如何使用用户名和密码格式化URL，因此FollowHyperlink方法会自动进入网站？
谢谢，
Adam
I have a form with a combo box called "cmbWebsites".
The combo box row source comes from a select query that returns rows:
0.WebsiteID
1.Website Name
2.Website URL
3.Username
4.Password
Only "Website Name" appears in the combo box. The other columns are set to zero length.
When the user selects a website, the AfterUpdate event will trigger code to build a string that contains the URL, Username and Password of the selected website, and runs it through the FollowHyperlink method.
The only thing I don''t know how to do is format the hyperlink so the websites will accept the username and password and automatically get me into the site; like "Roboform".
Even though this isn''t a pure MS Access question, I can''t imagine that other Access developers haven''t done something similar.
Does anyone know how to format a URL with Username and Password, so the FollowHyperlink method automatically gets you into the site?
Thanks,
Adam
推荐答案
@AdamOnAccess
我猜将取决于网站所需的格式。例如，我有一个地址按钮用于我的地址，我打开谷歌地图显示我的联系人行车路线。我发送给谷歌地图的字符串是基于它们的格式。
我还检索来自众多网站的股票和索引信息，但它们要求我以特定语法传递字符串。 />
您需要弄清楚网站所期望的语法是什么，并执行类似的操作：
@AdamOnAccess
I guess that would depend on the format that the Web site requires. For instance I have a map button for my addresses and I open a google map to display my contacts driving directions. The string I send to google maps is based on their format.
I also retrieve stock and index indormation from numerous sites but they require me to pass a string in a certain syntax.
All you need to figure out is what syntax the site expects and do something like so:
mshmyob，
感谢您的回复。我知道我需要这种格式，但我想也许有某种标准的格式。用于用户名和密码。你熟悉这个程序，Roboform。它维护您选择的任何站点的用户名和密码。只需单击一个按钮，它就会存储URL，用户名和密码。当您想要返回该站点时，只需单击它即可。在没有事先了解格式的情况下，Roboform如何设法将用户名和密码发送到任何网站？
必须有一些标准的方法来执行此操作。任何人都知道怎么做？
-Adam
mshmyob,
Thanks for the reply. I know I need the format, but I was thinking that perhaps there was some kind of "standard" for usernames and passwords. Are you familiar with the program, "Roboform". It maintains usernames and passwords for any site you choose. Just click a button, and it stores the URL, username and password. When you want to return to the site, you just click it and in you go. How does Roboform manage to send usernames and passwords to ANY website without first knowing the format?
There must be some standard way to do this. Any one know how?
-Adam
我不熟悉RoboForm Adam，但是根据你自己的描述，似乎它每个站点都拥有它。我希望它以某种方式确定使用格式（并将其与您的用户名和密码存储在其数据库中）。我当然认为（没有一位伟大的专家可以肯定，所以不要把它作为福音），Mshmyob虽然在这方面也是正确的。
I''m not familiar with RoboForm Adam, but from your own description, it seems that it holds it per site. I expect it determines the format from usage somehow (and stores it with your username and password in its database). I certainly think (no great expert at this to be sure so don''t take as gospel) that Mshmyob is on the right lines with this though.
这篇关于来自组合框数据 - >使用用户名和密码打开网站的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
