Solved

Numlock key & Access macros

Posted on 2000-04-13
9
473 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
 
LVL 9

Expert Comment

by:BrianWren
ID: 2713074
Michiel, it is a known bug....
0
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.

 
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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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…

910 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now