慢速显示 [英] slow form display

问题描述

我在对等网络上的Windows XP Professional环境中使用Access 2000（以及2003同样的结果）。该系统中的文件相对较小。物品/仓库表中约有1,200行，约200个订单表头，以及约2000个订单明细行。


我有一个表格，其中包含一个子表格的详细信息。主要形式。子表格是连续的线条显示（不是单个项目）;在标题中，我收到了客户的订单标题信息，在子表单中，我列出了该订单的所有订单项。


子表单中的每一行都有一个文本框，用于库存项目编号，订购数量，装运数量，现有数量和订单数量（所有未结订单合并）。


如果该项目的订单数量超过（现有订单），则该订单的可用空间不足，我使用条件格式将现有文本框的背景变为黄色。


问题是，有时这种形式很难完成。现有和订单框保持空白，慢慢填满屏幕。奇怪的是，如果您执行ALT-TAB切换到屏幕，并立即返回ALT-TAB，则突然填写所有文本框。或者，如果您将鼠标悬停在空文本框上，则值为该文本框将出现。


现有数量不是单个字段，可以在多个仓库中存在。这是返回项目的现有值的代码

展开 | 选择 | Wrap | 行号

解决方案

请改为尝试：

展开 | 选择 | Wrap | 行号

感谢您的回复，MM。通过阅读你对这里很多问题的回答，我学到了很多东西。我很高兴有些人知道并愿意分享它。


在这种情况下，你似乎建议我改为顺序阅读ItemWarehouse表。在我看来会降低它的速度。但是我会试一试，我没有更好的想法。


谢谢，

Jim

你好Jim


由于Jet Engine的工作方式，情况并非如此。


使用我的代码给定顺序逻辑意味着一旦找到所需结果，搜索将跳转到下一组记录。


如果条件不真实，它将自动跳转到下一条记录。


我想你会对它的运行速度感到惊讶。

谢谢回复，MM。通过阅读你对这里很多问题的回答，我学到了很多东西。我很高兴有些人知道并愿意分享它。


在这种情况下，你似乎建议我改为顺序阅读ItemWarehouse表。在我看来会降低它的速度。但我会试一试，我没有更好的想法。


谢谢，

吉姆

I''m using Access 2000 (and also 2003 with same result) in a Windows XP Professional environment on a peer-to-peer network. Files in this system are relatively small. There are about 1,200 rows in the item/warehouse table, about 200 order headers, and about 2000 order detail rows.

I have a form with a sub-form in the detail of the main form. The sub-form is a continuous line display (not single item); In the heading I am getting a customer''s order heading information, and in the subform I am listing all of the line items for that order.

Each line in the subform has a text box for inventory item number, quantity ordered, quantity shipped, on hand quantity, and on order quantity (all open orders combined).

If the order quantity for that item exceeds the (on hand - on order) then there are not enough available for that order and I use conditional formatting to turn the background of the on hand text box yellow.

The problem is, sometimes this form is VERY slow to complete. The on hand and on order boxes remain empty, filling down the screen slowly. And oddly, if you do an ALT-TAB to switch out of the screen, and ALT-TAB back immediately, then suddenly all the text boxes are filled in. Or, if you wave your mouse over an empty text box, the value for that text box will appear.

The on-hand quantity is not a single field, there can be on hand in more than one warehouse.Here is the code to return the on hand value for an item

Expand|Select|Wrap|Line Numbers

解决方案

Try this instead:

Expand|Select|Wrap|Line Numbers

Thanks for the reply, MM. I''ve learned a lot by reading your responses to a lot of questions here. I''ve very glad there are some folks with so much knowledge and willingness to share it.

In this case, it appears you''re suggesting I change to a sequential read through the ItemWarehouse table. Seems to me that will make it less fast. But I''ll give it a shot, I don''t have any better ideas.

Thanks,
Jim

Hi Jim

Because of the way the Jet Engine works this is not always the case.

With the code I have given you the sequential logic means that the search will jump to the next set of records once the required result is found.

If a condition is untrue it will automatically jump to the next record.

I think you''ll be surprised at how fast it will run.

Thanks for the reply, MM. I''ve learned a lot by reading your responses to a lot of questions here. I''ve very glad there are some folks with so much knowledge and willingness to share it.

In this case, it appears you''re suggesting I change to a sequential read through the ItemWarehouse table. Seems to me that will make it less fast. But I''ll give it a shot, I don''t have any better ideas.

Thanks,
Jim

这篇关于慢速显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！