Labens ConvertToPDF code 1

[LonnieJohnson]

Does anynone know if it works with Access 2007. I copied the code from a machine that has Access 2003 and it works. When I copy it to 2007 and put the dlls in the system32 folder it fails when trying to read the StrStorage.dll.

Do they have to be registered?

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[MajP]

I have not used this code, but why would you need code to do this in 2007? Doesn't 2007 provide this capability, natively?

 

[LonnieJohnson]

Actually the second machine is a remote user/client that I just started working with. I do not have it on my machine personally.

So you are saying that the output format for emailing an access report with the DoCmd.SendObject function.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[MajP]

Works for me
DoCmd.SendObject acSendReport, "rptName", acFormatPDF, "Recipient

 

[LonnieJohnson]

Wow. I had no clue. Small changes like that are enormous.

Thanks. I have wasted massive time for nothing.

Have a STAR on me.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[MajP]

http://allenbrowne.com/Access2007.html

good read