Solved

Numlock key & Access macros

Posted on 2000-04-13
9
496 Views
Last Modified: 2012-05-05
I have a macro tied to a field that sends few keystrokes to the form using the sendkeys Access command.

But as soon as the macro fires, it turns off my numlock key. Even sending a numlock at the end of the macro doesn't turn it back on. Help !

Is there a command or some VB code I can use to turn it back on ?
0
Comment
Question by:munna
  • 3
  • 2
  • 2
  • +1
9 Comments
 

Author Comment

by:munna
ID: 2712895
NC
0
 
LVL 9

Expert Comment

by:BrianWren
ID: 2712965
This is a known bug with Access, which is documented at MS's web site.

To work around this, find another way to accomplish your goal.  (This can almost always be done.)

Can I help?

Brian
0
 

Expert Comment

by:GOLLEM
ID: 2712980
munna->

What exactly are you sending? Maybe you're using the wrong combination of letters. This is a really weird problem......

Have you checked yet if the same problem occurs on a different machine? The problem could also be in your access installation.

I'm listening in anyway, this is interresting :)

Regards,

         Michiel

0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 9

Expert Comment

by:BrianWren
ID: 2713074
Michiel, it is a known bug....
0
 
LVL 9

Expert Comment

by:BrianWren
ID: 2713107
The more I think on it, the more I seem to remember that using DoEvents after SendKeys is supposed to help...  (This might help only in VBA.  You might need to put your SendKeys into a function that you call instead, which has DoEvents after each Sendkeys instruction.

Brian
0
 
LVL 7

Expert Comment

by:Believer
ID: 2713301
[In the tone of voice of Beavis & Butthead...]  "Sendkeys suck, heh. heh. heh..." "Yeah, heh, so do macros, heh.  heh."  
Sorry, I'm feeling a bit... opinionated!!!
0
 

Author Comment

by:munna
ID: 2713762
I am basically sending few TABs to jump to a subform and then CTRL+SHIFT+TAB to jump back to the mainform. I am doing this so that the user will not exit the data entry screen without creating atleast one record on the subform. If you can tell me what command I can use to do that with code, it will be great.
I am not at all an experienced programmer (as you can tell).



0
 
LVL 7

Accepted Solution

by:
Believer earned 100 total points
ID: 2713820
You could pursue the Macro command GoToControl.  If you write code beind the form instead of a macro, look into the .SetFocus property of controls instead.
0
 

Expert Comment

by:GOLLEM
ID: 2713998
Brian->

Hadn't noticed that bug yet :)

0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question