[AccessD] Find First in an Array? - The Solution

William Hindman wdhindman at dejpolsystems.com
Sun Feb 22 16:44:24 CST 2009


...can't speak for Rocky but I've got three good solutions and two sample 
mdbs, all of which work ...hard to beat that!
...thanks all :)

William

--------------------------------------------------
From: "Max Wanadoo" <max.wanadoo at gmail.com>
Sent: Sunday, February 22, 2009 5:25 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Find First in an Array? - The Solution

> Rocky,
>
> My last direct posting to you via the mdb addresses all the concerns in 
> your
> last three posting which have just hit my in-box.
> It does use the caption.tag to store the language strings but when I get
> some time I will see about appending a user.property to the form. I think
> that is doable so you don't need to have to use the .tag.
>
> But anyway, the last version allows for instant swapping between languages
> in a flash.  No need to create different versions for different language
> clients.  One version now fits all.  It also has code to create all the
> language strings from the language table - you don't have to type any 
> thing
> in - just run the code.
>
> I would also recommend the options from John, Stuart etc which all have
> advantages.
>
> Have a look.  Sorry about the diminishing market but in the UK I think it 
> is
> starting to pick up again so hopefully that will happen in the US.
>
> Take care.
>
> Max
> Laugh more than cry.  Smile more than frown.  Be generous in  spirit.  And
> always stand your round in the pub!
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
> Beach Access Software
> Sent: 22 February 2009 22:08
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Find First in an Array? - The Solution
>
> I'm flexible.  I'm bending over for these people right now.
>
>
> 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 Max Wanadoo
> Sent: Sunday, February 22, 2009 2:30 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Find First in an Array? - The Solution
>
> Further to my last posting, Rocky.
>
> I suppose you could also give the evaluators the one you currently have
> where the form get updated each time based on the language selected and 
> tell
> the potential clients that a language specific option is available with
> improved form rendering.  Then when the order (as they will surely do) 
> give
> them the translated mde copy,  Flexibility is the keyword here, I think.
>
> Max
> Laugh more than cry.  Smile more than frown.  Be generous in  spirit.  And
> always stand your round in the pub!
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
> Beach Access Software
> Sent: 22 February 2009 08:47
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Find First in an Array? - The Solution
>
> Another complication - evaluators can be requested from the web site.  I
> suppose I could ask for the language as part of the request.  I'd have to
> allow them to ask for multiple copies - different languages in case French
> speaking management wanted to evaluate it as well as the Chinese workers 
> in
> the factory.  IOW, the customer may not know for sure which language they
> want.
>
> Plus I'd have to maintain currently 5 versions of the program - one for 
> each
> language.
>
>
> 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 Max Wanadoo
> Sent: Saturday, February 21, 2009 5:12 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Find First in an Array? - The Solution
>
> Hi Gustav,
> Pub is now dry.. came home...ha!
> Well, if you are sending an MDE you would run the Translation Program then
> convert to an .MDE and then send it to client and then go back to pub - 
> eh?
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
> Sent: 21 February 2009 23:14
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Find First in an Array? - The Solution
>
> Hi Max and Rocky
>
> OK, that minor reason turned into a major; you will perform design changes
> of the forms which isn't possible in an mde.
>
> /gustav
>
>>>> Gustav at cactus.dk 21-02-2009 16:10 >>>
> Hi Max
>
> Very good! You have point here.
> It's a bit like Drew's suggestion but with a clever twist which I will 
> leave
> for others to figure out (I have seen the sample db from Max).
>
> I can, however, think of one minor reason to not use your approach.
>
> Who said you don't get bright ideas while sleeping?
>
> /gustav
>
>>>> max.wanadoo at gmail.com 21-02-2009 13:47 >>>
> Hello Rocky,
> Well, I have read with interest all the to-ing and fro-ing from the 
> various
> contributors.
> So, I laid me down laterally and started thinking laterally.
> The solution came to be sometime around my 3rd drink.
> I consolidated my thoughts in bed.
> When I woke this morning, I tested them out with a sample mdb using 
> English,
> French and German.  All work beautifully.  Add as many languages as you
> want.
>
> The solution I have has the following benefits:
>
> Instantaneous
> No variables
> No Collections
> No Classes (although the solution could be said to be upper class <ha!> No
> Arrays No Memory overheads Forms shown the language required every time 
> with
> no overheads.
> Unlimited Languages
>
> Should I post the sample mdb to you?
>
> Max
> Ps. Bet your intrigued - you will love this solution.
>
>
>
> --
> 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
>
> --
> 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
>
> -- 
> 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