Numeric keypad Form entry

  • Thread starter Thread starter BillH
  • Start date Start date
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
 
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
 
Back
Top