displaying images in report

[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?

 

[Stephen Lebans]

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.

 

[Guest]

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

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?

 

[Stephen Lebans]

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.

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

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?

 

[Guest]

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.

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.

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

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?