Help needed desperately

J

Jeff Hughes

Can anyone help? I have several problems/queries:

1. I have a report that generates a pie chart, when I print it out, it
prints to my default mono printer, but I need it to go to a colour laser
printer is there a way of doing this via a function??

2. I need a function that will look at a field and depending on the contents
replace it with something else. eg every record that has a field with beef
in it changes it to cow and every entry thst says pork changes it to pig.

I am desperate for any helpl.

Thanks
 
A

Allen Browne

A.1: Change printer
Preview the report. Choose Print from the File menu. Choose your printer.

If you wish to do this in code, recent versions of Access have a Printers
collection, and you can set the Printer object. For older versions, it is
more messy. See:
Reports: Change printers from code
at:
http://www.mvps.org/access/reports/rpt0009.htm

A.2: Replace
You can use the Replace() function to replace one value. From your example,
though, it looks like you need a lookup table containing two columns: the
word, and the translation. Include this table in your source query, and you
can get the translation onto the report easily.
 
J

Jeff Hughes

Thanks Allen, printer query now sorted but haven't got round to trying
solution for problem 2. Thanks for the help

cheers
 
Top