Use Sendkeys to type repetitive text
Posted on 2008-10-28
We used SendKeys extensively in Access97 databases for repetitive text entry. Having upgraded to Access2000 - SendKeys no longer works. I have read the Q & A here about avoiding the function but I believe most of the cautions don't apply for how we want to use it. I have tried to use "Replacement for SendKeys" by Dev Ashish but can't get it work for how we want to use it. Can anyone offer a solution?
Here is the gist of what we would like... We frequently enter repetitive text into a field directly in a table and sometimes using a form. We used to be able to press a keystroke combination (Macro name ^A or ^P or ^R etc.) that then just "autotyped" the text into the field the cursor was in when the key combination was pressed. For example, Pressing ^P would put "Pittsford, N.Y. 14534-1999" into the field. Pressing ^R would put "Rochester, NY 14620-" into the field and wait for the user to type the last 4 digits. These (along with 8 other, much longer, text entries) saved the user a lot of time and helped to prevent typos.
We can't use "Ctrl" ' because it is not always the row directly above that is being repeated. Does anyone know another way to do this? Does anyone know how to get sendkeys to work for this seemingly simple situation? We don't want to access menus or dropdowns or switch fields or views or anythiing other than typing in repetitive text.