[AccessD] Your favorite control behavior

John,

  Here are some things that might go into your framework (apologies for any
repeats) off the top of my head.  Some are control specific and other are
general items:

  1. Clickable column headers to control sort order.
  2. Dynamic find capability based on currently selected column.
  3. A mover class (two list boxes to/from).
  4. Routine to populate a tree view control from a data source.
  5. Security at field/control level
  6. Popup calendar on date/time controls.
  7. Background/foreground highlight based on current control.
  8. Background row highlight in a continuous form.
  9. Save/restore of user preferences; position of forms, values in filters,
etc.
 10. Scalable resizing of forms.
 11. User activity tracking (objects used).

  Some of these are things I have done in Access, some come from things in
the ADH I've seen but never tried.  But all are things you might want to see
in a Framework from a development perspective for Access.

Jim
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John W. Colby
Sent: Saturday, March 06, 2004 4:24 PM
To: AccessD
Subject: [AccessD] Your favorite control behavior


I am taking suggestions for control behaviors that you have found useful and
have programmed controls to perform in the past.

For example I program the back color of combos, lists and text boxes to
change to a given color as they get the focus, and back to their original
color as they lose the focus.  This helps to avoid the "where's the cursor"
questions.

Another example, I program the double-click of a combo to open a form to
allow editing the data in the table that the combo pulls from.  In addition,
if a combo is programmed to perform this behavior, I dynamically set its
label's back color to a specific color.  this is a visual cue that "this
combo has the dbl-click behavior activated"

What kinds of things do you have your controls do?

John W. Colby
www.ColbyConsulting.com


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