Format Options

[Guest]

Not sure if I should post this here or an excel forum
Someone I work with wants to track things with an excel spreadsheet instead
of using the teams Access database. I can export our data from Access to
excel for her. But she wants to color-shade all the new edits. I put a
date-stamp that shows the date that the record was last edited. But she
insists that she needs color shading on each individual field that has been
edited. whatever... I have to comply somehow. If I create a datestamp on
each individual field, is there a way to programmatically "invoke" the excel
conditional formatting option upon export?

 

[Larry Daugherty]

You can write the Excel code to do the color shading from Access or
you can simply stick a time stamp into the exported data and run a
macro from the Excel side. I'd go with option 1. In any case, look
into Automation in help and maybe on the support website.

Are you aware that you can do something similar on the Access side
using "conditional formatting"?

HTH

 

[Guest]

OK. I'll look up "automation" and see what I can find. I have already
designed a report in Access that highlights the appropriate field, but this
user won't even open the access database. She refuses to use anything but
her excel spreadsheets. some people just can't leggo the spreadsheets. LOL

adr

 

[G. Vaught]

There is always someone out there who loves to make someone elses job more
difficult. Unless this person is a boss, I'd tell her its in Access and its
going to stay in Access. If she wants the report, that is where she will
find it.