[AccessD] Regarding multi-value field, from a reader

William Benson vbacreations at gmail.com
Thu Nov 1 12:49:21 CDT 2012


Cant the values change to something Access sorts natively? Or did I miss
the essence of the problem
On Nov 1, 2012 12:38 AM, "William Benson (VBACreations.Com)" <
vbacreations at gmail.com> wrote:

> Why not change the values?
>
> 1 (Mo),2 (Tu),3 (Wd),4 (Th),5 (Fr)
>
> I mean, is something limiting them to a single character?
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
> Sent: Thursday, November 01, 2012 12:05 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Regarding multi-value field, from a reader
>
> Yeah, those sort of features remind me of junk food.  The worse it is for
> you, the more folks seem to like to over indulge.  In Excel for example the
> 'feature' of merged cells is used (and promoted) widely as being a
> wonderful
> thing, but can cause you enormous grief and pain if used without due care
> and consideration.  Of course, no one tells the users that.  They just
> merge
> away like buggery.
>
> I can think of many other examples as well...  So much so that I like to
> use
> the term (ab)user rather than user with referring to some of my more
> troublesome employees of my clients.  Hehe.
>
> Cheers
> Darryl
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
> Sent: Thursday, 1 November 2012 2:58 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Regarding multi-value field, from a reader
>
> Trouble is, the users get into trouble with all those little bits that
> added
> just for them!
>
> Charlotte
>
> On Wed, Oct 31, 2012 at 8:52 PM, Susan Harkins <ssharkins at gmail.com>
> wrote:
>
> > Charlotte, that's a fantastic idea! I don't use them either, but
> > they're there for the users.
> >
> > Susan H.
> >
> >
> >
> >  Maybe a little remedial instruction on normalization for the reader?
> > I've
> >> always avoided multi-valued fields like plague, but I wonder if you
> >> could fake it by using a hidden column 0 in the listbox with a
> >> numeric sort order and a visible column with the desired values?
> >>
> >>
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/**mailman/listinfo/accessd<http://database
> > advisors.com/mailman/listinfo/accessd>
> > Website:
> > http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
> >
> --
> 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
>
>


More information about the AccessD mailing list