[AccessD] MS Access Drawing Capabilities

Expanding on Stuart's idea, If you have an existing layout of the plans as a JPG or similar, cut it into the component shapes using a picture editor, import the objects like a jigsaw and piece them back together and then put a click event on them to open up a details popup form.  this may save you a lot of drawing - Just a thought.

Or you maybe even able to use code to track where the mouse is over the image and just use that instead (?)

cheers
Darryl.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Saturday, 15 November 2008 10:13 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MS Access Drawing Capabilities


Are all booths rectangular?  If so, you can possibly do it by placing  different sized buttons
on a form. By naming the buttons consistently to identify the booths, it would be fairly simple
to write a generic function called from the on_ckickthat popped up a msgbox or modal form
with the info for the specific booth.




On 14 Nov 2008 at 12:58, paul_lifopro wrote:

> I'm volunteering my time to work on a small system for a non-profit
> organization.
>
>
>
> The organization has an Expo every year and they have been keeping track of
> the exhibitors, booth space and donated items using Excel.  While this
> works, its pretty time consuming and inefficient.
>
>
>
> I have the DB, Forms and reports pretty well finished.  What I need help on
> is how to create a diagram/chart of how the booths are set up in the
> building.  It seems like I should be able to interface Access and maybe
> Visio to get this done.
>
>
>
> Ideally, I'd like to draw he booth setup on a form and then somehow let the
> people click on a booth and have a modal form come up and show the
> information about the booth i.e. size, is it taken, is it a premium booth,
> etc.
>
>
>
> I've googled every key word I can think of but haven't been able to find any
> examples.
>
>
>
> Any help would be appreciated.
>
>
>
> Thanks
>
>
>
> Paul
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.