THANK YOU!

I'll look at it and see if I can do the same in VFP...


>Here is some help from the VBA guys. See if you can get this to work in VFP. http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=101
>
>>Thanks Paul, but we are already doing this. Instead of having more than one printer to choose from (they typically have 3 or 4 already), we would like to enable the bin selection from inside VFP. We already have a table that stores the printer selection for all of our reports, the number of copies to print, etc and we would like to add a field to store the paper tray (bin) the report should print to also. That would of course, require the ability to select the paper tray on the printer from within VFP and then we would have to set it back...I'm still hoping there is a Windows API function to do this...
>>
>>
>>>If you are using Win9x, all you need to do is setup the same printer twice and set the default tray differently for each one, then switch the printer from within VFP. Unfortunately, Win2K won't let you set up the same printer twice, as easily as 9x. It takes some registry hacking. I started to get it working, but never finished it...priorities got rearranged. If you go this route, I may be able to dig up some of the keys I was playing with to get you started.
>>>
>>>>Is it possible to use win32 api or another function to specify which printer tray or bin to print a report to other than by opening the report as a table and changing DEFAULTSOURCE=nnn in the EXPR field of the first record? I would like to do it programmatically without even popping up a box or window to the user before printing. I would like to determine how many bins a printer has and allow the user to enter which bin to use in a table that has other print settings in our app (1 record exists for each form we print) and then set the bin # of the printer to that value before printing and set it back afterwards with no user intervention other than the user initially entering a value in that table to always be used in the future for that form. This is how we do all other printer settings for each form and it works well, but I do not know how to determine the number of bins a printer has and how to set which bin to use programmatically.
>>>>
>>>>I would like to do this for .frx reports as well as for older @...say reports that still are in use in our VFP7/8 app also and since there is no .frx that is printing changing that value is not an option.
>>>>
>>>>TIA!