访问XP的怪异...... [英] Access XP weirdness ...
问题描述
我不知道这是否与在终端上运行的AccessXP有关
还安装了Access97 / 2000的服务，但这里有一个例子
不再有效的查询：
SELECT DLookUp（" MajorCategory"，" AutoTypes"，" [autoType] =''1''"）AS
MajorCategory，PreOwned.PaintColor
来自PreOwned;
当我尝试运行上述查询时出现以下错误：
未知功能名称
如果我从即时窗口执行完全相同的dlookup，那么正确的
数据是返回时没有错误。
有什么建议吗？在此之后，我头上留下的头发很少!!!
谢谢，
- 特里
---
外发邮件经过无病毒认证。
由AVG反病毒系统检查（ http://www.grisoft.com）。
版本：6.0.516 /病毒库：313 - 发布日期：9 / 2/2003
I don''t know if this has anything to do with AccessXP running on Terminal
Services with Access97/2000 also installed, but here is one example of a
query that does not work any longer:
SELECT DLookUp("MajorCategory","AutoTypes","[autoType]=''1''") AS
MajorCategory, PreOwned.PaintColor
FROM PreOwned;
When I try to run the above query I get the following error:
UNKNOWN FUNCTION NAME
If I execute the exact same dlookup from the immediate window, the proper
data is returned with no error.
Any suggestions? I have very little hair left on my head after this!!!
Thanks,
--Terry
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
推荐答案
即使名称中没有空格，我认为它需要在字段名称周围括号。
DLookUp（" [MajorCategory]"，" Auto Types"，[auto Type] =''1''"）
-
Wayne Morgan
Microsoft Access MVP
" JustMe" < TE ****** @ sasktel.net>在消息新闻中写道：vp ************ @ corp.supernews.com ...
Even without a space in the name, I think it wants brackets around the field name.
DLookUp("[MajorCategory]", "Auto Types", [auto Type]=''1''")
--
Wayne Morgan
Microsoft Access MVP
"JustMe" <te******@sasktel.net> wrote in message news:vp************@corp.supernews.com...
我不知道这是否与AccessXP运行有关在终端上
也安装了Access97 / 2000的服务，但这是一个不再起作用的
查询示例：
SELECT DLookUp（" MajorCategory"，"） ; AutoTypes"，" [autoType] =''1''"）AS
MajorCategory，PreOwned.PaintColor
FROM PreOwned;
当我尝试运行以上查询我收到以下错误：
未知功能名称
如果我从即时窗口执行完全相同的dlookup，则返回正确的
数据，没有错误。
有什么建议吗？在此之后我头上留下的头发很少!!!
谢谢，
- 特里
---
外发邮件已通过认证无病毒。
由AVG反病毒系统检查（ http：//www.grisoft。 com）。
版本：6.0.516 /病毒数据库：313 - 发布日期：2003年9月2日
I don''t know if this has anything to do with AccessXP running on Terminal
Services with Access97/2000 also installed, but here is one example of a
query that does not work any longer:
SELECT DLookUp("MajorCategory","AutoTypes","[autoType]=''1''") AS
MajorCategory, PreOwned.PaintColor
FROM PreOwned;
When I try to run the above query I get the following error:
UNKNOWN FUNCTION NAME
If I execute the exact same dlookup from the immediate window, the proper
data is returned with no error.
Any suggestions? I have very little hair left on my head after this!!!
Thanks,
--Terry
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
Hi Wayne ...
感谢您的回复。我尝试用括号
围绕所有字段，但没有成功。我仍然收到UNKNOWN FUNCTION NAME错误。
还有其他建议吗？任何人？
同样的查询在运行AccessXP的其他机器上运行正常。我试过了
卸载/重新安装XP。我已经尝试了我能想到的一切。
帮助！
" Wayne Morgan" <共*************************** @ hotmail.com>在消息中写道
新闻：a8 ******************* @ newssvr33.news.prodigy。 com ...
Hi Wayne ...
Thanks for your reply. I tried surrounding ALL the fields with brackets
with no success. I still get the UNKNOWN FUNCTION NAME error.
Any other suggestions? Anyone?
The same query works fine on other machines running AccessXP. I''ve tried
uninstalling/reinstalling XP. I''ve tried everything I can think of.
Help!
"Wayne Morgan" <co***************************@hotmail.com> wrote in message
news:a8*******************@newssvr33.news.prodigy. com...
即使名称中没有空格，我认为它需要围绕
字段名称的括号。
DLookUp（" [MajorCategory]"，"自动类型，[自动键入] =''1''"）
- 韦恩摩根
Microsoft Access MVP
" JustMe" < TE ****** @ sasktel.net>在消息中写道
Even without a space in the name, I think it wants brackets around the field name.
DLookUp("[MajorCategory]", "Auto Types", [auto Type]=''1''")
--
Wayne Morgan
Microsoft Access MVP
"JustMe" <te******@sasktel.net> wrote in message
news：vp ************ @ corp.supernews.com ...
news:vp************@corp.supernews.com...
我不知道这是否与在
上运行的AccessXP有任何关系也安装了Access97 / 2000的终端服务，但这里有一个不起作用的
查询示例更长：
SELECT DLookUp（MajorCategory，AutoTypes，[autoType] =''1''"）AS
MajorCategory，PreOwned.PaintColor
FROM PreOwned;
当我尝试运行上述查询时，我收到以下错误：
未知的功能名称
如果我执行从即时窗口完全相同的dlookup，
正确的数据返回没有错误。
有什么建议吗？在此之后我头上留下的头发很少!!!
谢谢，
- 特里
---
外发邮件已通过认证无病毒。
由AVG反病毒系统检查（ http：//www.grisoft。 com）。
版本：6.0.516 /病毒数据库：313 - 发布日期：2003年9月2日
I don''t know if this has anything to do with AccessXP running on Terminal Services with Access97/2000 also installed, but here is one example of a
query that does not work any longer:
SELECT DLookUp("MajorCategory","AutoTypes","[autoType]=''1''") AS
MajorCategory, PreOwned.PaintColor
FROM PreOwned;
When I try to run the above query I get the following error:
UNKNOWN FUNCTION NAME
If I execute the exact same dlookup from the immediate window, the proper data is returned with no error.
Any suggestions? I have very little hair left on my head after this!!!
Thanks,
--Terry
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
---
外发邮件经过无病毒认证。
由AVG反病毒系统检查（ http://www.grisoft.com）。
版本：6.0.516 /病毒库：313 - 发布日期：2003年9月2日
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
顺便说一句，完全相同的查询在相同的
机器上的Access 97中工作正常。 />
Terry
" JustMe" < TE ****** @ sasktel.net>在消息中写道
news：vp ************ @ corp.supernews.com ...
By the way, the exact same query works fine in Access 97 on the same
machine.
Terry
"JustMe" <te******@sasktel.net> wrote in message
news:vp************@corp.supernews.com...
嗨Wayne ...
感谢您的回复。我尝试用括号
围绕所有字段，但没有成功。我仍然收到UNKNOWN FUNCTION NAME错误。
还有其他建议吗？任何人？
同样的查询在运行AccessXP的其他机器上运行正常。我试过卸载/重新安装XP。我已经尝试了所有我能想到的东西。
帮助！
Wayne Morgan <共*************************** @ hotmail.com>写在
消息新闻：a8 ******************* @ newssvr33.news.prodigy。 com ...
Hi Wayne ...
Thanks for your reply. I tried surrounding ALL the fields with brackets
with no success. I still get the UNKNOWN FUNCTION NAME error.
Any other suggestions? Anyone?
The same query works fine on other machines running AccessXP. I''ve tried
uninstalling/reinstalling XP. I''ve tried everything I can think of.
Help!
"Wayne Morgan" <co***************************@hotmail.com> wrote in message news:a8*******************@newssvr33.news.prodigy. com...
即使名称中没有空格，我认为它需要围绕
Even without a space in the name, I think it wants brackets around the
字段名称的括号。
field name.
DLookUp（" [MajorCategory]"，Auto Types，[auto Type] =''1''"）
-
Wayne Morgan
Microsoft访问MVP
" JustMe" < TE ****** @ sasktel.net>在消息中写道
DLookUp("[MajorCategory]", "Auto Types", [auto Type]=''1''")
--
Wayne Morgan
Microsoft Access MVP
"JustMe" <te******@sasktel.net> wrote in message
新闻：vp ************ @ corp.supernews.com ...
news:vp************@corp.supernews.com...
我不知道这是否与安装了Access97 / 2000的终端服务上运行的AccessXP有关，但这里是
a查询的一个示例，它不再起作用：
SELECT DLookUp（" MajorCategory"，" AutoTypes"，" [autoType] =''1''"）AS
MajorCategory，PreOwned.PaintColor
FROM PreOwned;
当我尝试运行上面的查询时，我收到以下错误：
未知的功能名称
如果我从即时窗口执行完全相同的dlookup，返回正确的数据，没有错误。
有什么建议吗？
之后，我头上留下的头发很少!!!
谢谢，
- 特里
---
外发邮件已通过认证无病毒。
由AVG反病毒系统检查（ http：//www.grisoft。 com）。
版本：6.0.516 /病毒数据库：313 - 发布日期：2003年9月2日
I don''t know if this has anything to do with AccessXP running on Terminal Services with Access97/2000 also installed, but here is one example of a query that does not work any longer:
SELECT DLookUp("MajorCategory","AutoTypes","[autoType]=''1''") AS
MajorCategory, PreOwned.PaintColor
FROM PreOwned;
When I try to run the above query I get the following error:
UNKNOWN FUNCTION NAME
If I execute the exact same dlookup from the immediate window, the proper data is returned with no error.
Any suggestions? I have very little hair left on my head after this!!!
Thanks,
--Terry
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
---
发送邮件经过无病毒认证。
由AVG反病毒系统检查（ http://www.grisoft.com）。
版本：6.0.516 /病毒库：313 - 发布日期：2003年9月2日
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
---
外发邮件已通过无病毒验证。
由AVG反病毒系统检查（ http://www.grisoft.com）。
版本：6.0.516 /病毒数据库：313 - 发布日期：2003年9月2日
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.516 / Virus Database: 313 - Release Date: 9/2/2003
这篇关于访问XP的怪异......的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
