A97：设置dbs = CurrentDb设置rst = dbs.OpenRecordset（MySQL）第二行产生错误“参数太少” [英] A97: Set dbs = CurrentDb Set rst = dbs.OpenRecordset(MySQL) 2nd line yields error "Too few parms"
问题描述
如果这是MySQL设置的......
SELECT DISTINCTROW qryVehiclesNowners5.SerialNum，
qryVehiclesNowners5.VDescr，qryVehiclesNowners5.Owner，
qryVehiclesNowners5.VehicleJobID，tblVehicleJobs.Reclaimed，
tblVehicleJobs.VSaleID，tblVehicleJobs.ENF262Written FROM
qryVehiclesNowners5 INNER JOIN tblVehicleJobs ON
qryVehiclesNowners5.VehicleJobID = tblVehicleJobs.VehicleJobID WHERE
（tblVehicleJobs.Reclaimed = No AND tblVehicleJobs.VSaleID Is Null AND
tblVehicleJobs.ENF262Written = True）;
运行时究竟会导致以下几行导致以下
错误？
10设置dbs = CurrentDb
20设置rst = dbs.OpenRecordset（MySQL）
错误：在Form Form_Open中发生以下意外错误，
第20行，frmVehicleChooserForm上的CBF。
3061：参数太少。预期5.
我的查询是否过于复杂？
If this is what MySQL is set to...
SELECT DISTINCTROW qryVehiclesNowners5.SerialNum,
qryVehiclesNowners5.VDescr, qryVehiclesNowners5.Owner,
qryVehiclesNowners5.VehicleJobID , tblVehicleJobs.Reclaimed,
tblVehicleJobs.VSaleID, tblVehicleJobs.ENF262Written FROM
qryVehiclesNowners5 INNER JOIN tblVehicleJobs ON
qryVehiclesNowners5.VehicleJobID = tblVehicleJobs.VehicleJobID WHERE
(tblVehicleJobs.Reclaimed=No AND tblVehicleJobs.VSaleID Is Null AND
tblVehicleJobs.ENF262Written=True);
What exactly would cause the following lines to cause the following
error when run?
10 Set dbs = CurrentDb
20 Set rst = dbs.OpenRecordset(MySQL)
Error: The following unexpected error occurred in Sub Form_Open,
line #20, CBF on frmVehicleChooserForm.
3061: "Too few parameters. Expected 5."
Is my query too complex?
推荐答案
MLH < CR ** @ NorthState.net> schreef在bericht新闻：6p ******************************** @ 4ax.com ...
"MLH" <CR**@NorthState.net> schreef in bericht news:6p********************************@4ax.com...
如果这是MySQL设置的......
SELECT DISTINCTROW qryVehiclesNowners5.SerialNum，
qryVehiclesNowners5.VDescr，qryVehiclesNowners5.Owner，
qryVehiclesNowners5.VehicleJobID，tblVehicleJobs.Reclaimed，
tblVehicleJobs.VSaleID，tblVehicleJobs.ENF262Written来自
qryVehiclesNowners5 INNER JOIN tblVehicleJobs ON
qryVehiclesNowners5.VehicleJobID = tblVehicleJobs.VehicleJobID WHERE
（tblVehicleJobs.Reclaimed = No AND tblVehicleJobs.VSaleID Is Null AND
tblVehicleJobs.ENF262Written = True）;
运行时究竟会导致以下几行导致以下错误？
10设置dbs = CurrentDb
20设置rst = dbs.OpenRecordset（MySQL）
错误：在Form Form_Open，
第20行，frmVehicleChooserForm上的CBF中发生以下意外错误。
3061： 参数太少。预期5.
我的查询是否过于复杂？
If this is what MySQL is set to...
SELECT DISTINCTROW qryVehiclesNowners5.SerialNum,
qryVehiclesNowners5.VDescr, qryVehiclesNowners5.Owner,
qryVehiclesNowners5.VehicleJobID , tblVehicleJobs.Reclaimed,
tblVehicleJobs.VSaleID, tblVehicleJobs.ENF262Written FROM
qryVehiclesNowners5 INNER JOIN tblVehicleJobs ON
qryVehiclesNowners5.VehicleJobID = tblVehicleJobs.VehicleJobID WHERE
(tblVehicleJobs.Reclaimed=No AND tblVehicleJobs.VSaleID Is Null AND
tblVehicleJobs.ENF262Written=True);
What exactly would cause the following lines to cause the following
error when run?
10 Set dbs = CurrentDb
20 Set rst = dbs.OpenRecordset(MySQL)
Error: The following unexpected error occurred in Sub Form_Open,
line #20, CBF on frmVehicleChooserForm.
3061: "Too few parameters. Expected 5."
Is my query too complex?
您什么时候收到此错误？ 2分钟前？
如果您使用cdma进行谷歌搜索参数太少你会得到约。 1,280个答案
Arno R
When did you get this error? 2 minutes ago?
If you do a Google search in cdma for "too few parameters" you will get approx. 1,280 answers
Arno R
做下文
5 debug.Print MySql
do the follwing
5 debug.Print MySql
10设置dbs = CurrentDb
20设置rst = dbs.OpenRecordset（MySQL）
10 Set dbs = CurrentDb
20 Set rst = dbs.OpenRecordset(MySQL)
当你得到错误，请注意sql在调试窗口中的位置。拿那个
sql，然后将其剪切/粘贴到一个新的空白查询中。
它会运行吗？
-
Albert D. Kallal（访问MVP）
加拿大艾伯塔省埃德蒙顿
pl ***************** @ msn.com
http://www.members.shaw.ca/AlbertKallal
对不起，Arno，但谷歌上的大多数点击似乎概括了
关于表单控件的引用。我的SQL没有那个
所以我仍然处于黑暗中，就像我2分钟前一样，因为你提到了
。你知道在这样的情况下该怎么做。我不是要求你做谷歌搜索，因为我完全有能力这样做。
这样做。我问你是否知道答案？你呢？
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Sorry, Arno, but most of those hits on google seem to generalize
about references to controls on a form. My SQL has none of that
so I am still in the dark as much as I was 2 minutes ago, as you
mentioned. Do you know what to do in a case like that. I''m not
asking you to do a google search, as I am perfectly capable of
doing that. I''m asking you if you know the answer? Do you?
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
你什么时候收到这个错误的？ 2分钟前？
如果您使用cdma进行谷歌搜索参数太少你会得到约。 1,280个答案
Arno R
When did you get this error? 2 minutes ago?
If you do a Google search in cdma for "too few parameters" you will get approx. 1,280 answers
Arno R
这篇关于A97：设置dbs = CurrentDb设置rst = dbs.OpenRecordset（MySQL）第二行产生错误“参数太少”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
