---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :
I guess I'm not getting the "right time" Bill since I need to do a txtInput.setfocus and well, there's the rub.
BUT… I wrote a little piece of code that has tested out in development that is on the keypress event that accrues the time and if it is > 20 milliseconds I know it is manual entry and if it is less then I know it is from the scanner.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, November 25, 2015 2:53 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: disable keyboard
Liz
Yes, unless you disable it...like I told you.
Me.lblFake.Visible = False
Me.txtuserName.Enabled = False
Of course, you have to reverse that stuff at the right time so you are back to the label showing on top.
-Bill
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :
Hey Bill, I'm finally to this stage of the project and it all looks pretty good and well, but when the focus is on the underlying text box, it is exposed to keyboard entry too.
Hmmmmm…..
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, November 18, 2015 3:18 PM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Re: disable keyboard
Yes, that's my suggestion. By putting a label over the text box, the user can't enter anything there. But the scanner should be able to "see" it and enter the number. The AfterUpdate event would hide the label thus exposing the text box. Then you disable the box so the user can't change it.
Regards,
Bill Mosca
From: "Liz Ravenwood liz_ravenwood@... [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, November 18, 2015 1:23:37 PM
Subject: RE: [MS_AccessPros] Re: disable keyboard
Is this it?
"hmm... Maybe use a label as a dummy place holder with a text box behind it. use the AfterUpdate event to hide the label and switch the text box to disabled."
I'm not sure this would work. I have a text box where the requirements request is to only allow the input of that text box to come from a scan gun and not from the keyboard. That way, the operator scans in the number and can't fudge someone else number.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, November 18, 2015 2:19 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: disable keyboard
Liz - See message 112768. Somehow it broke away from the thread.
-Bill
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :
Wait. That was my message. What method did you suggest? I don't see it other than looking to see what intellisense provides.
application.Screen.???
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, November 18, 2015 11:31 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: disable keyboard
Liz - So I take it you don't like they method I suggested?
-Bill
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :
Yep. I recently discovered that. I couldn't see how to do this and might have to think of a different way to go about this.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, November 18, 2015 9:53 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] RE: disable keyboard
Liz - That method is for Excel, not Access. Open the Immediate Window and type Application. As soon as you type the dot an IntelliSense list ops up. Note there is no ScreenUpdating available.
-Bill
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :
Just found something like this and am going to try it this afternoon.
Application.screenupdating = false
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, November 16, 2015 2:30 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] disable keyboard
Pros, I have a need for the users to input by a scanning gun and by disallowing keyboard entry to a field on a form.
Is there a way?
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 | Internal 814-4808
beaerospace.com
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: yahoo@craven.de
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (29) |
Tidak ada komentar:
Posting Komentar