SendKeys and Access2000 and Vista

[CeeVuu]

I have been successfully using sendkeys in macros with access 2000 and 2003 with xp. An error message comes up with access and vista, 'add in' missing. Can anyone suggest a work around for 'sendkeys' in a macro? Thankyou

[missinglinq]

You have inadvertently posted your question in the Articles section rather than the Forum section. I have moved it to the Forum for you.

Welcome to TheScripts!

Linq ;0)>

[missinglinq]

Vista is raising a great deal of havoc with all versions of Access! Perhaps if you give us an idea of exactly what you're trying to accomplish with your macro(s) we can suggest a workaround.

Linq ;0)>

[nico5038]

In general I advise not to use the SendKeys as they can be interrupted by the user.
When you indicate what has to be done we can propose how to achieve the same without this risky command.

Nic;o)

[CeeVuu]

Apologies for posting in the wrong area.
I use macros mostly.
An example of a sendkey function is to display the list of items in a combo box by way of 'dropdown' on enter.
Sendkeys equivelant is {%}+{down}.
Another sendkeys function is to shift + f9 , sendkeys {^}+{f9}, to refresh a field or form.
I appreciate your assistance as I am not a programmer.
On researching a solution for this problem I am keen to stop using sendkeys.
Thankyou

[missinglinq]

For the Refresh, in the appropriate event simply place this line of code

Me.Refresh

For the combobox dropdown, in Form Design View:

Right click on the combobox
Click on Properties
Click on Events
To the right of the OnEnter property box click
An Arrow and an ellipsis (...) will appear
Click on the ellipsis
Click on Code Builder

You'll be taken to the code window and need to use this simple code

Private Sub YourComboBoxName_Enter()
  YourComboBoxName.DropDown
End Sub

Let us know if you need more help!

Linq ;0)>