Using VBA in Excel 2002 , Access 2003 created a report tool .runs well.
until last week we update access2003 to 2007.(excel still 2002).
get error for grammar :" docmd.RunSQL "update .... " "
Error message show "The RunSQL action was canceled."
Reference:
1. Visual Basic for Application...