Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

combo box data entry error

0 views
Skip to first unread message

pubdude2003 via AccessMonster.com

unread,
Nov 11, 2007, 6:33:44 PM11/11/07
to
I have a pop up modular form (Prices) that is opened from another pop up
modular form (Calcs) that seems to ignore the very first keystroke in the
combo box on the Prices form. If I open it directly it functions fine but
when it's opened from the Calcs form (using a trapped Alt key) it totally
ignores the first keystroke and only starts the list lookup upon the second
keystroke....

any insights would be appreciated!

--
Message posted via http://www.accessmonster.com

ruralguy via AccessMonster.com

unread,
Nov 11, 2007, 7:33:08 PM11/11/07
to
What event are you using to detect the <ALT> key? AFAIK you can not look at
the <ALT> key without also having a standard key.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200711/1

pubdude2003 via AccessMonster.com

unread,
Nov 11, 2007, 7:43:59 PM11/11/07
to
hey ruralguy.... any snow yet?

here's the code I am using to open the form, the calcs form is a calculator
and the prices is a small pop up I am using to pop one field of the calcs
form... I am afraid that I don't know what you mean by "you can not look at


the <ALT> key without also having a standard key"

Select Case KeyCode
Case 111, 191 'Divide
KeyCode = 0
Me.hiddensym1 = "/"
DoCmd.GoToControl "2"
Case 106 'Multiply
KeyCode = 0
Me.hiddensym1 = "*"
DoCmd.GoToControl "2"
Case 107 'Addition
KeyCode = 0
Me.hiddensym1 = "+"
DoCmd.GoToControl "2"
Case 109, 189 'Minus
KeyCode = 0
Me.hiddensym1 = "-"
DoCmd.GoToControl "2"
Case 32 'Space+
KeyCode = 0
CloseCalcsForm
End Select
If Shift = 4 Then
With Me.ActiveControl
.SelStart = 0
.SelLength = Len(.Text)
End With
DoCmd.OpenForm "StockPricesPopUp"
End If

pubdude2003 via AccessMonster.com

unread,
Nov 11, 2007, 7:56:31 PM11/11/07
to
yep, I just trapped another key and it works fine... just something about the
Alt key trap... weird eh? whoops, gave away my Canadian status there....

Is there a way around this?

ruralguy via AccessMonster.com

unread,
Nov 11, 2007, 7:58:32 PM11/11/07
to
No snow yet. What event is this code in?

--

pubdude2003 via AccessMonster.com

unread,
Nov 11, 2007, 8:13:12 PM11/11/07
to
Key Down

--

ruralguy via AccessMonster.com

unread,
Nov 11, 2007, 8:25:53 PM11/11/07
to
What other key did you trap and what action was taken? What key are you
trying to pass to the next form?

pubdude2003 wrote:
>yep, I just trapped another key and it works fine... just something about the
>Alt key trap... weird eh? whoops, gave away my Canadian status there....
>
>Is there a way around this?

--

pubdude2003 via AccessMonster.com

unread,
Nov 11, 2007, 8:34:13 PM11/11/07
to
thanks for looking at my post ruralguy... I think I will just open this form
with a trapped Ctrl key instead... seems to work fine

thanks for letting me know about the Alt key

ruralguy via AccessMonster.com

unread,
Nov 11, 2007, 8:51:15 PM11/11/07
to
AFAIK the Ctrl key should act that same as the Alt key. Any chance you could
send me a sample of your db that demonstrates this issue? I get the feeling
something else is going on here. My addy is Rural Guy at Wild Blue dot Net
if you can see your way clear to let me have a sample. Remove any sensitive
data of course. Thanks.

pubdude2003 wrote:
>thanks for looking at my post ruralguy... I think I will just open this form
>with a trapped Ctrl key instead... seems to work fine
>
>thanks for letting me know about the Alt key

--

RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

pubdude2003 via AccessMonster.com

unread,
Nov 12, 2007, 6:12:06 AM11/12/07
to
thanks!
0 new messages