Nz功能不起作用 [英] Nz function not working

问题描述

您好，

我有一个用户登录ACCESS DB的登录表单。

用户名和密码取自当前登录的windows的用户。


我把以下内容作为

用户名文本框的默认值，工作正常。

（取当前登录用户并将其打入txtusername）

Hi there,
I have a log in form that users use to log in to the ACCESS DB.
The username and password are taken from the current logged in user of the windows.

I have put the following as the default value for the
username text box which works fine.
( Takes the current logged in user and punches it into txtusername)

展开 | 选择 | Wrap | 行号

推荐答案

你好，我不知道你的问题的答案。

但我会请问你一些问题。

你的表单会自动使用ENVIRON函数获取当前用户的Windows用户名，然后用户输入密码并检查代码是否是正确的密码（同一个密码）用户登录Windows）。

这是正确的吗？

如果是这样，你能告诉我你是如何设置密码检查程序的吗？ />
Tnx很多！


Tnx！

Hi there, I don''t know the answer to your question.
But I would like to ask you something.
Your form takes the current user''s Windows username automatically with ENVIRON function, then user enters the password and code checks if it''s correct password (the same one that user uses to login to Windows).
Is this correct?
If so, could you tell me how did you setup the procedure for the password to be checked?
Tnx a lot!

Tnx!

我认为你的主题标题有点误导，因为你的问题真的不是'' Nz（）功能不起作用，而 Environ（）正在工作！


我怀疑错误的工作站要么运行新版本的Access，要么有人已经使用他们的设置。在v2003中，Microsoft引入了沙盒模式。基本上保护人们免受自己的伤害在此模式下，访问保护模式。你不允许危险的要运行的表达式。不幸的是，Access显然认为它自己的功能 Environ（）和 CurDir（）是危险的。并阻止他们！


您可以选择通过将宏安全级别设置为低来禁用沙盒模式。


Linq ; 0）>

I think your thread title is somewhat misleading as your problem really isn''t that the Nz() function is not working but rather that Environ() is working!

I suspect that the errant workstations are either running new versions of Access or someone has diddled with their settings. With v2003 Microsoft introduced the "Sandbox Mode" to basically protect people from themselves! Under this mode Access "protects" you by not allowing "dangerous" expressions to run. Unfortunately, Access apparently considers its own functions Environ() and CurDir() to be "dangerous" and blocks them as well!

You have the option of disabling Sandbox Mode by setting the macro security level to Low.

Linq ;0)>

感谢missling的标题更正，我的错... .. >

好​​的，关于doma23提出的问题，好吧，回答一下，我有一个API函数来处理检索Windows密码和用户（当前登录）。它比较，如果currentuser = formuser和currentpassword = formpassord然后验证成功。


就我而言，这个功能很好。


我已经通过将宏安全级别设置为低来禁用沙盒模式但这没有解决。


还有其他任何建议吗？

Thanks missingling for the title correction, my fault..

Ok, regarding what doma23 raises, well, to answer that,I have a API function that deals with retrieving windows password and users (currently logged in). It compares, if currentuser=formuser and currentpassword=formpassord then validation successful.

That function is fine as far as I am concerned.

I already disabled the Sandbox Mode by setting the macro security level to Low but this does not solve.

Any other suggestion?

这篇关于Nz功能不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！