Competent Performer
Windows 10 
Access 2016
Hi everyone, i have a very huge problem which i don't know how to go about.
I have 2 tables (Product and ProductCategory). The table product has about 40 records, and every record in that table has an image and
is assigned to a category.
Note that the images in that table have a datatype of attachment.
The issue
I want to have a form that displays IN AN HORIZONTAL MANNER the images, names, and prices of all products.
Kindly have a look at the attached picture to understand what i mean.
VIP
Windows 7 64bit Access 2010 32bit
Try multi-column Page Setup.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Competent Performer
Windows 10 Access 2016
It seems multi-column Page Setup works only for reports.
VIP
Windows 10 Access 2016
you can have multiple sub forms. each one representing an image.
Competent Performer
Windows 10 Access 2016
Then I will end up with 40 sub forms.wow
Am sure there could be a better way.
VIP
Windows 7 64bit Access 2010 32bit
Why would this be of value presented on a form? Why not use a report?
It is possible to have a subreport display on a form. I have done that but never tried multi-column report on form.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
How to Display Images in a Form or in a Report Without Storing the Images in a Table
Posting Permissions
Reply With Quote