create diagram from Access table records? 1

[lorirobn]

Hi,

Is there a way to do this with Access or VBA?

I have a database of our building, with all rooms and spaces in the building as records on tblSpaceUse.

Without the computer, we always refer to a hardcopy of a floor plan to see where rooms are, and we've gotten very used to relying on this visually. It's harder to get a sense of the room when viewing a database record.

Is there any way that I can create a diagram of the floor plan using the records on this main table as a source? If not in Access or VBA, is there other software that Access works with to create a diagram like this?

Thanks in advance for any help.

 

[rjoubert]

Lori,

What is the structure of your table, tblSpaceUse. Can you also post some example data from this table?

 

[lorirobn]

R-
Thanks. Sure, I will give the structure of my table plus example data.

Structure: there is one room record on tblSpaceUse for every room in the building. There are different room types, and wing locations.
Example data:
RoomID Wing Type of Room Floor View
255 Center Guest 2 South
256 Center Guest 2 North
310 East Dorm 3 South
311C East Storage 3 North

(this is very simplified data).

The floor plan we use looks something like this but is not as simple:

|------|------
|255 | 257 |
| | |
--------------
hallway ....
|------|------
|256 | 258 |
| | |
--------------

hope this helps understand...
Lori

 

[lorirobn]

ps - I guess what I'm looking for is a way to do an Image Map. If I can't do it myself, does anyone know of good Image Mapping software to use with my Access/VBA application?

 

[dhookom]

There is a sample form and report used to map seating and reservations in an auditorium at

http://www.hookom.net/access/samples/seating.zip.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lorirobn]

That is really great, Duane!
Could I do something like that if every floor is not the same layout? I wouldn't be able to do rows/columns the way you did it (in a continuous form, grid-like).

Also, the building is U-shaped, not straight horizontal line. Could I do something like you did for this?

Thanks very much -
Lori

 

[dhookom]

You can do whatever you want with my sample. I suggest you divide your layout in separate sections to display in at least your forms and possibly your report.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lorirobn]

I am getting a sense for how this could work for my floor plan, and it is really great...and thanks for the suggestion on dividing into section for forms and report.

How did you figure out the numbers for your RowYVal, and SeatXVal? Does this have to do with position on the form? I notice SeatXVal is mostly incremented by 900, but once it is incremented by 1980, and another time, 1900???

Thanks again, Duane,
Lori

 

[dhookom]

The values were trial and error to get the spacing of the seating from left to right. A greater increment suggests an aisle between seating sections.
[tt]
Row Seats--->
1 [red]A B C D E[/red] [blue]F G H I J K[/blue]
2 [red]A B C D E[/red] [blue]F G H I J K[/blue]
3 [red]A B C D E[/red] [blue]F G H I J K[/blue]
[/tt]

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lorirobn]

Duane,

Can you explain to me the function of tblTempSeating?

Thanks,
Lori

 

[dhookom]

I think it just un-normalizes your table so that records can be edited in a prettier user interface.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lorirobn]

Duane - I put together something where I actually put each room right on a map, instead of rows and columns, but your db was the impetus for my idea. I NEVER could have done this without you, and it looks GREAT!!!

Thank you so much, and here's a star...

Lori

 

[dhookom]

Glad to hear that you have experienced success.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]