473,388 Members | 1,574 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

Function Key is not being trapped!

Access 2013, Key Preview = Yes, No AutoKeys, attached code below.

Private Sub LastName_KeyDown(KeyCode As Integer, Shift As Integer)
'Allows use of Function Keys on the form
On Error GoTo Error_Handler
Select Case KeyCode

Case vbKeyF5
'Sets you up to search for a person by LAST NAME
MsgBox ("F5")
DoCmd.OpenForm "Find_Customer_Last_Start_Form", acNormal, , , , acWindowNormal
'Right, Down, Width, Height
DoCmd.MoveSize 6300, 6200, 5800, 3650
DoCmd.GoToControl "txtBxFind_Last_Name"
KeyCode = 0
End Select
Exit Sub

Error_Handler:
MsgBox "Error"
End Sub

Question is this: pressing the F5 key still gives me the Open database form for access. It has to be something i am doing wrong of course. Any suggestions. Greatly appreciated.
Thanks

Secondary Note: I set the option below with NO CHECK and still the same thing.

File -> Option -> Current DB -> Use Access special Keys (Uncheck)
Jul 18 '17 #1
1 1320
This reply is from Odie1952. Answering my own question. Sorry this took so long to figure out why my Function keys would not work in this access database. But here is the short of it. "BAD KEYBOARD" - yes that is correct. I searched web all over and couldn't find the answer to why the (F) keys would not work. Even went so far as to isolate the problem into a simple database and did some testing with an outside program .... yep there it was, intermittent keybindings from a Microsoft 2000 ergonomic keyboard. So, I unplugged the keyboard and plugged in a $10 keyboard and waaaaa laaaaaa.... worked fine. Sorry. This only proves 1 thing, never ever give up .. there is got to be a reason it doesn't work.
Jul 22 '17 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: mitsura | last post by:
Hi, I have included a small listing. The test program opens a panel and show a bitmap. What I want is to when the mouse is over the bitmap panel, I want to trap the left mouse click. The...
13
by: TC | last post by:
Folks Is there >>ANY<< way to get the actual text of an error that is trapped by the Form_Error event? I mean actual text like: "duplicate record in table XYZ", not template text like:...
1
by: Travis Stewart | last post by:
Hi, I've been working on some software to control an older GPIB card for the past couple of weeks. I have function prototypes in a header file pc-mate2.h and the functions are defined in...
6
by: guy | last post by:
We got it... :-) from my post to VS.NET 2005 VB.NET ng... Subject: function return values From: "John@data.vb" <anonymous@discussions.microsoft.com> Sent: 7/2/2004 12:56:27 PM
2
by: Darrell Wesley | last post by:
When I place a Tab control on a form with one or more TabPages and click inside one of the pages and then click on a tab the mouse cursor gets trapped inside the tab control until I click on...
2
by: martintillbrook | last post by:
I am using the simple mail() fucntion in a php script but the emails that are being generated and being trapped by Microsoft Exchange server 2003 Inteligent message filter as having an SCL rating...
8
by: bob | last post by:
Which is faster - a call to a system function or a call to a library function?
2
by: jesmi | last post by:
when i put while loop, it never stops, it just trap in loop.but when i remove while loop, it will increment one by one, the month,year,week,day. but i need to put this code in while loop. please help...
7
by: primeSo | last post by:
I did C in UNIX environment. These are some of the common mistakes that always trapped me in my work. I need help from you guys to clarify them with me. 1) int intArray = {1,2,3,4,5}, i; ...
9
by: pereges | last post by:
Hello I need some ideas for designing a recursive function for my ray tracing program. The idea behind ray tracing is to follow the electromagnetic rays from the source, as they hit the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.