N
nhdee
Using Access 2007. This may not be the best approach but this is what I have
done... I am trying to create a home inspection database. In my table for
bathroom I have the following fields referring to pictures: TPic as an
Attachment to add pictures of a toilet (don't laugh!); SPic for sink; VHPic
for Venting/Heating; BTPic for bath-tub; SHPic for Shower.....
On the form for each area (I have the form set-up as pages / tabs) each
attachment field is on the applicable page. That works fine. The user can
add as many pictures as they want easily.
I can put the attachment field in the appropriate area it is to be displayed
on the report - no problem. However, it will only display one picture and
show the arrow button on the screen to display the rest. So, I have two
issues: First if there is no picture I don't want the space where the
picture would have been to be taken up (The photo is to be printed as 3.5 x
2.5) to be blank. Second, when there is more than one picture to print, how
can I get it to display and print? Thanks!
done... I am trying to create a home inspection database. In my table for
bathroom I have the following fields referring to pictures: TPic as an
Attachment to add pictures of a toilet (don't laugh!); SPic for sink; VHPic
for Venting/Heating; BTPic for bath-tub; SHPic for Shower.....
On the form for each area (I have the form set-up as pages / tabs) each
attachment field is on the applicable page. That works fine. The user can
add as many pictures as they want easily.
I can put the attachment field in the appropriate area it is to be displayed
on the report - no problem. However, it will only display one picture and
show the arrow button on the screen to display the rest. So, I have two
issues: First if there is no picture I don't want the space where the
picture would have been to be taken up (The photo is to be printed as 3.5 x
2.5) to be blank. Second, when there is more than one picture to print, how
can I get it to display and print? Thanks!