Multiple columns

[bdl1979]

I am trying to make a database for my movie collection. I would really like
to be able to have multiple columns of images (DVD box art) to help me make
my choices. So far, the closest I've come to having multiple columns is in
the print preview mode of a report. I have created a form, but was unable to
find a way to make it have multiple columns and scrolling through 1 title per
line gets kind of old. Any help creating a multiple column form would be
greatly appreciated.

 

[Jeff Boyce]

We aren't there, and we may not have the same definition of "multiple
columns of images" that you have. In fact, you're likely to be reminded
that having multiple columns of the same type of data in a relational
database like Access is a BAD IDEA.

So clarify what you mean first, then ask yourself if you are trying to make
Access behave like a spreadsheet, where, if you needed one more image, you
would add one more column. If so, why not use Excel?! Trying to use Access
to do something like that will only give both you and Access serious
headaches.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Pete D.]

Normally if you have multiple same items to add to one record than you need
another table to store it in and display that table in a subform. Think you
should go to www.microsoft.com and look at some of the template data files
or samples in the MS Office area. Look at the design in these to get an
idea of how the database should be designed.
Pete