FollowHyperlink的问题与浏览器中的直接输入地址不同 [英] Issues with FollowHyperlink not acting same a directly typing address in explorer

问题描述

我可以从表单中提供绑定值的地址并将其传递给函数;


但是我不想在表单上单击该值，以便在执行我的函数中所需的操作时识别它。由于表单上的值是从查询派生的，我无法将该值直接传递给函数？


换句话说，我在运行代码宏中放入什么地址调用函数？


funcname（值的查询地址？）


从表单上的列表中调用绑定值时，我键入以下工作：

funcname（表单！formname！objname）


或者我只需从查询中获取SQL并嵌入它在功能中。不想，因为它是一个很长的网址。


感谢您的帮助

I can provide the address for a bound value from a form and pass it into a function;

However I don''t want to click that value on the form for it to be recognized when performing the action desired in my function. Since the value on the form is derived from a query am I not able to pass that value directly to the function?

In other words, what address do I put in my runcode macro when calling up the function?

funcname (query address for value?)

when calling up a bound value from a list on a form, I type the following which works:
funcname (forms!formname!objname)

or do I just have to grab the SQL from the query and embed it in the function. Didn''t want to because it is a long web address.

Thank you for your Help

推荐答案

我'我正在访问一个网站下载共同基金信息。


当我输入地址时，该网站（雅虎财经）询问我是否要打开或保存文件。


但是，当我使用FollowHperlink时，文件会自动在excel中打开，我必须通过一系列SendKeys并等待保存文件以便在我的访问表中上传。


有没有控制我看不到？就好像它增加了一个输入。使用FollowHyperlink时按键，因此打开文件？


或者我坚持这一系列步骤。


提前感谢您的支持帮助

I''m accessing a web site to download mutual fund info.

When I type in the address the site (yahoo finance) asks if I want to open or save file.

However, when I use FollowHperlink the file opens automatically in excel and I have to go thru a series of SendKeys and wait steps to save the file to upload in my access tables.

Is there a control I don''t see? It is like it adds an "enter" keystroke when using FollowHyperlink and therefore opens the file?

Or am I stuck with this series of steps.

Thank you in advance for your help

作为一名化学家，我阅读并遵循了许多非常奇怪且措辞不当的文档...但是，我无法做出你想要的正面或反面......一个更多的尝试请从你给我们的一点点听起来像一个有趣的谜题。

As a chemist I read and follow a lot of very weird and unusally worded documentation... however, I can''t make heads or tails of what you want... one more try please as from what little you have given us does sound like an interesting puzzle.

如果你有一个存储的查询，你可以使用域函数DlookUp，Dmax / Dmin或dcount之一获得价值。


但是正如zmbd所说，你的帖子有点令人困惑。请记住，我们没有在您面前申请，也不知道目的是什么。在点击提交按钮之前花一点时间阅读新鲜的问题是一个好主意。眼睛，并确保它对你自己以外的人有意义。


请记住，从一个好问题中获益最多的人就是你自己。许多专家跳过措辞不好的问题并专注于其他问题。

If you have a stored query you can use one of the domain functions DlookUp, Dmax/Dmin or dcount to get the value.

But as zmbd says, your post is a bit confusing. Please remember that we do not have your application in front of us, nor do we even know what the purpose is. It''s a good idea before hitting that submit button to take a minute to just read through your question with "fresh" eyes and make sure it makes sense to someone besides yourself.

Bear in mind that the one who benefits most from a good question is yourself. Many experts skip poorly phrased question and focus on others.

这篇关于FollowHyperlink的问题与浏览器中的直接输入地址不同的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！