Help needed desperately

  • Thread starter Thread starter Jeff Hughes
  • Start date Start date
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.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.
 
Thanks Allen, printer query now sorted but haven't got round to trying
solution for problem 2. Thanks for the help

cheers
 
Back
Top