Happy Easter, thanks for your interest
My question is a layout issue for Access reports rather than an OLE issue (I think). I can get pictures printing ok (I fluked it rather than understood it so I am going to read your references - this is a hobby for me so I don't promise to understand). However I can't generate the layout I want. The database has records containing toy info (description, appropriate age range, whether batteries are needed, rental fee etc), and the picture. There is a toyparts sub-database of itemised parts so the librarian can check that all parts are returned (eg lego parts). The report is generated from a query linking the database with the subdatabase. The report's purpose is to print 2 records per A4 page for presentation in a Clearfile for parents to browse and for the librarian to refer to. ie the top half of the page contains a toy's info + picture with the parts listed underneath, then the bottom half of the page lists the next toy in the same way etc
The current report layout has all the toy info and picture at the top in a"group header section" with the parts list below in the "detail section" results in a long narrow list. The preferred layout is the same as the existing (manual) cards: with toy info taking about the top 3 lines and the picture moved down side by side with the toyparts list (ie effectively 2 columns). But if I put the picture down in the detail part of the report beside the toyparts it creates one copy of the picture for every toypart (hence my gripe about wanting to suppress duplicates). And if I try to create columns the report splits the group header section into columns as well as the detail section.
Have I made myself any clearer
Thank
Klemly
----- Larry Linson wrote: ----
I'm sorry, but I am having a difficult time understanding what data you hav
and how it is structured. That is possibly why I can't offer a suggestio
for arranging it the way you want in a report. What you want does not see
(just off the top) to be difficult, so I suspect that someone, perhaps eve
I, can be of assistance if you'll clarify
But, perhaps the proverb about pictures and words also applies to "sampl
databases". The sample imaging databases at
http://accdevel.tripod.co
illustrate three approaches to handling images in Access, and the downloa
includes an article discussing considerations in choosing an approach. Tw
of the approaches do not use OLE Objects and, thus, avoid the databas
bloat, and some other problems, associated with images in OLE Objects
If you are printing the images in reports, to avoid memory leakage, yo
should also see MVP Stephen Lebans'
http://www.lebans.com/printfailures.htm
PrintFailure.zip is an Access97 MDB containing a report that fails durin
the Access formatting process prior to being spooled to the Printer Driver
This MDB also contains code showing how to convert the contents of the Imag
control to a Bitmap file prior to printing. This helps alleviate the "Out o
Memory" error that can popup when printing image intensive reports
Larry Linso
Microsoft Access MV
Klemlyn said:
I am having a problem with pictures and report layout
I am creating a database for the local Toy Library. The report will have
records per A4 page. The desired layout is to have "toy info" across the to
of each section then in the detail section have a list of toy component
plus a photo of the toy. I have tried to add columns but that also break
the section head into columns (so I get the desired result only if I put th
"toy info" in the page header section - and can only have one record pe
page). I have also tried to suppress duplicates but this option seems t
exist only for text boxes not pictures
