How do I put two or more records on one form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I put two or more records on one form?
Record 1 one on the left and Record 2 on the right.
Maybe even record 3 and 4 under that if there is room
I can get them to come up one under the other ... just not in columns from
left to right. I have a simple flat database with six fields, one of which
is a picture.

It doesn't seem that this shoulbe be difficult but I've been looking for
several hours and haven't been able to figure out how to do it. Hopefully
it's just something simple I'm missing.

Thanks all.
 
You don't really have a form that can display data left to right. And, I
can't think of a more confusing data entry to the end users.

However, you can use what is called continues forms. Take a look at the
following screen shots...it might give you some ideas

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

I think you will have to re-design what you want to accomplish. The trick in
ms-access is not coming up with a design, and then "hoping" ms-access can do
it. The trick is to build a design BASED on what ms-access can do. This is
kind of like building a house out of bricks. You have a particular type of
brick..and can build a near infinite variety of houses. However, if someone
comes along, and wants a design based on a different type of brick..then you
going have great difficulty building that house.
 
From your reply I take it that it can not be done then. Sorry to hear that.
Thank you for taking the time to reply.

FYI This is not a database for any other end user than myself and it would
have helped me to be able to lay it out in this fashion. Although I have
data along with my pictures, my actual search is for a certain picture that I
want to add/edit its data. Consequently it would have been much easier for
me to use a form to page through the pictures to find the one I want if I
only had more than one record/picture on a page. Hope that explains my
quest more.

I've been able to arrange this using a report but of course I have to then
go back and edit with a form, datasheet or the like. I was hoping to make it
more convenient but that doesn't appear to be possible without making a major
project out of it.

Thanks again.
 
Back
Top