Precurser to the question:
https://www.accessforums.net/access/...such-2647.html
ok..
so I got my Reports displaying correctly (for the most part)
when i go to print preview I have 3 colums set and it ends up in 3 rows..
so I have 9 "cards" displaying on one page.. This is great!
The problem is that when i go to the next page and it loads the data, each of the 9 background images load (import) and I notice my MSACCESS.EXE in my Task Manager starts eating memory (about 70-100MB per page). Once i've loaded about 5-6 pages (for print or preview) it errors and says "Run-time Error '2220'; MS Access can't open the file '(my image path)'
Why are my images causing access to just fill up on memory? Is there any way to fix this?
My images(jpegs) are about 100k-200k (they need to be high quality for print) each max.
Please help with this as I have about 30 pages (of 9 "cards") to print.
I am using the below VBA code to generate the images from my path field:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Len(Me.TemplatePath) > 0 Then
Me.Template.Picture = Me.TemplatePath
End If
End Sub
I am also still looking for a way to take text from a cell and have "keywords" display as an image. EX:
Textbox:
"Be sure to use the one with the {image here} symbol first."
please help.