运行时错误'3061'：参数太少。预期1。 [英] Run-time error '3061': Too few parameters. Expected 1.

问题描述

您好！我需要一些关于我的代码的专业建议。我无法看到问题出在哪里

Hello! I need some professional advice on my codes. I can't see where the problem is here

  
 CurrentDb.Execute "DELETE FROM Subject " & _
 " WHERE SubjCode=" & Me.frmSubjSub.Form.Recordset.Fields("SubjCode")

它说它的参数太少，预期1.其中"主题"表是"SubjCode"和"SubjCode"。是一个字段名。

It says it has too few parameters, expected 1. where "Subject" is a Table and "SubjCode" is a field name.

推荐答案

嗨。只是猜测，但尝试这样做：

Hi. Just a guess but try doing it this way instead:

CurrentDb.Execute" DELETE FROM Subject WHERE SubjCode ='" &安培; Me.frmSubjSub.Form！SubjCode& "'"，dbFailOnError

CurrentDb.Execute "DELETE FROM Subject WHERE SubjCode='" & Me.frmSubjSub.Form!SubjCode & "'", dbFailOnError

假设SubjCode是一个文本字段。如果它是数字，只需取出我添加的单引号。希望有所帮助......

That assumes SubjCode is a Text field. If it's numeric, just take out the single quotes I added. Hope that helps...

这篇关于运行时错误'3061'：参数太少。预期1。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！