多选列表框3075语法错误 [英] Multi-Select List Box 3075 Syntax Error
问题描述
美好的一天，我正在为一个标准的
问题清单数据库的多选列表框工作，我遇到了语法错误
代码我似乎无法纠正。我还会注意到，我使用Allen Browne的多选列表框作为指南我是b $ b。我还要注意我的访问技巧不是最好的所以我可能需要
对某些事情进行一些解释。
首先让我给出一些关于数据库的背景知识：
我有一个题为按类别排序的问题的查询，其中包含以下
字段
类别.ID
标准Questions.SubCategory1
标准问题。问题
我玩了一些代码以确保所有字段
都被更改为与我的数据库匹配，但我在下面的行中遇到语法
错误3075：
strWhere =" [ID] IN（& Left $（strWhere，lngLen）&"）"
我在这里搜索了一下，但是实际上找不到
任何符合同样问题的东西。如果有人可以建议我会给b $ b非常感谢。如果需要任何其他信息，请
不要犹豫。
谢谢，
Tim
Good day all, I am working on a multi-select list box for a standard
question checklist database and I am running into a syntax error in
the code that I cannot seem to correct. I will also note that I am
using Allen Browne''s multi-select list box for a report as a guide. I
should also note that my access skills are not the best so I may need
some explaining on certain things.
First let me give some background on the database:
I have a query titled Questions By Category that has the following
fields in it
Categories.ID
Standard Questions.SubCategory1
Standard Questions.Question
I played around with the code a little bit to make sure all fields
were changed to match my database, but I am running into a syntax
error 3075 on the following line:
strWhere = "[ID] IN (" & Left$(strWhere, lngLen) & ")"
I searched around a little bit on here, but couldn''t really find
anything that matched this same problem. If anyone could advise I''d
greatly appreciate it. If any additional information is needed please
do not hesitate to ask.
Thank You,
Tim
推荐答案
（strWhere，lngLen）& ）"
我在这里搜索了一下，但是找不到任何与此相同问题的b $ b。如果有人可以建议我会给b $ b非常感谢。如果需要任何其他信息，请
不要犹豫。
谢谢，
Tim
(strWhere, lngLen) & ")"
I searched around a little bit on here, but couldn''t really find
anything that matched this same problem. If anyone could advise I''d
greatly appreciate it. If any additional information is needed please
do not hesitate to ask.
Thank You,
Tim
tr******@gmail.com 写道：
tr******@gmail.com wrote:
美好的一天，我正在为一个标准的
问题清单数据库的多选列表框工作，我遇到了语法错误
我似乎无法纠正的代码。我还会注意到，我使用Allen Browne的多选列表框作为指南我是b $ b。我还要注意我的访问技巧不是最好的所以我可能需要
对某些事情进行一些解释。
首先让我给出一些关于数据库的背景知识：
我有一个题为按类别排序的问题的查询，其中包含以下
字段
类别.ID
标准Questions.SubCategory1
标准问题。问题
我玩了一些代码以确保所有字段
都被更改为与我的数据库匹配，但我在下面的行中遇到语法
错误3075：
strWhere =" [ID] IN（& Left
Good day all, I am working on a multi-select list box for a standard
question checklist database and I am running into a syntax error in
the code that I cannot seem to correct. I will also note that I am
using Allen Browne''s multi-select list box for a report as a guide. I
should also note that my access skills are not the best so I may need
some explaining on certain things.
First let me give some background on the database:
I have a query titled Questions By Category that has the following
fields in it
Categories.ID
Standard Questions.SubCategory1
Standard Questions.Question
I played around with the code a little bit to make sure all fields
were changed to match my database, but I am running into a syntax
error 3075 on the following line:
strWhere = "[ID] IN (" & Left
（strWhere，lngLen）&"）"
我在这里搜索了一下，但是找不到任何匹配同样问题的b $ b。如果有人可以建议我会给b $ b非常感谢。如果需要任何其他信息，请
请不要犹豫。
谢谢，
Tim
(strWhere, lngLen) & ")"
I searched around a little bit on here, but couldn''t really find
anything that matched this same problem. If anyone could advise I''d
greatly appreciate it. If any additional information is needed please
do not hesitate to ask.
Thank You,
Tim
如果在子例程中有一个OnError语句，则在'/ b $ b前面加上'On $。当代码中断时，您应该能够通过将光标放在那些
字上来查看strWhere和lngLen的值。或者你可以输入
Debug.Print" strWhere" &安培; strWhere
Debug.Print" lngLen" &安培; lngLen
Debug.Print" [ID] IN（"& Left
If you have an OnError statement in the subroutine put a '' in front of
the word OnError. When the code breaks on the line you should be able
to see the value of strWhere and lngLen by placing the cursor over those
words. Or you could enter
Debug.Print "strWhere " & strWhere
Debug.Print "lngLen " & lngLen
Debug.Print "[ID] IN (" & Left
这篇关于多选列表框3075语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
