Sendkeys not working with Access 2003

  • Thread starter Thread starter FredK
  • Start date Start date
F

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!
 
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
 
Back
Top