MS访问表单问题 [英] MS access form issue

问题描述

我正在使用Access 2003.我正在尝试将查询中的计算值带到表单。我想让查询将值重新带回到表单中。


帮助！

解决方案

你可以像往常一样将文本框绑定到此查询字段，然后在文本框的属性中，将启用设置为否并将锁定设置为是。您的用户将能够在文本框中查看数据，但不能更改它。


问候，

Scott

< blockquote>原谅我是个新手，你怎么绑？我尝试在线搜索，vb的东西超出了我的范围。有通过表达式构建器或属性的方式吗？


再次感谢，

Mike

A当控件源（在表单设计视图中，双击控件，或右键单击并选择属性>所有选项卡）设置为表或查询中的字段时，控件被称为绑定。在同一个选项卡上，您将找到我所提到的Enabled和Locked属性。


如果表单设计视图中相同的控件将显示为未绑定 s控制源设置为空。


问候，

Scott

I am using Access 2003. I am trying to bring a calculated value from a query to a form. I would like to have the query bring the value back to the form as read only.

Help!

解决方案

You can ''bind'' a text box to this query field just as normal, then in the properties for the text box, set Enabled to No and Locked to Yes. Your users will be able to view the data in the text box but not change it.

Regards,
Scott

Forgive me for being a newb, how do you bind? I tried searching online and vb stuff is beyond me. Is there a way thru expression builder or the properties to do it?

Thanks Again,
Mike

A control is said to be ''bound'' when it''s Control Source (in form design view, double click the control, or right click and select properties>All tab) is set to a field in a table or query. On this same tab you will find the Enabled and Locked properties that I referred to also.

The same control will show to be ''Unbound'' in form design view if it''s Control Source is set to nothing.

Regards,
Scott

这篇关于MS访问表单问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！