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