I use a call tracking program that allows us to customize it somewhat and add code to run here and there, etc. I am trying to run an Access macro (to open a form) using a shell command from within the call tracking program. The form works great when run in Access, so my last hurdle is successfully executing that macro with the shell command. Currently, this is the line I’m using: Shell (“C:\\Program Files\\Microsoft Office XP\\Office10\\MSACCESS.EXE F:\\WINAPPS\\CTEL73\\CTEL.MDB OpenCSCallRpt”)
However, I get the error “The command line you entered to start Microsoft Access contains an option that Microsoft Access doesn’t recognize. Exit and restart Microsoft Access using valid command-line options.” I’m hoping my error is in the syntax. I want it to either open my form or a macro which opens the form. OpenCSCallRpt is the name of the Macro.