Access 97 - Report Printers

[lilelvis2000]

Right. I've tried the code in a later version of Access and it's still coming up with the same result. Any ideas please?

The property returns a Windows structure...it is mentioned in the final link I believe. So what you need to do is create a structure identical to it in VBA and copy the printer info into it. Once there you can access the proper member which will be the printer name.

https://tron.megaspaz.net/stuff/MyWo.../devnames.html

http://www.eggheadcafe.com/forumarch...st26075847.asp

both links should help you out.

Also.....tada! in access 2002 (XP) there is a new Printer object. on the report there will be an attribute named "Printer". That object contains all the details you need.

Phew.....that'll be £150 please!

Good luck.

[MrNoMotivation]

The property returns a Windows structure...it is mentioned in the final link I believe. So what you need to do is create a structure identical to it in VBA and copy the printer info into it. Once there you can access the proper member which will be the printer name.

https://tron.megaspaz.net/stuff/MyWo.../devnames.html

http://www.eggheadcafe.com/forumarch...st26075847.asp

both links should help you out.

Also.....tada! in access 2002 (XP) there is a new Printer object. on the report there will be an attribute named "Printer". That object contains all the details you need.

Phew.....that'll be £1.50 please!

Good luck.

thanks for this. much appreciated. Your chequre for £1.50 is on it's way.