print spreadsheet

  • Thread starter kennytwk via AccessMonster.com
  • Start date
K

kennytwk via AccessMonster.com

hi there, i have just created a form embedded with microsoft office
spreadsheet 11.0, i need to print the spreadsheet, i try using print form
button from wizard and change the name to the spreadsheet name,

stDocName = "Spreadsheet0"
Set MyForm = Screen.ActiveForm
DoCmd.SelectObject acForm, stDocName, True
DoCmd.PrintOut
DoCmd.SelectObject acForm, MyForm.Name, False

but an mesaage prompt telling me "Microsoft Office Access can't find the form
"Spreadsheet0" you referenced in the Object Name Argument, it is possible to
print it, the Microsoft office spreadsheet 11.0 is found in "Toolbar" under
"More Controls", thanks
 
Top