Set Insert Key to Overwrite

[sneuf via AccessMonster.com]

How do I set Overwrite on in VBA so that it is like pressing the Insert key
on the keyboard??
Thanks,
Steve

 

[Scott McDaniel]

How do I set Overwrite on in VBA so that it is like pressing the Insert key
on the keyboard??

Here's a link to a vbnet article concerning setting keystates. It's VB-centric, but should port easily to Access:
http://vbnet.mvps.org/index.html?code/system/capslock.htm

This deals with the CapsLock key, but you could add this in the declarations:

VK_INSERT = &H2D

and then use VK_INSERT anywhere you see VK_CAPITAL

Thanks,
Steve

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[sneuf via AccessMonster.com]

Thank you!

Here's a link to a vbnet article concerning setting keystates. It's VB-centric, but should port easily to Access:
http://vbnet.mvps.org/index.html?code/system/capslock.htm

This deals with the CapsLock key, but you could add this in the declarations:

VK_INSERT = &H2D

and then use VK_INSERT anywhere you see VK_CAPITAL


Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com