I want incorporate a Floorplan into my form

[ZachAtaiyan]

I am not quite sure if what I am going to ask is possible and I do not know a whole lot about MS access at the moment.



I have been tasked with finding out if it is possible, using MS Access, to create a database for analyzing individual building components in 300 facilities across the country. Each of these facilities will likely contain 100-200 records of specific building components. We hope to use a form on tablet PCs on location to enter the data.

I am specificaly wondering if the following are possible to do on a form:

1. Link each record with a specified location, shown as a labeled point on a floorplan. (ex. 001,002,003...)
2. Link a bound image of that floorplan with that specific point shown to the record.
3. Within the form, capture picture(s) of the device and make them bounded images to that record.

The goal of this would be to display the location of each device along with an image of the device with the rest of the recorded data.

Thanks in advance!

[June7]

You have to first decide if you want files stored within table or external to database. Be aware that embedding large files within db can rapidly use up Access 2GB file size limit.

Use Image control on form or report. The Image control can dynamically display images stored in table or externally by setting ControlSource property to an Attachment field that holds the image files or by referencing a path\filename to external file. This path\filename can be stored in a table text field.

What is device - building component? Display images of device in the same manner as floorplan image.