>>I have a report that doesn't seem to differ from any of my other reports, but when it's run as an .frx I can select any printer on my network, but within an .exe, the report will only work if I modify the print setting in the .frx to the specific printer that I want. Otherwise it gives me an 'Error accessing printer spooler'. Any ideas?
>>
>
>Try to remove printer related info from the report.
>- Open the report as a table with "USE MyReport.frx"
>- Go to the first record
>- Delete the contents of the TAG and TAG2 fields.
>REPLACE Tag WITH "", Tag2 WITH ""
>- Remove following driver related lines from EXPR field
>DRIVER=
>DEVICE=
>OUTPUT=
I beat my head against the wall quite a bit on this one when I had one user that could not print. Once the problem was pointed out to me, I had 126 report forms to modify so decided to check to see if someone had already come up with a way to run this on an entire directory. And it's there!
Go to the download section and look for ID 9586. It's a simple screen form that will allow you to make a single report generic, or all the reports in the sub directory. It works GREAT!
____________________________________________
Norm Peterson
It's a dog eat dog world out there,
and I'm wear'n milk bone underware!