alternative to SendKeys in VBA editor

[Bobby]

Hello,

I'm trying to do some simple emacs-like macros in the VBA editor for
access. I've figured out how to use VBA.SendKeys to insert the text I
want, but I'm wondering if anyone can tell me a better way to do it.
specifically I'd like to have direct access to the document currently
being edited, but I can't seem to find it.

This is in access 2002

Thanks.

 

[Stephen Bullen]

Hi Bobby,

I'm trying to do some simple emacs-like macros in the VBA editor for
access. I've figured out how to use VBA.SendKeys to insert the text I
want, but I'm wondering if anyone can tell me a better way to do it.
specifically I'd like to have direct access to the document currently
being edited, but I can't seem to find it.

This is in access 2002

The objects to manipulate the VBA Editor are all in the 'Microsoft
Visual Basic for Applications Extensibility' library. I don't know of
any online resources that explain how to manipulate it in detail, but I
wrote about it (from an Excel POV, but most is the same for Access) in
the Excel 2002 VBA Programmers Reference.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk