[AccessD] MS Access Drawing Capabilities

johncliviger at aol.com johncliviger at aol.com
Sat Nov 15 05:11:20 CST 2008


Paul

I've just used Paint to create an "L" shaped graphic and imported in to an Access 03 Form using the Image control where? you've?got 5 events to play with. And its works fine.

johnb


-----Original Message-----
From: Darryl Collins <Darryl.Collins at coles.com.au>
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Sent: Fri, 14 Nov 2008 23:37
Subject: Re: [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 ap
preciated.
>
>
>
> 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.


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


________________________________________________________________________
AOL Email goes Mobile! You can now read your AOL Emails whilst on the move. Sign up for a free AOL Email account with unlimited storage today.



More information about the AccessD mailing list