Hans-Christian Andersen
hans.andersen at phulse.com
Thu Mar 21 14:04:18 CDT 2013
That graph doesn't surprise me. Microsofties tend not to stray far off the path unless it has Microsoft logo on it or has been blessed by the Don. - Hans On 2013-03-21, at 10:14 AM, "Jim Lawrence" <accessd at shaw.ca> wrote: > Hi Shamil: > > Thanks for the response and the great links. (This should keep me > entertained for days) > > Here is a link to an interesting graph that is very telling: > > http://www.dofactory.com/images/javascript-github3.jpg > > Note: that the graph information was acquired from Github and probably not a > true representation of the entire web based world. > > The Pro JavaScript + jQuery Design Patterns section looks very interesting. > > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov > Shamil > Sent: Thursday, March 21, 2013 9:16 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Math equations > > Hi Jim -- > > Thank you. > > That was just about a month of Software Design Patterns and VB.NET 2003 > "home research project" in October-November 2006. > I was a kind of "excited' about GoF ( > http://en.wikipedia.org/wiki/Design_Patterns ) and related concepts that > time and so I decided to "test them in practice". > The diagrams and all the other web stuff is generated from the VB.NET > project code by using Enterprise Architect ( http://www.sparxsystems.com/ ). > > BTW, the best web site on Software Design Patterns I know about is located > here: http://www.dofactory.com/Default.aspx > > -- Shamil > > > Четверг, 21 марта 2013, 8:15 -07:00 от "Jim Lawrence" <accessd at shaw.ca>: >> Hi Shamil: >> >> That is incredible! How long did you take to build and populate that series >> of pages? (from 2006 to now?) Magnificent job. >> >> Jim >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov >> Shamil >> Sent: Thursday, March 21, 2013 1:22 AM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] Math equations >> >> Hi John -- >> >> Quick hint: eval(...) and maybe also 'Strategy Pattern' ( >> http://smsconsulting.spb.ru/shamil_s/patterns/calc/index.htm ) - google for >> the more details of the latter.... >> >> Thank you. >> >> -- Shamil >> >> >> Среда, 20 марта 2013, 23:16 -04:00 от John W Colby < jwcolby at gmail.com >: >>> Does anyone know a way to implement "dynamic" math equations in Access? I >> am implementing a system >>> for building up strings of verbiage for mail merge letters. The verbiage >> is dependent on the >>> insurer of a loan and the state that the loan is in. For example it might >> say something like >>> >>> "Please Bid $X." X is the result of an equation that may be something > like >>> >>> X = the greater of FMV or MakeWhole but X must be at least 2/3 TotalDebt. >>> >>> Or it may say something like X = Y% * FMV or TotalDebt whichever is less, >> where Y% comes from the >>> insurer table, i.e. Y is 80% for insurer A, 90% for insurerB and 100a% for >> InsurerC. >>> >>> The equations can depend on the state but also a % figure taken from the >> insurer. >>> >>> There are 51 states and 5 insurers so there are a ton of possible >> combinations / equations. All of >>> which comes from a spreradsheet of text "descriptions" for each insurer > for >> each state which I am >>> supposed to somehow compute. >>> >>> The old system just used a slew of hard coded equations in huge iif() >> statements, embedded directly >>> in fields in queries. >>> >>> ICK! >>> >>> I would prefer to somehow map this to a small(er) set of equations with >> values fed in from the >>> state and insurer tables. The verbiage strings would be stored in the >> state table, possibly a >>> state/insurer table. where the verbiage is in the table with replaceable >> symbols in the string. I >>> could pull the string out of the table, look for X and run a math function >> to figure out X and >>> substitute the literal X (or other "replaceable character" ) with some >> dollar amount. >>> >>> And finally I would like to avoid VBA code if possible. The intent is to >> eventually move these out >>> of Access so if the solution mapped easily into C# that would be good. >>> >>> I have never really seen anything like this implemented (table driven) and >> I am drawing a blank on >>> how to go about it, particularly without resorting to custom VBA > functions. >> In the end VBA >>> functions are preferable to IIF() statements in custom Access queries. I >> could at least "port" VBA >>> to C# later. >>> >>> -- >>> John W. Colby >>> >>> Reality is what refuses to go away >>> when you do not believe in it > -- > 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