Create a Keypad in an Access form and Subform

[Gicu]

Hi Micron,

Beg to differ, I think the approach I was suggesting was close to what Xavier was looking for (I did mention changing the calling of the popup from double-click to enter event), so I went ahead and played a bit with it today. Would you have a look and please comment on its functionality now? I did try it on my touch screen laptop and seems to work OK.

Colin, thanks for letting us know that OP is no longer in need of a solution, I guess I can't stop playing with Access ......(SAD as Mr. Trump would say ).

Cheers,


Vlad

[BigJohn89]

Hi Gicu,

I'm trying to change numbers for letters (to use your method to type words in login screen) but I've get an error "Run-time error '2113' the value you entered isn't valid for this field"
Where can I change numeric field to text field to store text?





Cheers
J

[isladogs]

Hi Micron,

Beg to differ, I think the approach I was suggesting was close to what Xavier was looking for (I did mention changing the calling of the popup from double-click to enter event), so I went ahead and played a bit with it today. Would you have a look and please comment on its functionality now? I did try it on my touch screen laptop and seems to work OK.

Colin, thanks for letting us know that OP is no longer in need of a solution, I guess I can't stop playing with Access ......(SAD as Mr. Trump would say ).

Cheers,
Vlad

I know the feeling about can't stop playing.
I spent several hours trying to get current geolocation in Access using code so it could be marked on a map in the standard way.
I got a working solution and was happy, then Window 10 Version 1803 update got installed and broke the geolocation service code.
I'm still working on a new alternative

Anyway I tried your keyboard on my tablet and it worked as intended.
For a tablet it helps if the textboxes are bigger so you can click in them easily.
However, your number pad doesn't take up much less screen space than the first keyboard in my earlier screenshots

[Micron]

Hi Micron,
Beg to differ, I think the approach I was suggesting was close to what Xavier was looking for (I did mention changing the calling of the popup from double-click to enter event) .

If this is the same upload as your prior one, where's the popup keypad when I interact with the single visible form? I'm not seeing one.

[Gicu]

Hi Micron, it is not the same one, I modified the original (you should see a blue form when it opens.

BigJohn89 you need to look at the popKeyboard form's code,each button adds its caption to the text box. The fields in my test are all numeric -test1 through test10 in tblTest.

Cheers,
Vlad

[Micron]

OK, now I agree. My comment was based on the first db you posted. Thanks for the update.
I've only had a moment to play with it - gotta run. What I had in mind might be a wee bit more robust or intuitive, which might prove to be a detriment, but it seems quite close. Will have to take a closer look later. Thanks.

[davedinger]

I use something like this to send values to a field in an inventory program. maybe its on the same track.

I created a Control on the main form to change the value in the Quantity field of the Sub form Scan Data

I made several control buttons on the side of the main form that would change the value of the last entered field.
for instance one Control for 10, a control for 20 one for 30 ect.
when i click on the button it backs up to the last field and changes the value from 1 to whatever the button is. IE 10
its very similar to what was the send keys function.
maybe you could make the "Key Pad" out of Control buttons?


Private Sub Command11_Click()
Me.Scan_Data_Subform.SetFocus
DoCmd.GoToRecord , , acLast
Me.Scan_Data_Subform!Quantity.SetFocus
Me.Scan_Data_Subform!Quantity.Value = 20
DoCmd.GoToRecord , , acNext
Me.Scan_Data_Subform![Part #].SetFocus
End Sub