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.