[AccessD] Conversion

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Sun Feb 5 11:46:45 CST 2006


No performance hit because it's all front end stuff.  I open the 
translate tables (using DAO) when the app opens and keep them open.  The 
translate routines use .FindFirst.  The Controls table has 2261 records 
and the messages table has 384, so it goes real fast.  There is a small 
but perceptible delay translating a form with a lot of controls but its 
very acceptable - way under a second.  OF course I'm using a fast pretty 
machine - 2GHz but that's not unusual these days.  It seems to go just 
as fast on my P3 machine which, I think, is 800MHz, but can't remember.

Rocky


Rocky


Susan Harkins wrote:
> Is this time consuming? Do you see a hit in performance? Does this routine
> get called just once and then everything's saved someplace or does it run
> every time the form/report is viewed? 
>
> Susan H. 
>
>
> The basic form or report translate routine gets the form or report name
> passed to it.  The code cycles through all of the control on the form or
> report checking to see if that control name is in the table.  If so, it gets
> the appropriate translation and changes the control - mostly the caption
> property.  The translate routine for the message boxes runs the same way,
> only I pass the name of the message to the translation routine.
>
>
>   

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




More information about the AccessD mailing list