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.


"big d" <big (E-Mail Removed)> wrote in message
news:EFBA6ADC-DB84-423A-833A-(E-Mail Removed)...
> 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?

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

"Stephen Lebans" wrote:

> 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" <big (E-Mail Removed)> wrote in message
> news:EFBA6ADC-DB84-423A-833A-(E-Mail Removed)...
> > 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?
>
>

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" <(E-Mail Removed)> wrote in message
news:73B60B4E-84E1-4F34-B42C-(E-Mail Removed)...
> i just tried but still ran out of memory. i also tried the
createbitmapfile
> trick and ran out of memory as well.
>
> "Stephen Lebans" wrote:
>
> > 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" <big (E-Mail Removed)> wrote in message
> > news:EFBA6ADC-DB84-423A-833A-(E-Mail Removed)...
> > > 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?
> >
> >

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" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:73B60B4E-84E1-4F34-B42C-(E-Mail Removed)...
> > i just tried but still ran out of memory. i also tried the
> createbitmapfile
> > trick and ran out of memory as well.
> >
> > "Stephen Lebans" wrote:
> >
> > > 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" <big (E-Mail Removed)> wrote in message
> > > news:EFBA6ADC-DB84-423A-833A-(E-Mail Removed)...
> > > > 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?
> > >
> > >
>
>