Numeric keypad Form entry

B

BillH

In a Form, I need to have a 'keypad' open on a mouse click for numeric
entry in multiple Fields. Any help will be appreciated.

Thanks-
Bill Howard
Tufts Medical Center
Boston, MA
 
F

fredg

In a Form, I need to have a 'keypad' open on a mouse click for numeric
entry in multiple Fields. Any help will be appreciated.

Thanks-
Bill Howard
Tufts Medical Center
Boston, MA
Click to expand...

Why not just create your own form with the 10 command buttons that add
a specific number (0 through 9) to a text box.
To get you started, code each button's click event for the appropriate
number value.

Me.Text1 = Me.Text1 & 0
Me.Text1 = Me.Text1 & 1
Me.Text1 = Me.Text1 & 2
etc....
Me.Text1 = Me.Text1 & 9

Add an 11th button to clear the entry when done:
Me.Text1 = Null

You'll probably wish to open the form in dialog:
DoCmd.OpenForm "frmKeyboard", , , , , acDialog

Then refer to that text box for the entered value.
[SomeControl]= forms!frmKeyboard!Text1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numeric keypad 3
How to use numeric keypad in 7 Excel-(raw beginner) 2
Pop-up calendar and clock in Form 1
Numeric Keypad . . . 1
Word 7 2
Force Keypad to Numeric Mode on Smart Device 1
numeric keypad 2
Numeric Keypad? 1

Top