By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,524 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Indexing? Print preview takes forever question.

P: 76
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.
Jan 4 '07 #1
Share this Question
Share on Google+
16 Replies


Expert 5K+
P: 8,435
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.
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.
Jan 4 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Put the picture in an image control rather than an unbound ole control and it should print fine.

Mary
Jan 5 '07 #3

P: 76
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?
Jan 5 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
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?
I agree but unfortunately this is not my area of expertise. I'll see if someone else can help.

Mary
Jan 5 '07 #5

missinglinq
Expert 2.5K+
P: 3,532
An obvious case of WYSINWYG! In my experience this is usually printer related, and the only suggestion I would have would be to try printing to a different make/model of printer if available. I think Killer's right on the money with the query suggestion, as the problem is only apt to get worse and worse as time goes by.
Jan 5 '07 #6

Expert 5K+
P: 8,435
An obvious case of WYSINWYG! In my experience this is usually printer related, and the only suggestion I would have would be to try printing to a different make/model of printer if available.
Yes, I think you need to narrow down the problem. I would try to determine whether the non-printing image problem is specific to this particular...
  • Printer
  • PC
  • Database
  • Image

Also, a question for the Access experts. I know there is a property to determine when things are to print - screen only, print only or whatever. Is it possible this could have the observed effect?
Jan 5 '07 #7

nico5038
Expert 2.5K+
P: 3,072
Did you check the "Display When" property of the object (see format tab) to be set to "Always" ?

Nic;o)
Jan 5 '07 #8

P: 76
Yes. Display when is set to "always".
I'm about 99 percent sure this is a printer problem. I did some test forms and this happens all the time. The only weird thing that I've seen is when I hit the print button which will print out every record in the table; the image is there. It only take it out if I print "selected record" or "pages _ to _".
Jan 16 '07 #9

MMcCarthy
Expert Mod 10K+
P: 14,534
Yes. Display when is set to "always".
I'm about 99 percent sure this is a printer problem. I did some test forms and this happens all the time. The only weird thing that I've seen is when I hit the print button which will print out every record in the table; the image is there. It only take it out if I print "selected record" or "pages _ to _".
Again, I'm not expert. However, this sounds like a spooling problem. How large is the picture you are trying to print?
Jan 16 '07 #10

Expert 5K+
P: 8,435
I think I said something similar before, but perhaps it would be best to take the user's choice (which records/pages to print) and throw it at a report which does a "full print" but whose underlying query returns only the desired records.

Not exactly a solution to the problem perhaps, but a workaround that might be worth considering.
Jan 16 '07 #11

MMcCarthy
Expert Mod 10K+
P: 14,534
I think I said something similar before, but perhaps it would be best to take the user's choice (which records/pages to print) and throw it at a report which does a "full print" but whose underlying query returns only the desired records.

Not exactly a solution to the problem perhaps, but a workaround that might be worth considering.
You mean dynamically change the record source Killer or just the criteria?
Jan 16 '07 #12

Expert 5K+
P: 8,435
You mean dynamically change the record source Killer or just the criteria?
I don't know what I mean, in that much detail; I was merely putting forward a general idea.

Doing a Print and selecting which pages, seems as though it can force the computer to to a lot of unnecessary work formatting pages it isn't going to print. Perhaps it would be better to allow the user to select which (range of) records they want, then print a report which includes only those records. I don't have a lot of experience in that area, but it seems as though it should be possible to do it by opening the report and changing the underlying SQL (recordsource?), or by specifying a filter when you print the report, or something.
Jan 16 '07 #13

MMcCarthy
Expert Mod 10K+
P: 14,534
I don't know what I mean, in that much detail; I was merely putting forward a general idea.

Doing a Print and selecting which pages, seems as though it can force the computer to to a lot of unnecessary work formatting pages it isn't going to print. Perhaps it would be better to allow the user to select which (range of) records they want, then print a report which includes only those records. I don't have a lot of experience in that area, but it seems as though it should be possible to do it by opening the report and changing the underlying SQL (recordsource?), or by specifying a filter when you print the report, or something.
Either can be done. Probably the best way would be to set the criteria in the docmd.OpenReport command the same as you would when opening a form.

Mary
Jan 17 '07 #14

Expert 5K+
P: 8,435
Either can be done. Probably the best way would be to set the criteria in the docmd.OpenReport command the same as you would when opening a form.
I often like to work like that - generate ideas, and let those who know the area in more detail fill in the gaps.

Guess I'm just the creative type. Occasionally it even works! :)

No, I said creative, not lazy.
Jan 17 '07 #15

MMcCarthy
Expert Mod 10K+
P: 14,534
I often like to work like that - generate ideas, and let those who know the area in more detail fill in the gaps.

Guess I'm just the creative type. Occasionally it even works! :)

No, I said creative, not lazy.
It was a good idea :o
Jan 17 '07 #16

P: 76
Here is what fixed the problem. My printer quality settings were set to "fast". I changed it to "standard" and presto, it works fine. I still don't understand why it would work when I simply hit the print button as I mentioned earlier. Weird I say.
As for my other problem of print previewing through many records; I have decided to include another feature into my database. It will be a form that will have a bunch of buttons that perform certain tasks such as generating reports and maybe some e-mail functionality to let my sales people know when there orders are completed. I'm reading about ISAM drivers and the VB used to do this now. Anyway I will have a button that will print the records that I've entered based on the date they were written. I'm sure it is a lot easier to say than it is to do.
Thanks for all your insite,
James
Jan 17 '07 #17

Post your reply

Sign in to post your reply or Sign up for a free account.