473,563 Members | 2,326 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Displaying records horizontally as well as vertically in a form

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
3 4650
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
Lyn
"Trevor Best" <no****@besty.o rg.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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2230
by: John Baker | last post by:
Hi: I have a sub form which i would like to show all the records selected from a table. There may well be over 100 of them. For reasons I cant fathom, the form will only show six, and then requires that you move using the record selection box to see any records below that. I would like the whole record set to be available using the vertical...
1
1795
by: Haydn Williams | last post by:
Hi, I have a load of records in a datalist, where RepeatColumns=3. The records are sorted by a particular field, and the sort order runs down the first column, then jumps to the top of the second column, down that and then jumps to the top of the third column. Is there any easy way to make the records run horizontally (ie left-to-right...
0
891
by: Jason Caid | last post by:
I'd like to be able to create a page that will allow for a single record from a database to be shown with the columns laid out vertically on top of each other and the data shown next to each column label horizontally, similar to a Data Access Page from Access or the Data -> Form tool from Excel. I assume I'll probably need to somehow...
4
4438
by: Tmuld | last post by:
Hello, I have a page that needs to only show 1 record at a time - but there are many fields - I want to display it vertically instead of hornizonatlly. The headers will run vertically as well. Sort of like this
18
2149
by: ILCSP | last post by:
Hi, I just started learning Visual Basic (VB.NET 03) and I need to do this small program that will read a text file we get from another company that has survey data, parse it and flatten it out and make single strings out of the records in it. The major difference between this space delimited file from the many examples in these groups is...
2
4696
by: sachjn | last post by:
Hi, I need to have a table along with other UI items in page which resizes horizontally and vertically with the browser window. That means table should accoupy the remaining available space in the browser window and should display horizontal and vertical scroll bars if content of table is more than available width & height. I can do similer...
1
2199
by: AimeeRae | last post by:
I need to create a report based off the following table (column headings): Station/Date/TransType/Offer1/Offer2 Station can be either: (KTTB or WOA) Date is variable TransType can be either: (Inquiry, lead or new order) Offer 1 is a number Offer 2 is a number
1
3550
by: tanya2001 | last post by:
hi all now i have a query on crystal reports in .net.I have to generate a report in my webform by displaying one column vertically and other one horizontally....so how do u suggest...i should use it....i knw tht v do using d formula in crystal reports in .net but i have no idea of the formulae used in it....can somebody plzz help me generate...
4
2290
by: crazychrisy54 | last post by:
Hi there, I am new to JavaScript and wonder if it could be used to solve my problem, any help would be much appreciated! I have a html web page which contains a table on the left hand side and image on the right, both of which are updating. As the image updates however it gets bigger and starts to look messy next to the constant sized...
0
7579
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8101
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7941
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6235
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5479
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5201
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3628
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2077
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1194
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.