Surely this would use whatever printer had been selected previously - what I want to do is get it to select a specific printer, for example I want to print a report that comes out on a HP printer in the back office and another report on a Brother printer in the front office so I need to specify the printer name in the DoCmd - but how ?
Thanks, I had seen an article on PrtDevNames and intended to follow it through as it seems to be exactly what I need, but it will need a bit of time for me to get my head round it and test it out as it is quite advanced stuff for me. But I am grateful for your help and pointing me to the relevant articles. If however there is anyone out there who knows the exact code I need it would save me some time.
It seems to me that if you open up your report in design view and select page setup, and then the Page tab, there is an area where you can select a specific printer to always send the report to. I have used this to automatically have a customers shipping request report sent to the shipping office located in the warehouse.
[This message has been edited by Carol (edited 06-17-2001).]
This solution is perfect if you only want to send the report to the same output device every time but sometimes I need to send the report to a different device, so what I would like to do is put two command buttons on the report that you could select to send the report to different printers.
Maybe not a very neat solution but on the form that calls the report could you have 2 command buttons, with each one opening a different version of the report?
The different report versions then have the appropriate printers saved as the defaults.
Label the command buttons with the appropriate printer name - 'should' be pretty user-friendly!
The problem is the form IS the report and stores the information directly into a table rather than output through a report process, I will look at it but it may store both versions in the table which will be no good, thanks for your input.I may be asking for something that cannot be achieved, I have looked at macros etc but no physical solution seems to exist.