错误-2147217904 - 如何修复：o（？ [英] error -2147217904 - how to fix :o( ?

问题描述

使用ADODB记录集。尝试使用.open方法

SQL使用表单中的数据[Forms]！[Form1]！[txtQuantity]

如果我直接用数字替换那么没问题。

按原样，我收到错误-2147217904，我收集的内容可能是

与引号有关。 Pleeeease帮助，应该是什么原因

非常简单的模拟取决于

：o（

using ADODB recordset. trying to use the .open method
SQL uses data from a form [Forms]![Form1]![txtQuantity]
If I replace directly with a number then no problem.
As is, I get error -2147217904 which I gather is likely to be something
to do with quotation marks. Pleeeease help, what was supposed to be a
very simple mock up is taking for ever
:o(

推荐答案

向我们展示所有代码。

或

等待猜测者，读者，先见者，巫师等等。 />

Show us All the code.
or
Wait for the guessers, mind-readers, seers, wizards etc.

Dim rs As New ADODB.Recordset

rs.Open" SELECT LowerQuantity FROM tblQuantityPriceBands WHERE

LowerQuantity< = [Forms]！[Form1]！[txtQuantity]"，

CurrentProject.Connection，adOpenKeyset，adLockOptimistic，adCmdText

Dim rs As New ADODB.Recordset
rs.Open "SELECT LowerQuantity FROM tblQuantityPriceBands WHERE
LowerQuantity <= [Forms]![Form1]![txtQuantity]",
CurrentProject.Connection, adOpenKeyset, adLockOptimistic, adCmdText

建议


s.Open" SELECT LowerQuantity from tblQuantityPriceBands WHERE

LowerQuantity< ="& [Forms]！[Form1] ！[txtQuantity]

Suggest

s.Open "SELECT LowerQuantity FROM tblQuantityPriceBands WHERE
LowerQuantity <= " & [Forms]![Form1]![txtQuantity]

这篇关于错误-2147217904 - 如何修复：o（？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！