"Trevor Best" <no****@besty.org.uk> wrote in message
news:42**********************@news.zen.co.uk...
Lyn wrote: I need some guidance for a technique that will allow me to accomplish the
following...
I have a table in which each record contains a photograph. I would like
to display in a form a thumbnail size version of each photograph
horizontally across the form, then have the photgraphs "word wrap"
(picture wrap ?) at the right end of the form onto the next "line" of
photographs. Does anyone know how this can be done?
Obviously, displaying one photograph per line should be relatively easy
using Continuous mode. Also, I can envisage a "fixed" solution where the
number of thumbnails is fixed at (say) five per line and a temporary
table is generated to fill five photograph records into five frames per
temporary table record, then displaying the temporary table in Continuous
mode. I may have to resort to such a method.
However, what I am really looking for (if it is possible in Access/VBA)
is a dynamic solution where the photographs automatically line wrap -- so
that if I need to change the dimensions of the form in future, I don't
have to redesign the code to match.
Is this feasible?
Nothing dynamic here but it may help, depending on Access version
http://www.trevor.easynet.co.uk/downloads/Images.zip (2002/XP)
http://www.trevor.easynet.co.uk/down...Images2000.zip
http://www.trevor.easynet.co.uk/downloads/Images97.zip
To change the layout of the pics on the form would require just putting as
many image controls where you like and setting a symbolic constant up the
top of the code.
It may not be exactly what you want but you may get some ideas from it.
--
1f u c4n r34d th1s u r34lly
n33d t0 g37 l41d
Trevor,
Thanks for your response. I am using A2003/WinXP, so I have downloaded the
first link. I will look to see if I can adopt it or adapt it to meet my
needs.
In a quick look, I noted the following:
1) In the basFunctions module (first line), you have spelt your name
"tervor". You may want to correct it. :-)
2) The opening comment in "German" in module basOpenFileDlg brings back
memories. I can date that back to 1964 when I first saw it (or a slight
variation). I guess this pretty much dates me (and maybe you too? :-). I
was training in the USA to be a computer engineer on one of the first
transistorized mainframe computers! We used to put these cards on the
console of the computer to keep idle hands away. Somewhere in my
memorabilia I still have a card printed in Old German script with that
message.
Thanks again for the support.
--
Cheers,
Lyn.
