ACCESS FEED: [MS_AccessPros] Re: disable keyboard

Rabu, 25 November 2015

[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@beaerospace.com> 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@beaerospace.com [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@beaerospace.com> 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@beaerospace.com> 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@beaerospace.com> 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.