[AccessD] An Interesting question

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Sun Mar 29 22:10:59 CDT 2009


It would probably work.  But it's about the same level of elegance (or lack
thereof) of the overlay approach (text box overlaying the bound text or
combo box made visible or invisible depending on whether there was a
non-null value in the bound field). 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Sunday, March 29, 2009 7:06 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] An Interesting question

Hmmm, other then the obvious 'Ummm why?' questions <grin>, what about
running a little code on the OnCurrent event to 'unbind' each control which
is null, and placing a 'default' value into them?  Then on the OnFocus event
of the controls, rebind them?

Not sure if that would work, just an idea..... 

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Sunday, March 29, 2009 5:34 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] An Interesting question

The default values are NULL.  What he wants is for something to show in that
field if the value is null.  For example on the Time Sheet there's a text
box bound to a field named Action.  When the value of the current record is
null (new record or not) he wants the box to show "Action".  But he doesn't
want "Action" to be the value of the field in the record. Just wants to show
what amounts to a label on an unlabeled field so that the user has some idea
of what goes into that field.  And yes, the field already has a tool tip.


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Sunday, March 29, 2009 2:38 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] An Interesting question

Well on a new record, it would just be setting the default value.  But if a
field is null, isn't that a value in and of itself?  

See if you can follow my logic on this.  A default value sets a value in a
record automatically, if it is not changed.  If it is changed, then the
record isn't null, it's whatever the user selects (even if it's blank,
that's not null, that's an empty string).  So the null values would only be
for 'older' records, where the value wasn't selected (and there was no
default value).  Therefore, the solution would be to simply set a default
value (I would recommend it being set in the table definition for that
field), and then simply write some code, that would check for nulls in the
current recordset (OnCurrent event), that would set any null field to the
default value defined in the table def.  This would effectively eliminate
any null values in the underlying data, as they are viewed in your form.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Sunday, March 29, 2009 4:23 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] An Interesting question

A client writes in to ask:

"Can combo boxes and text boxes be configured to display a pre-selected text
if the field is null or the record is new.  For example, could the fields on
the TimeSheet that have no labels have the "labels" show on the combo box or
text box until a user enters something for that field? "

These are bound combos and text boxes.  I can think of a couple kludgey ways
to do this - overlays with label text that are visible only if there's
nothing in the field would be one.  But is there a really good way?

MTIA

 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 

 
The information contained in this transmission is intended only for the
person or entity to which it is addressed and may contain II-VI Proprietary
and/or II-VI Business Sensitive material. If you are not the intended
recipient, please contact the sender immediately and destroy the material in
its entirety, whether electronic or hard copy. You are notified that any
review, retransmission, copying, disclosure, dissemination, or other use of,
or taking of any action in reliance upon this information by persons or
entities other than the intended recipient is prohibited.


--
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 The information contained in this
transmission is intended only for the person or entity to which it is
addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive
material. If you are not the intended recipient, please contact the sender
immediately and destroy the material in its entirety, whether electronic or
hard copy. You are notified that any review, retransmission, copying,
disclosure, dissemination, or other use of, or taking of any action in
reliance upon this information by persons or entities other than the
intended recipient is prohibited.


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




More information about the AccessD mailing list