Live Report

[lucour]

Hi,

I have created a Contact database for my work site. I want to have the ability to print a hard copy of this report at any one time. Is it possible to have the report automatically updated when a record in the database changes (ie: deleted, modified), without having to go through the 'Output To' routine each time. I would like a report that I could have preformatted, and just have the data refreshed each time a record changes.\

Thanks !

 

[ghudson]

If you create an Access report with the formatting and fields to satisfy your needs; the data will be current based on the "record source" [SQL] of your report each time you open [print, export] the report.

 

[lucour]

Thanks GHUDSON ... I was aware of the Access Report. But what I was hoping for was to export to an Excel, or Word, document that would keep it's formatting (font, borders) in place each time, and just have the data being refreshed.

Thanks !

 

[ghudson]

Access is not friendly enough to do that. To keep the formatting you would have to export the report as an Access snapshot .snp or an Adobe .pdf file. You have to have the Snapshot add-in, it is free. The Adobe ouput requires you to have the full version of Adobe Acrobat. There are plenty of posts on either format if you need specifics for I do not use either.