S sneuf via AccessMonster.com Jul 19, 2006 #1 How do I set Overwrite on in VBA so that it is like pressing the Insert key on the keyboard?? Thanks, Steve
How do I set Overwrite on in VBA so that it is like pressing the Insert key on the keyboard?? Thanks, Steve
S Scott McDaniel Jul 19, 2006 #2 How do I set Overwrite on in VBA so that it is like pressing the Insert key on the keyboard?? Click to expand... 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 Click to expand... Scott McDaniel scott@takemeout_infotrakker.com www.infotrakker.com
How do I set Overwrite on in VBA so that it is like pressing the Insert key on the keyboard?? Click to expand... 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 Click to expand... Scott McDaniel scott@takemeout_infotrakker.com www.infotrakker.com
S sneuf via AccessMonster.com Jul 20, 2006 #3 Thank you! Scott said: 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 Click to expand...
Thank you! Scott said: 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 Click to expand...
