Showing many records simultaneously on 1 form (not in a table)

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

Guest

hi

i need to work out how to show many records simultaneously on one form or report

each record has a seat number and a person who sits in that seat

i want to put a picture of the floor plan onto a form and then display all of the records on that picture so you can see who sits where simultaneously as opposed to one record at a time

can this be done?

Mark
 
I think it can be done, but it's not necessarily going to be simple. In
general, you'll need to choose a control to represent each seat (a label or
a command button perhaps). Layout your seating arrangement then I would
suggest naming the controls according to the SeatNumber. Name all of the
seat controls with a common prefix and use the number as the suffix. Then,
write a procedure that opens a recordset with the seating assignments and
loop through it assigning the caption of the labels with the name of the
person assigned to it. Finally, if you want to be able to do input through
this form you could write a procedure that opens a dialog form for the
seating assignment table with the correct seat number already completed.
Link this procedure to the Click event of the label controls.

Hope this helps to get you started.
 
Interesting problem. If at all posible, I would change the structure of you
table. Instead of each record showing a seat number and a person, I would
let each record represent a row of seats. If each row has 20 seats, for
example, then the table would have 41 fields.

row (int) Primary Key
Seat1 (int)
Name1 (Text)
Seat2 (int)
Name2 (Text)
Seat3 (int)
Name3 (Text)
.....

Populate the table with as many rows as you have in the room. Create a form
in the "Tabular" layout and make sure deletes and adds are disabled, and the
rows and the seats are uneditable.

It certainly would make the form easier to handle, although queries would be
more difficult. You could still keep both tables and write a routine that
transfers the data between the tables.

I know it violates the rules of db normalization and all that. I guess it
depends on how the user is going to enter and change seat assignments.

jack

Sandra Daigle said:
I think it can be done, but it's not necessarily going to be simple. In
general, you'll need to choose a control to represent each seat (a label or
a command button perhaps). Layout your seating arrangement then I would
suggest naming the controls according to the SeatNumber. Name all of the
seat controls with a common prefix and use the number as the suffix. Then,
write a procedure that opens a recordset with the seating assignments and
loop through it assigning the caption of the labels with the name of the
person assigned to it. Finally, if you want to be able to do input through
this form you could write a procedure that opens a dialog form for the
seating assignment table with the correct seat number already completed.
Link this procedure to the Click event of the label controls.

Hope this helps to get you started.

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

hi,

i need to work out how to show many records simultaneously on one
form or report.

each record has a seat number and a person who sits in that seat.

i want to put a picture of the floor plan onto a form and then
display all of the records on that picture so you can see who sits
where simultaneously as opposed to one record at a time.

can this be done??

Mark
Click to expand...
Click to expand...
 
Mark,

Contact me I can do this for you. I just recently did something similar for all
the exhibitors at a large cinference.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com




Mark said:
hi,

i need to work out how to show many records simultaneously on one form or report.

each record has a seat number and a person who sits in that seat.

i want to put a picture of the floor plan onto a form and then display all of
Click to expand...
the records on that picture so you can see who sits where simultaneously as
opposed to one record at a time.
 
Back
Top