Sendkeys not working with Access 2003

[FredK]

I've been using Access 2000 and in the VBA code on some forms I've used the
Sendkey function. Now that I'm using Access 2003, the Sendkey function no
longer works. Anyone know what's up with that?

Thanks!

 

[Daniel]

can you provide your code so we can try and help find the issue.

Daniel

 

[FredK]

This is behind a Command Button on a form. It used to work fine until we
installed Access 2003.
Thanks for your help.


Private Sub Command87_Click()
DoCmd.OpenQuery "qry_select_beat_Team_for_copy", acNormal
DoCmd.Close acForm, "frm_select_team_maint", acSaveYes
DoCmd.Close acForm, "frm_date_shift_dialog", acSaveYes
DoCmd.SelectObject acQuery, "qry_select_Beat_team_for_copy"
DoCmd.RunCommand acCmdSelectAllRecords
DoCmd.RunCommand acCmdCopy
DoCmd.SelectObject acForm, "frm_roster_entry"
SendKeys "{tab}", False
SendKeys "{tab}", False
SendKeys "{tab}", False
SendKeys "^a", False
SendKeys "^v", False
SendKeys "{enter}", False
SendKeys "{home}", False
DoCmd.Close acQuery, "qry_select_beat_team_for_copy"
End Sub