displaying images in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i made a product catalog in access which has 79 pages with roughly 18 images
per page for a total of 1190 images to be displayed. i used the following
code which i saw in a previous post:

Private Sub Detail_Format (Cancel As Integer, FormatCount As Integer)
Me![Imageframe].picture = Me![Imagepath]
End Sub

the code works fine but i noticed that if i try to print (for example) the
last 10 pages, access will format all of the previous pages before getting to
the pages i want to print. also, when i try printing a whole catalog i end
up running low on virtual memory.

is there any solution for this other than increasing computer memory?
 
You need to place your code behind the Print event not the Format event.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
i just tried but still ran out of memory. i also tried the createbitmapfile
trick and ran out of memory as well.

Stephen Lebans said:
You need to place your code behind the Print event not the Format event.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


big d said:
i made a product catalog in access which has 79 pages with roughly 18 images
per page for a total of 1190 images to be displayed. i used the following
code which i saw in a previous post:

Private Sub Detail_Format (Cancel As Integer, FormatCount As Integer)
Me![Imageframe].picture = Me![Imagepath]
End Sub

the code works fine but i noticed that if i try to print (for example) the
last 10 pages, access will format all of the previous pages before getting to
the pages i want to print. also, when i try printing a whole catalog i end
up running low on virtual memory.

is there any solution for this other than increasing computer memory?
Click to expand...
Click to expand...
 
I can create a 1000 page report here but there are only 3 images per
page. Perhaps you are running into a memory per page issue.


What version of Access and WIndows are you running?

What is the exact error message that is generated?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


big d said:
i just tried but still ran out of memory. i also tried the createbitmapfile
trick and ran out of memory as well.

Stephen Lebans said:
You need to place your code behind the Print event not the Format event.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


big d said:
i made a product catalog in access which has 79 pages with roughly
Click to expand...
18
images
per page for a total of 1190 images to be displayed. i used the following
code which i saw in a previous post:

Private Sub Detail_Format (Cancel As Integer, FormatCount As Integer)
Me![Imageframe].picture = Me![Imagepath]
End Sub

the code works fine but i noticed that if i try to print (for
Click to expand...
example)
the
last 10 pages, access will format all of the previous pages before getting to
the pages i want to print. also, when i try printing a whole
Click to expand...
catalog
i end
up running low on virtual memory.

is there any solution for this other than increasing computer
Click to expand...
memory?
Click to expand...
Click to expand...
 
Sorry for the late response. I currently have Access 2000 running on Windows
2000 with about 512MB of memory.

The message reads:

There isn't enough free memory to update the display. Close unneeded
programs and try again.




Stephen Lebans said:
I can create a 1000 page report here but there are only 3 images per
page. Perhaps you are running into a memory per page issue.


What version of Access and WIndows are you running?

What is the exact error message that is generated?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


big d said:
i just tried but still ran out of memory. i also tried the createbitmapfile
trick and ran out of memory as well.

Stephen Lebans said:
You need to place your code behind the Print event not the Format event.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


i made a product catalog in access which has 79 pages with roughly 18
images
per page for a total of 1190 images to be displayed. i used the
following
code which i saw in a previous post:

Private Sub Detail_Format (Cancel As Integer, FormatCount As Integer)
Me![Imageframe].picture = Me![Imagepath]
End Sub

the code works fine but i noticed that if i try to print (for example)
the
last 10 pages, access will format all of the previous pages before
getting to
the pages i want to print. also, when i try printing a whole catalog
i end
up running low on virtual memory.

is there any solution for this other than increasing computer memory?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top