By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,854 Members | 1,883 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,854 IT Pros & Developers. It's quick & easy.

Displaying records horizontally as well as vertically in a form

P: n/a
Lyn
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?

--
Cheers,
Lyn.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
Lyn
"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.
Nov 13 '05 #3

P: n/a
Lyn wrote:
1) In the basFunctions module (first line), you have spelt your name
"tervor". You may want to correct it. :-)
We all make mistakes, said the darlek climbing off the dustbin. It's
still a valid email address :-)
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.


Doesn't quite date me, someone once posted it here. In that year I was a
twinkle in my daddy's eye, now that's dated me :-)

--
1f u c4n r34d th1s u r34lly
n33d t0 g37 l41d

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.