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

Tina, this is an excellent point.  You see the same thing with Excel as well.  On both platforms I usually see users just make a bigger mess via the new user features that is harder to clean up and often hopelessly complex and unwieldy.  Too many folks try to make their databases / spreadsheets look just like their reporting outcomes with little or no understand about how to efficiently and consistently turn data into information over an extended time period.  

A lot of this 'Build by Bob in accounts' in house stuff will (just) function until something changes, then it usually goes to crap pretty fast.  That is when the end up calling someone like me.

Of course that has kept me gainfully employed for quite some time so I owe MS and those folks a big thanks.

Cheers
Darryl

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris Fields
Sent: Friday, 2 November 2012 6:27 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Regarding multi-value field, from a reader

Well, yeah, but that's what they said about Access way back when they first introduced it.  They marketed it as a simple desktop toy that non-programmer types would be able to use by pointing and clicking their way to a fully functional database.  How many times have we been called in to repair one of those "fully functional" databases put together by someone who believed the hype and had no concept of what is really needed for a database?  So, maybe we won't be in the picture much longer, but I'm thinking that until people learn to understand and follow a logic diagram they aren't going to succeed in assembling a "fully functional database" no matter how pretty Microsoft makes the user interface.
T

Tina Norris Fields
tinanfields at torchlake.com
231-322-2787

On 11/1/2012 3:06 PM, Jim Dettman wrote:
>   If you haven't figured it out, we (developers) are not going to be 
> in the picture much longer.
>
>   Microsoft just released details on Office and Access 2013:
>
> http://msdn.microsoft.com/en-us/library/jj162978(v=office.15).aspx
>
> Couple of quotes:
>
> "A new interactive view designer makes it easy for users who have 
> little or no programming experience to build apps. "
> "A new application model enables subject matter experts to quickly 
> create and share applications that can be used to run their business. "
>
>    They are focused on the end user and nothing but and everything is 
> about the cloud and Office 365.  Traditional desktop development with 
> Access is out.
>
> Here's a list of what got pulled out:
>
> http://technet.microsoft.com/en-us/library/cc178954%28v=office.15%29.a
> spx;
>
>
> Two biggies from that:
>
> 1. Access 2003 toolbars and command bars are no longer supported.  You
> *must* use the ribbon.
> 2. ADP's are gone.
>
> And there's a bunch of other stuff, like Pivot Charts.
>
> Jim.
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris 
> Fields
> Sent: Thursday, November 01, 2012 02:52 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Regarding multi-value field, from a reader
>
> Well, for what it's worth, I agree with everybody who said don't use 
> multi-value fields!  Geez, we go to lots of trouble to normalize our 
> data and then Access arrives with new specialties that at least look 
> like the destruction of normalization!  Dang!
> T
>
> Tina Norris Fields
> tinanfields at torchlake.com
> 231-322-2787
>
> On 10/31/2012 7:08 PM, Susan Harkins wrote:
>> Received the following from a reader:
>>
>> "I set up a multivalued field in Access 2010 using a List Box and 
>> providing a Value List with values M,T,W,R,F. Everything works fine 
>> but for one problem. When I chose M, W, F from my list, th 
>> emultivalued filed reads F, M, W ... i.e., the entries are sorted 
>> left to right whereas I want them to show up as M, W, F. Is there a 
>> way to do this?"
>>
>> =====Other than learning the basics so I could write about them, I 
>> don't use them and have almost no experience. Anyone have a quick and 
>> easy answer? I'm going to do a little research, but if anybody knows, 
>> please share!
>>
>> Thanks!
>> Susan H.

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