是否可以将高子窗体分成两个短子窗体？ [英] Possibility to divide a tall subform to two short subforms?

问题描述

是否可以将80个记录的高子表格分成两个子表单，每个子表单包含40条记录？


亲爱的所有，


我有什么：表：tblProduct，tblOrder，tblOrderDetail


查询：qryOrder，qryOrderDetail


表格：表格frmOrder和子表单sbfrmOrderDetail（基于以上两个

提到的查询，加入了OrderID）


问题：用户抱怨子表单sbfrmOrderDetail可以显示

只有40条记录，其中一条必须使用滚动条检查40后的记录。

他问我是否可以将sbfrmOrderDetail划分为两个子表单，一个

保存记录1到40，另一个记录从41开始（事实是他有

经常记录超过40但少于80）。


解决方案：


1.制作两个子表单sbfrmOrderDetail1和sbfrmOrderDetail2


2. qryOrderDetail中有6个字段：Order DetailID，OrderID，

产品ID，价格，数量，总计（即[价格] * [数量]）。根据qryOrderDetail创建

两个查询：qry1和qry2，它们是

qryOrderDetail的副本，但是严格的qry1？TopsTopValues到40，严格的qry2？starts开始

来自第41条记录，两者都添加标准OrderID =

Forms！[frmOrder]！[OrderID]


3.设置记录sbfrmOrderDetail1和sbfrmOrderDetail2分别为
qry1和qry2。


这些只是我的第一个提示想法，请告诉我你是否认为它是

可能和/或值得做，或者有更好的解决方案。感谢您

耐心阅读这篇文章。非常感谢任何帮助。


Paul

解决方案

Paul，

您的用户是否为更改付费？如果

订单表单中的记录多于子表单中显示的记录，该怎么办？即使在高分辨率

设置下，屏幕空间量和一些

记录也有限制，超过这些记录，如果不滚动，一切都不合适。如果你构建了一个

两个子窗体屏幕，然后在其中一个子窗体中有81个记录，那么你的用户必须滚动才能查看不合适的记录。收费时间和

a一半，如果你的客户愿意支付，那就去吧。

现在，Top N会工作，但你需要对结果集进行排序。结果集

将是只读的，所以如果订单明细记录应该是可编辑的那么

你需要将结果集转储到一些临时表中然后用于任何

修改后的记录，将更改发回到桌子上。


" Paul T. RONG" <等*** @ hotmail.com>在留言中写道

新闻：qM ****************** @ news.chello.at ...

是有可能将80个记录的高大子表格分成两个子表单
每个具有40条记录吗？

亲爱的，

我拥有的：表格：tblProduct，tblOrder，tblOrderDetail

查询：qryOrder，qryOrderDetail

表单：form frmOrder和subform sbfrmOrderDetail（基于以上两个提到的查询，与OrderID结合使用） ）问题：用户抱怨子窗体sbfrmOrderDetail只能显示40条记录，其中一条必须使用滚动条检查40条后的记录。
他问我是否可以将sbfrmOrderDetail分成两个子表单，一个
保存记录1到40，另一个从41开始（事实是他经常记录超过40但少于80）。

解决方案：

1.制作两个子表单sbfrmOrderDetail1和sbfrmOrderDetail2

2.有qryOrderDetail中的6个字段：OrderDetailID，OrderID，
ProductID，Price，Quantity，Total（即[Price] * [Quantity]）。基于qryOrderDetail创建
两个查询：qry1和qry2，它们是qryOrderDetail的副本，但严格的qry1？TopTopValues到40，严格的qry2？starts从
开始第41条记录，都添加标准OrderID =
Forms！[frmOrder]！[OrderID]

3.将sbfrmOrderDetail1和sbfrmOrderDetail2的记录分别设置为qry1和qry2。

这些只是我的第一个提示想法，请告诉我你是否认为可行和/或值得做，或者有更好的解决方案。感谢您耐心阅读这篇文章。非常感谢任何帮助。

Paul

Alan，


非常感谢您的评论。你是非常正确的使用srollbars。

我们无法避免它。

可能的变化确实很复杂。我意识到这根本不是一件容易的事情。我将在下周与用户讨论

，试着说服他使用更大的显示器。


周末愉快，不知道在哪里你是，我们刚刚开始星期五

晚上...


Paul

布拉迪斯拉发，斯洛伐克，欧洲
" Alan Webb" < KN ***** @ hotmail.com> D'è????¢D ???

：PP ******************** @ comcast.com ...... < blockquote class =post_quotes> Paul，
您的用户是否为此更改付费？如果在
中还有1条记录怎么办？

如果您构建了一个两个子窗体并且有81条记录，那么在其中一个子窗体
中，您的用户必须滚动到看到不合适的记录。收费时间
和这一半的一半，如果你的客户愿意支付，那就去吧。
现在，Top N会工作，但你需要对结果集进行排序。结果集
将是只读的，所以如果订单明细记录应该是可编辑的，那么你需要将结果集转储到一些临时表中，然后为
任何修改过的记录，将更改发回到桌子上。

Paul T. RONG <等*** @ hotmail.com>在消息中写道
新闻：qM ****************** @ news.chello.at ...

是否有可能划分一个高大的子窗体，有80个记录到两个子窗体
每个有40个记录？

亲爱的，

我拥有的：表：tblProduct，tblOrder ，tblOrderDetail

查询：qryOrder，qryOrderDetail

表单：表单frmOrder和子表单sbfrmOrderDetail（基于上面提到的两个
查询，与OrderID结合）

问题：用户抱怨子窗体sbfrmOrderDetail可以
只显示40条记录，其中一条必须使用滚动条检查
40之后的那些记录。他问我是否可以将sbfrmOrderDetail划分为两个子表单，一个
保存记录1到40，另一个从41开始（事实是他经常记录超过40但少于80）。

解决方案：

1.制作两个子表单sbfrmOrderDetail1和sbfrmOrderDetail2

2.有6个字段在qryOrderDetail中：OrderDetailID，OrderID，
ProductID，Price，Quantity，Total（即[Price] * [Quantity]）。基于qryOrderDetail创建
两个查询：qry1和qry2，它们是qryOrderDetail的副本，但严格的qry1？TopTopValues到40，严格的qry2？starts从
开始第41条记录，都添加标准OrderID =
Forms！[frmOrder]！[OrderID]

3.将sbfrmOrderDetail1和sbfrmOrderDetail2
的记录分别设置为qry1和qry2。 />
这些只是我的第一个提示想法，请告诉我你是否认为可行和/或值得做，或者有更好的解决方案。感谢您耐心阅读这篇文章。非常感谢任何帮助。

Paul

PS：


我只是想知道是否可以将srollbar移动到结尾和开头

到vba ...然后很容易教用户按 ;上一页"看看的关键

记录从No.1开始并按PageDown从最后的记录中查看

的记录。


Paul


" Alan Webb" < KN ***** @ hotmail.com> D'è????¢D ???

：PP ******************** @ comcast.com ...... < blockquote class =post_quotes> Paul，
您的用户是否为此更改付费？如果订单表单中的
中还有1条记录将显示在子表单中，该怎么办？即使在高分辨率设置下，屏幕空间和一些记录的数量也会受到限制，超过这些记录，如果不滚动，一切都不适合。如果您构建
两个子窗体并且有一个子窗体中有81个记录
，您的用户必须滚动才能看到不合适的记录。收费时间
和这一半的一半，如果你的客户愿意支付，那就去吧。
现在，Top N会工作，但你需要对结果集进行排序。结果集
将是只读的，所以如果订单明细记录应该是可编辑的，那么你需要将结果集转储到一些临时表中，然后为
任何修改过的记录，将更改发回到桌子上。

Paul T. RONG <等*** @ hotmail.com>在消息中写道
新闻：qM ****************** @ news.chello.at ...

是否有可能划分一个高大的子窗体，有80个记录到两个子窗体
每个有40个记录？

亲爱的，

我拥有的：表：tblProduct，tblOrder ，tblOrderDetail

查询：qryOrder，qryOrderDetail

表单：表单frmOrder和子表单sbfrmOrderDetail（基于上面提到的两个
查询，与OrderID结合）

问题：用户抱怨子窗体sbfrmOrderDetail可以
只显示40条记录，其中一条必须使用滚动条检查
40之后的那些记录。他问我是否可以将sbfrmOrderDetail划分为两个子表单，一个
保存记录1到40，另一个从41开始（事实是他经常记录超过40但少于80）。

解决方案：

1.制作两个子表单sbfrmOrderDetail1和sbfrmOrderDetail2

2.有6个字段在qryOrderDetail中：OrderDetailID，OrderID，
ProductID，Price，Quantity，Total（即[Price] * [Quantity]）。基于qryOrderDetail创建
两个查询：qry1和qry2，它们是qryOrderDetail的副本，但严格的qry1？TopTopValues到40，严格的qry2？starts从
开始第41条记录，都添加标准OrderID =
Forms！[frmOrder]！[OrderID]

3.将sbfrmOrderDetail1和sbfrmOrderDetail2
的记录分别设置为qry1和qry2。 />
这些只是我的第一个提示想法，请告诉我你是否认为可行和/或值得做，或者有更好的解决方案。感谢您耐心阅读这篇文章。非常感谢任何帮助。

Paul

Is it possible to divide a tall subform with 80 records to two subforms each
with 40 records?

Dear All,

What I have: Tables: tblProduct, tblOrder, tblOrderDetail

queries: qryOrder, qryOrderDetail

Forms: form frmOrder and subform sbfrmOrderDetail (based on the two above
mentioned queries, joined with OrderID)

Problem: the user complains that the subform sbfrmOrderDetail can display
only 40 records, one has to use scrollbar to check those records after 40.
He asked me if I can divide the sbfrmOrderDetail into two subforms, one
holds records 1 to 40, the other starts from 41 (the fact is that he has
very often records more than 40 but less than 80).

Solution:

1. to make two subforms sbfrmOrderDetail1 and sbfrmOrderDetail2

2. there are 6 fields in qryOrderDetail: OrderDetailID, OrderID,
ProductID, Price, Quantity, Total (that is [Price] * [Quantity]). to create
two queries based on qryOrderDetail: qry1 and qry2, they are copies of
qryOrderDetail, but strict qry1?ˉs TopValues to 40, strict qry2?ˉs start
from the 41st records, both add criteria OrderID =
Forms![frmOrder]![OrderID]

3. set the recordsouce of sbfrmOrderDetail1 and sbfrmOrderDetail2 to
qry1 and qry2 repectively.

These are just my first prompt ideas, please tell me if you think it is
possible and/or worthy doing, or there is better solution. Thank you for
your patience to read this post. Any help is very much appreciated.

Paul

解决方案

Paul,
Is your user paying for the change? What if there are 1 more records in the
order form than will display in the subforms. Even at a high resolution
setting there is a limit to the amount of screen space and a number of
records beyond which everything won''t fit without scrolling. If you build a
two subform screen and there are 81 records then in one of the subforms your
user will have to scroll to see the record that didn''t fit. Charge time and
a half for this one and if your client is willing to pay, go for it.
Now, Top N will work but you need to sort the result set. The result set
will be read only so if the order detail records should be editable then
you''ll need to dump the result set in some temporary tables and then for any
modified records, post the changes back to the soure tables.

"Paul T. RONG" <et***@hotmail.com> wrote in message
news:qM******************@news.chello.at...

Is it possible to divide a tall subform with 80 records to two subforms
each
with 40 records?

Dear All,

What I have: Tables: tblProduct, tblOrder, tblOrderDetail

queries: qryOrder, qryOrderDetail

Forms: form frmOrder and subform sbfrmOrderDetail (based on the two above
mentioned queries, joined with OrderID)

Problem: the user complains that the subform sbfrmOrderDetail can display
only 40 records, one has to use scrollbar to check those records after 40.
He asked me if I can divide the sbfrmOrderDetail into two subforms, one
holds records 1 to 40, the other starts from 41 (the fact is that he has
very often records more than 40 but less than 80).

Solution:

1. to make two subforms sbfrmOrderDetail1 and sbfrmOrderDetail2

2. there are 6 fields in qryOrderDetail: OrderDetailID, OrderID,
ProductID, Price, Quantity, Total (that is [Price] * [Quantity]). to
create
two queries based on qryOrderDetail: qry1 and qry2, they are copies of
qryOrderDetail, but strict qry1?ˉs TopValues to 40, strict qry2?ˉs start
from the 41st records, both add criteria OrderID =
Forms![frmOrder]![OrderID]

3. set the recordsouce of sbfrmOrderDetail1 and sbfrmOrderDetail2 to
qry1 and qry2 repectively.

These are just my first prompt ideas, please tell me if you think it is
possible and/or worthy doing, or there is better solution. Thank you for
your patience to read this post. Any help is very much appreciated.

Paul

Alan,

Thank you very much for your comment. You are very right on using srollbars.
We just can''t avoid it.
The possible change is queit complicated indeed. I realize it is not a easy
task at all. I will talk
with the user next week, try to persuade him in using a bigger monitor.

Have a nice weekend, don''t know where you are, we just start to have Friday
evening...

Paul
Bratislava, Slovakia, Europe
"Alan Webb" <kn*****@hotmail.com> D′è????￠D???
:PP********************@comcast.com...

Paul,
Is your user paying for the change? What if there are 1 more records in the
If you build a two subform screen and there are 81 records then in one of the subforms your user will have to scroll to see the record that didn''t fit. Charge time and a half for this one and if your client is willing to pay, go for it.
Now, Top N will work but you need to sort the result set. The result set
will be read only so if the order detail records should be editable then
you''ll need to dump the result set in some temporary tables and then for any modified records, post the changes back to the soure tables.

"Paul T. RONG" <et***@hotmail.com> wrote in message
news:qM******************@news.chello.at...

Is it possible to divide a tall subform with 80 records to two subforms
each
with 40 records?

Dear All,

What I have: Tables: tblProduct, tblOrder, tblOrderDetail

queries: qryOrder, qryOrderDetail

Forms: form frmOrder and subform sbfrmOrderDetail (based on the two above mentioned queries, joined with OrderID)

Problem: the user complains that the subform sbfrmOrderDetail can display only 40 records, one has to use scrollbar to check those records after 40. He asked me if I can divide the sbfrmOrderDetail into two subforms, one
holds records 1 to 40, the other starts from 41 (the fact is that he has
very often records more than 40 but less than 80).

Solution:

1. to make two subforms sbfrmOrderDetail1 and sbfrmOrderDetail2

2. there are 6 fields in qryOrderDetail: OrderDetailID, OrderID,
ProductID, Price, Quantity, Total (that is [Price] * [Quantity]). to
create
two queries based on qryOrderDetail: qry1 and qry2, they are copies of
qryOrderDetail, but strict qry1?ˉs TopValues to 40, strict qry2?ˉs start
from the 41st records, both add criteria OrderID =
Forms![frmOrder]![OrderID]

3. set the recordsouce of sbfrmOrderDetail1 and sbfrmOrderDetail2 to qry1 and qry2 repectively.

These are just my first prompt ideas, please tell me if you think it is
possible and/or worthy doing, or there is better solution. Thank you for
your patience to read this post. Any help is very much appreciated.

Paul

PS:

I just wonder if one can move the srollbar to the end and to the beginning
through vba... then it is easy to teach users to press "PageUp" key to look
the records start from No.1 and press "PageDown" to check the records from
the last records.

Paul

"Alan Webb" <kn*****@hotmail.com> D′è????￠D???
:PP********************@comcast.com...

Paul,
Is your user paying for the change? What if there are 1 more records in the order form than will display in the subforms. Even at a high resolution
setting there is a limit to the amount of screen space and a number of
records beyond which everything won''t fit without scrolling. If you build a two subform screen and there are 81 records then in one of the subforms your user will have to scroll to see the record that didn''t fit. Charge time and a half for this one and if your client is willing to pay, go for it.
Now, Top N will work but you need to sort the result set. The result set
will be read only so if the order detail records should be editable then
you''ll need to dump the result set in some temporary tables and then for any modified records, post the changes back to the soure tables.

"Paul T. RONG" <et***@hotmail.com> wrote in message
news:qM******************@news.chello.at...

Is it possible to divide a tall subform with 80 records to two subforms
each
with 40 records?

Dear All,

What I have: Tables: tblProduct, tblOrder, tblOrderDetail

queries: qryOrder, qryOrderDetail

Forms: form frmOrder and subform sbfrmOrderDetail (based on the two above mentioned queries, joined with OrderID)

Problem: the user complains that the subform sbfrmOrderDetail can display only 40 records, one has to use scrollbar to check those records after 40. He asked me if I can divide the sbfrmOrderDetail into two subforms, one
holds records 1 to 40, the other starts from 41 (the fact is that he has
very often records more than 40 but less than 80).

Solution:

1. to make two subforms sbfrmOrderDetail1 and sbfrmOrderDetail2

2. there are 6 fields in qryOrderDetail: OrderDetailID, OrderID,
ProductID, Price, Quantity, Total (that is [Price] * [Quantity]). to
create
two queries based on qryOrderDetail: qry1 and qry2, they are copies of
qryOrderDetail, but strict qry1?ˉs TopValues to 40, strict qry2?ˉs start
from the 41st records, both add criteria OrderID =
Forms![frmOrder]![OrderID]

3. set the recordsouce of sbfrmOrderDetail1 and sbfrmOrderDetail2 to qry1 and qry2 repectively.

These are just my first prompt ideas, please tell me if you think it is
possible and/or worthy doing, or there is better solution. Thank you for
your patience to read this post. Any help is very much appreciated.

Paul

这篇关于是否可以将高子窗体分成两个短子窗体？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！