Hopefully someone could help me. I have a problem when I try to print a report in access.
VB Code:
  1. DoCmd.OpenReport "Shift_Totals", acViewNormal
Sometimes it works and others it doesn't saying runtime rror 2486 "you can't carry out this action at the present time'.

Is there any other way to print? I need this to work each and everytime... also, I need to check to see if it printed and no errors occured such as no paper in the printer...

I would like to add the min and max dates to be printed on this report... I have the code working that searches and displays them in a message box but now I want to have that info printed on the report.