Missing acReport part of coding

[jeffreylewis]

Hi Guys. I have just changed computers from a Dell prescision T7500 running windows 10
To Dell Optiplex 7050 small form also running windows 10
It is lightning fast and runs all my legacy programs without problems.

However on the Dell Optiplex 7050 I also I have Ms Access 2007 db which runs perfectly
except for my email output form frmBuyerInvoiceWrite

These seems to a line of which should create report called rptTransactionInvoiceIncVAT.pdf but not send it.

DoCmd.OutputTo acReport, "rptTransactionInvoiceIncVAT", acFormatPDF, "D:\DATA\HARVESTER\DATABASE\REPORTS\rptTransactionInvoiceIncVAT.pdf", False

And although it works on my Dell prescision T7500 running windows 10
It does not work on my new computer Dell Optiplex 7050 small form also running windows 10

The reason seems to be that acReport part of the coding is not available
Can anyone help
Thanks in advance
JEFF

 

[theDBguy]

Hi Jeff. I believe for Acc2007, the PDF driver had to be installed manually. It used to be a download from MS. I'm not sure if it's still available now. If I find a link, I'll repost.

 

[jeffreylewis]

Thanks DBguy

 

[theDBguy]

Thanks DBguy

Unfortunately, I couldn't find it on MS website, but I did find some links for external sites. I don't feel comfortable passing them to you, in case any of them might be risky. Good luck!

 

[jeffreylewis]

Unfortunately, I couldn't find it on MS website, but I did find some links for external sites. I don't feel comfortable passing them to you, in case any of them might be risky. Good luck!

Thanks Do it anyway I will make up my own mind

 

[DHookom]

Hi Guys. I have just changed computers from a Dell prescision T7500 running windows 10
To Dell Optiplex 7050 small form also running windows 10
It is lightning fast and runs all my legacy programs without problems.

However on the Dell Optiplex 7050 I also I have Ms Access 2007 db which runs perfectly
except for my email output form frmBuyerInvoiceWrite

These seems to a line of which should create report called rptTransactionInvoiceIncVAT.pdf but not send it.

DoCmd.OutputTo acReport, "rptTransactionInvoiceIncVAT", acFormatPDF, "D:\DATA\HARVESTER\DATABASE\REPORTS\rptTransactionInvoiceIncVAT.pdf", False

And although it works on my Dell prescision T7500 running windows 10
It does not work on my new computer Dell Optiplex 7050 small form also running windows 10

The reason seems to be that acReport part of the coding is not available
Can anyone help
Thanks in advance
JEFF

What do you get if you open the debug/immediate window and enter:
? acReport

 

[Gasman]

I know my memory is rubbish, but I do not remember having to download anything for 2007 to be able to print to pdf?