Access 编程急问!!小问题一个 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Access 编程急问!!小问题一个

Access 编程急问!!小问题一个# Database - 数据库

l*u2005-08-02 07:08

1 楼

mstrSQL = "SELECT * FROM Household Where " _
& "Group like '*" & DoubleQuote(Me![cboSelect]) & "*'" _
& "AND Interest like '*" & DoubleQuote(Me![ComboSelect2]
) & "*'"
table: Household
想实现从table household 选出所有records, household.group 等于组合框 cboselec
的等于零值,household.interest 等于组合框架comboSelect2的值.上面
上面那个执行不通,对VB的语法不熟,大家给看看哪写错了.

a*t2005-08-02 07:08

2 楼

I haven't done VB in a while, it's hard for me to decode this into pure SQL
if you just print out mstrSQL, what is the sql statement? does the statement
itself run ok?

_
ComboSelect2]
cboselec

【在 l********u 的大作中提到】

: mstrSQL = "SELECT * FROM Household Where " _
: & "Group like '*" & DoubleQuote(Me![cboSelect]) & "*'" _
: & "AND Interest like '*" & DoubleQuote(Me![ComboSelect2]
: ) & "*'"
: table: Household
: 想实现从table household 选出所有records, household.group 等于组合框 cboselec
: 的等于零值,household.interest 等于组合框架comboSelect2的值.上面
: 上面那个执行不通,对VB的语法不熟,大家给看看哪写错了.