数据表中的垂直冻结窗格 [英] Vertical Freeze Pane in Datasheet
本文介绍了数据表中的垂直冻结窗格的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
您好，
数据表中有冻结窗格功能，但仅适用于水平滚动。
垂直滚动怎么样？
我需要实现这一点，以便能够通过向上和向下滚动查看每列的总数据，但保持总数据的视图。
打电话给所有Access大师寻求帮助。
- = kerinus = -
Hello,
There''s a freeze pane function in datasheet but for horizontal scroll only.
How about for the vertical scroll?
I need to implement this to be able to view the total data of each column by scrolling up and down but maintaining the view of the total data.
Calling all the Access gurus for help.
-= kerinus =-
推荐答案
嗨kerinus。不可能冻结一行并仍然滚动其他行。
如果你在追踪的是你在滚动数据时屏幕上剩余的一组总数，你可以通过使用连续表单的页眉或页脚区域来包含未绑定的文本框来实现此功能，每一个你需要的一个。每个未绑定文本框的控制源只是
= sum（[你要求的字段]）
这是用于在报告中生成组总计和总计的相同技术。
附加了为此目的使用页脚的示例。底部的总计是未绑定的控件，当滚动详细信息行时，这些控件仍保留在视图中。
请注意，这在数据表视图中无法完成，因为表单页眉/页脚区域在该视图中不可见。
-Stewart
Hi kerinus. It is not possible to ''freeze'' one row and still scroll others.
If what you are after is a set of totals remaining on screen whilst you scroll the data you can implement this functionality by using the header or footer area of a continuous form to contain unbound textboxes, one for each total you need. The control source for each unbound textbox would just be
=sum([field you are summing])
This is the same technique used to produce group totals and overall totals in a report.
An example of the use of the footer for this purpose is attached. The totals at the bottom are unbound controls which remain in view as the detail rows are scrolled.
Note that this cannot be done in datasheet view, as the form header/footer areas are not visible in that view.
-Stewart
@Stewart Ross Inverness
感谢Stewart的回复。
如何关于Listview控件？
有可能吗？
@Stewart Ross Inverness
Thanks Stewart for your reply.
How about in Listview control?
Is it possible?
不在列表视图控件中... -S
Not in listview control either... -S
这篇关于数据表中的垂直冻结窗格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
