[AccessD] Create/Hide Buttons on Form?

Mark,

You can create buttons programmatically, but binding code to them
requires directly manipulating the form's code module, which is a pain.
No control arrays in Access, unfortunately.  You can create the buttons
ahead of time and show or hide them and populate their captions based on
a table, though.  Why not use a table driven approach a la the
switchboard manager. 

Charlotte


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Thursday, February 23, 2006 9:52 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Create/Hide Buttons on Form?


Jim,

Yes...I have thought of that...but not as worried yet because I still
didn't 
know if I could, or how to create the buttons programatically.  Drop
downs 
are out of the question...but maybe I should move to VB.

Thanks,

Mark A. Matte




>From: "Jim DeMarco" <Jdemarco at hudsonhealthplan.org>
>Reply-To: Access Developers discussion and problem
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem solving" 
><accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Create/Hide Buttons on Form?
>Date: Thu, 23 Feb 2006 09:44:07 -0500
>
>Mark,
>
>Have you thought about what happens when they've created enough new 
>items
>to exceed your screen space?  Is a drop-down list out of the question
for 
>this app?  If this were a VB app you'd have a much easier time creating

>visual elements dynamically than with Access.
>
>Just some thoughts.
>
>Jim DeMarco
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte
>Sent: Wednesday, February 22, 2006 12:12 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Create/Hide Buttons on Form?
>
>
>Hello All,
>
>I'm attempting an app related to restaurant/bar management in A2K.  The

>dilemma I have is in design.  I want them to have the ability to add 
>new products/seats...but I'm not sure the best way to approach this.  
>For instance...if they add a new menu item...I want a new button to 
>appear. Should I make a predetermined number of buttons and hide them 
>or should I program the app to create and place a new button when the 
>new value is added ( if this, suggestions?)
>
>Thanks,
>
>Mark A. Matte
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>
>
>
>
>***********************************************************************
>************
>"This electronic message is intended to be for the use only of the
named 
>recipient, and may contain information from Hudson Health Plan (HHP)
that 
>is confidential or privileged.  If you are not the intended recipient,
you 
>are hereby notified that any disclosure, copying, distribution or use
of 
>the contents of this message is strictly prohibited.  If you have
received 
>this message in error or are not the named recipient, please notify us 
>immediately, either by contacting the sender at the electronic mail
address 
>noted above or calling HHP at (914) 631-1611. If you are not the
intended 
>recipient, please do not forward this email to anyone, and delete and 
>destroy all copies of this message.  Thank You".
>***********************************************************************
************
>
>--
>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