 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / February 2005displaying images in report
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 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 [quoted text clipped - 10 lines] > > 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. > You need to place your code behind the Print event not the Format event. > [quoted text clipped - 25 lines] > > > > 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. > i just tried but still ran out of memory. i also tried the createbitmapfile > trick and ran out of memory as well. [quoted text clipped - 28 lines] > > > > > > 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. > 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. [quoted text clipped - 50 lines] > > > > is there any solution for this other than increasing computer > memory? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.