当前用户 [英] current user
问题描述
嗨大家好
我创建了一个驻留在一台计算机上的数据库。
数据库有大约11个用户，我使用ms访问
安全功能创建，这样每个用户都必须使用自己的名字登录和
密码。
在我的表格中，我有一个名为user的字段，在我的表单上用文本
框表示。当存储记录时，我想显示第一次存储该特定记录的用户。我正在使用Access 2000和文本框中的
currentuser（）似乎不起作用
任何帮助将不胜感激
在记录中定义的字段= CurrentUser（）作为其默认值，
为我工作。只有在创建记录时才会更新...它不会是b $ b是上次更新的用户。
你是什么意思文本框中的currentuser（）？如果你澄清，有人
可能会提出一个有用的建议。
Larry Linson
Microsoft Access MVP
" Kay" < KH ****** @ hotmail.com>在消息中写道
news：11 ********************** @ z34g2000cwc.googlegr oups.com ...嗨伙计
我创建了一个驻留在一台计算机上的数据库。
数据库有大约11个用户使用ms访问
安全功能创建的用户，这样每个用户都必须使用自己的名字和密码登录。
在我的表中，我有一个名为user的字段，在我的表单上用文本
框表示。存储记录时，我想显示首先存储该特定记录的用户。我正在使用Access 2000并且文本框中的
currentuser（）似乎不起作用
任何帮助将不胜感激
"凯" < KH ****** @ hotmail.com>在消息中写道
news：11 ********************** @ z34g2000cwc.googlegr oups.com ...嗨伙计
我创建了一个驻留在一台计算机上的数据库。
数据库有大约11个用户使用ms访问
安全功能创建的用户，这样每个用户都必须使用自己的名字和密码登录。
在我的表中，我有一个名为user的字段，在我的表单上用文本
框表示。存储记录时，我想显示首先存储该特定记录的用户。我正在使用Access 2000并且文本框中的
currentuser（）似乎不起作用
任何帮助将不胜感激
你应该能够在文本框的默认值属性中放置
= CurrentUser（）
。
我要去用它来搞砸了一下，但我的意思是我
在文本框的控件来源属性中输入currentuser（）
Hi Guys
I have created a single database that resides on one computer. The
database has about 11 users which I have created using the ms access
security feature so that each user has to login with their own name and
password.
In my table I have a field called user which is represented by a text
box on my form. When storing a record I want to display the user who
first stored that particular record. I am using access 2000 and the
currentuser() in the text box does not seem to work
Any help will be appreciated
A Field defined in the Record with =CurrentUser() as its Default Value has
worked for me. That is only updated when the record is created... it won''t
be "user who last updated".
What do you mean "the currentuser() in the textbox"? If you clarify, someone
may be able to make a useful suggestion.
Larry Linson
Microsoft Access MVP
"Kay" <kh******@hotmail.com> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...Hi Guys
I have created a single database that resides on one computer. The
database has about 11 users which I have created using the ms access
security feature so that each user has to login with their own name and
password.
In my table I have a field called user which is represented by a text
box on my form. When storing a record I want to display the user who
first stored that particular record. I am using access 2000 and the
currentuser() in the text box does not seem to work
Any help will be appreciated
"Kay" <kh******@hotmail.com> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...Hi Guys
I have created a single database that resides on one computer. The
database has about 11 users which I have created using the ms access
security feature so that each user has to login with their own name and
password.
In my table I have a field called user which is represented by a text
box on my form. When storing a record I want to display the user who
first stored that particular record. I am using access 2000 and the
currentuser() in the text box does not seem to work
Any help will be appreciated
You should be able to put
=CurrentUser()
in the Default Value property of the textbox.
Im going to mess about with it a bit furthur but what I meant was I
entered currentuser() in the control source property of the text box
这篇关于当前用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
