Printing problem with accesss and VBA

[Mcritt]

Hopefully someone could help me. I have a problem when I try to print a report in access.

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.

[Hack]

Have you been able to determine under what circumstances it works and under what circumstances it doesn't?

[Mcritt]

To this time I havn't been able to. It seems if I comment that line out the rest of the code runs error free, so it seems to be just that line. The really strange part is that it works ad then it doesn't but seems totally random.

[Hack]

What about other reports? Do they print fine? Is it just this one?

[Mcritt]

This is the only report that I am printing and the only one I have. Is there a different way to print?

[Mcritt]

anyone else ever have this problem or knows how to solve it?