Hello,
I am using the output to function to output a report to a directory. This is working fine except for 2 things.
The report when opened in access has formatting where if the field is a certain value it will highlight in a certain colour.
When I view the html format that is created it has none of this format and is in plain mono. I was wondering if there is a way of taking the format across with the output.
Also when I do run the macro it asks me if I want to override the existing file. Is there a way of automatically saying yes as I want this macro to run automatically without this prompt.
Any assistance would be appreciated.
I am using the output to function to output a report to a directory. This is working fine except for 2 things.
The report when opened in access has formatting where if the field is a certain value it will highlight in a certain colour.
When I view the html format that is created it has none of this format and is in plain mono. I was wondering if there is a way of taking the format across with the output.
Also when I do run the macro it asks me if I want to override the existing file. Is there a way of automatically saying yes as I want this macro to run automatically without this prompt.
Any assistance would be appreciated.
