索引？打印预览永远是个问题。 [英] Indexing? Print preview takes forever question.

问题描述

好的，我的数据库工作得很好。我已经输入了大量订单，而且它变得越来越大。假设我有3000条记录，我想要打印最后13页的表格。我打印预览并点击结束按钮，找出我要打印的页面（顺便说一句，每页有2条记录/订单） 。这个过程和形成信息并显示预览的过程需要永远。有没有办法通过索引某些东西来加快速度？哦，我还有一张不打印的表格上有我公司标志的照片。它被称为OLEUnbound9。我可以在屏幕和打印预览中看到它，但它不会打印出来。

Ok my database is working great. I''ve entered a whole bunch of orders into it and it is getting bigger. Say I have 3000 records and I want to print the form for the last 13. I go to print preview and hit the end button and find out what pages I want to print (by the way I have 2 records/orders on each page). This process of going through and ?formating the information and showing a preview takes for ever. Is there a way to make it faster by indexing something? Oh and I also have a picture of my company logo on the form that won''t print. It is called OLEUnbound9. I can see it on the screen and in print preview but it won''t print out.

推荐答案

Ok我的数据库工作得很好。我已经输入了大量订单，而且它变得越来越大。假设我有3000条记录，我想要打印最后13页的表格。我打印预览并点击结束按钮，找出我要打印的页面（顺便说一句，每页有2条记录/订单） 。这个过程和形成信息并显示预览的过程需要永远。有没有办法通过索引某些东西来加快速度？哦，我还有一张不打印的表格上有我公司标志的照片。它被称为OLEUnbound9。我可以在屏幕和打印预览中看到它，但它不会打印出来。

Ok my database is working great. I''ve entered a whole bunch of orders into it and it is getting bigger. Say I have 3000 records and I want to print the form for the last 13. I go to print preview and hit the end button and find out what pages I want to print (by the way I have 2 records/orders on each page). This process of going through and ?formating the information and showing a preview takes for ever. Is there a way to make it faster by indexing something? Oh and I also have a picture of my company logo on the form that won''t print. It is called OLEUnbound9. I can see it on the screen and in print preview but it won''t print out.

不知道这张照片。但我认为为了节省时间，您可能需要创建一个只返回所需记录的查询，并设置报告（或表单）以将其用作源。否则它必须格式化所有3,000以确定最终页面应该是什么样的。


我怀疑索引会产生很大的不同，因为数据访问可能不会需要很长时间。

Don''t know about the picture. But I think to save time you probably need to create a query which returns just the records you want, and set the report (or form) to use that as its source. Otherwise it has to format all 3,000 to figure out what the final pages should look like.

I doubt that indexing would make a lot of difference, as the data access probably doesn''t take long.

好​​我的数据库工作得很好。我已经输入了大量订单，而且它变得越来越大。假设我有3000条记录，我想要打印最后13页的表格。我打印预览并点击结束按钮，找出我要打印的页面（顺便说一句，每页有2条记录/订单） 。这个过程和形成信息并显示预览的过程需要永远。有没有办法通过索引某些东西来加快速度？哦，我还有一张不打印的表格上有我公司标志的照片。它被称为OLEUnbound9。我可以在屏幕和打印预览中看到它，但它不会打印出来。

Ok my database is working great. I''ve entered a whole bunch of orders into it and it is getting bigger. Say I have 3000 records and I want to print the form for the last 13. I go to print preview and hit the end button and find out what pages I want to print (by the way I have 2 records/orders on each page). This process of going through and ?formating the information and showing a preview takes for ever. Is there a way to make it faster by indexing something? Oh and I also have a picture of my company logo on the form that won''t print. It is called OLEUnbound9. I can see it on the screen and in print preview but it won''t print out.

将图片放入图像控件而不是未绑定的ole控件中，它应该打印正常。


Mary

Put the picture in an image control rather than an unbound ole control and it should print fine.

Mary

将图片放在图像控件而不是未绑定的ole控件中，它应该打印正常。


Mary

Put the picture in an image control rather than an unbound ole control and it should print fine.

Mary

我这样做的结果相同。打印预览中有一张图片但没有打印出来。我在想这不是访问问题，而是打印机问题？

I did this with the same results. There is a picture in the print preview but nothing get printed. I''m thinking this is not an access problem but a printer problem?

这篇关于索引？打印预览永远是个问题。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！