救助：SQL查询出错

yaozi

SQL = "SELECT 组别.组别" & _
"FROM 组别" & _
"WHERE 组别.编号 = 1"
DoCmd.RunSQL SQL

此语句在查询里面可用，可在VBA里提示“语法错误（操作符丢失）”

wanshan

选择查询不能用在vba中

方漠

RUNSQL 的用法有误, 具体请参见SQL的几种操作. SELECT是一个选择性的抽取数据操作,本身对数据不会有改动.RUNSQL不支持此类. 如果需要,可以定义一个QUERYDEF,修改其SQL就行.

RunSQL Method
See AlsoApplies ToExampleSpecificsThe RunSQL method carries out the RunSQL action in Visual Basic.

expression.RunSQL(SQLStatement, UseTransaction)
expression    Required. An expression that returns one of the objects in the Applies To list.

SQLStatement   Required Variant. A string expression that's a valid SQL statement for an action query or a data-definition query. It uses an INSERT INTO, DELETE, SELECT...INTO, UPDATE, CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE INDEX, or DROP INDEX statement. Include an IN clause if you want to access another database.

UseTransaction   Optional Variant. Use True (–1) to include this query in a transaction. Use False (0) if you don't want to use a transaction. If you leave this argument blank, the default (True) is assumed.

holywinds

句尾   ；

?

rower

楼主的问题解决了吗?

IDEA

不要分段，连成一行呢？

rjacky

注意关键字前后的空格