thanks in advance hipe to recieve your reply soon.
1) Defrag your Hard drive. The temp printer output files Access
generates can be very large when they contain images.
2) Make sure the drive you point your Virtual Memory Manager to has
several hundred MB's of free space.
3) If you are still using Win9x then make sure you reboot before
printing.
4) You must turn off the "Loading Image" dialog via the Registry
solution here:
http://www.mvps.org/access/api/api0038.htm
If you are using NT or higher you will have to update both
HKEY_LOCAL_MACHINE and HKEY_CURRENT_USER
5) Load the Images into the Image control from the Detail Section's
Print event NOT THE FORMAT EVENT.
If you follow the above steps and your Report still fails then here are
a couple of more solutions:
6) Upgrade to the latest version of Windows at the very least. Better
yet, upgrade to Access 2003 as well.
or
7) Use the PrintOUt method to only print out a limited number of pages
at a time. Repeat as required.
or
8) THis solution seems to look after most of the memory issues. At
runtime convert the Images to Bitmap format prior to loading them into
the Image control. Here is some sample code:
From: Stephen Lebans (Stephe...@mvps.org)
Subject: Re: Images in Reports
View: Complete Thread (18 articles)
Original Format
Newsgroups: microsoft.public.access.reports
Date: 2002-09-16 18:46:39 PST
Bruce I finally got a chance to test your method last night. It helped
but only with the actual printing and not the Print Preview itself.
I was able to print the failed Report directly to the printer or to a
disk printer file so that's great! Don't get me wrong, it's still a good
thing because at least you can print the report!
Unfortunately Acess still runs out of resources when you page back and
forth through Print Preview.
I plan to spend some time onthis issue shortly.
Here is the code I use to convert any Jpeg, Gif, or Metafile into a BMP.
Rather than using one of my API solutions I have cheated and set a
Reference to Standard OLE Types type library in order to get at the
SAVETODISK method. But no ActiveX controls are required
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
Private ctr As Long
ctr = ctr + 1
Select Case ctr
Case 1
Me.Image10.Picture = CreateBitmapFile("C:\A.jpg")
Case 2
Me.Image10.Picture = CreateBitmapFile("C:\b.jpg")
Case 3
Me.Image10.Picture = CreateBitmapFile("C:\c.jpg")
ctr = 0
Case Else
ctr = 0
End Select
End Sub
Private Sub Report_Open(Cancel As Integer)
ctr = 0
End Sub
Private Function CreateBitmapFile(fname As String) As String
Dim obj As Object
Set obj = LoadPicture(fname)
If Not IsNull(obj) Then
SavePicture obj, "C:\SL11-52"
DoEvents
End If
CreateBitmapFile = "C:\SL11-52"
Set obj = Nothing
End Function
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"marwa mohamed" <marwa...@hotmail.com> wrote in message
news:76f7b1a9.04022...@posting.google.com...
Stephen,
On your web site, you have a utility (ExportOLEtoJpegVer16) for
converting MS Access images to JPEG's. As this was written for Access
2000, what chg's. are necessary to use this tool in Access 2003?
Thx!
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Steve" <sdrich...@direcway.com> wrote in message
news:be02422b.04030...@posting.google.com...