Solved

Numlock key & Access macros

Posted on 2000-04-13
9
465 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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
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

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

747 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

10 Experts available now in Live!

Get 1:1 Help Now