Querydef参数问题 [英] Querydef parameters issue

问题描述

我的问题是我的代码似乎没有将参数值传递给查询。我的访问权限不是很高，所以我不确定它出了什么问题。

展开 | 选择 | 换行 | 行号

解决方案

我的问题是我的代码似乎没有将参数值传递给查询。我的访问权限不是很高，所以我不确定它出了什么问题。

展开 | 选择 | 换行 | 行号

< blockquote>感谢您的回复。我试过切换你建议的线，但似乎没有解决任何问题。我在想通过网络获取帮助会有所帮助。您是否对有用的阅读材料有任何建议，详细介绍了querydef，以便我更好地了解它们是如何工作的？


Eric

在应用Adezii的建议后，您是否收到完全相同的错误消息？


您是否正在运行来自frm1BuildDescrTabOuterTable的代码？如果是这样，你有没有尝试用''我'替换''[Forms]！frm1BuildDescrTabOuterTable''？ （虽然我不认为这会有所作为）。

如果没有，代码运行时表格frm1BuildDescrTabOuterTable会打开吗？


James

My problem is that my code doesn''t seem to be passing the parameter values to the query. I''m not very profiencient in access so i''m not sure where its going wrong.

Expand|Select|Wrap|Line Numbers

解决方案

My problem is that my code doesn''t seem to be passing the parameter values to the query. I''m not very profiencient in access so i''m not sure where its going wrong.

Expand|Select|Wrap|Line Numbers

Thanks for the reply. I''ve tried switching the the lines you suggested but it didn''t seem to solve anything. I''m thinking this is going to be a little to involved for help over the web. Do you have any suggestions on Helpful reading material that covers querydefs in detail so i can better understand how they work?


Eric

Do you get the exact same error messages after applying Adezii''s suggestions?

Are you running code from frm1BuildDescrTabOuterTable? If so, have you tried replacing ''[Forms]!frm1BuildDescrTabOuterTable'' with ''Me''? (though I wouldn''t think that would make a difference).
If not, is the form ''frm1BuildDescrTabOuterTable'' open when your code runs?

James

这篇关于Querydef参数问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！