H
hughess7
Hi all
My company use Word to compile a long and detailed report from results of an
audit they use a MS Access database to perform. I want to automate this
process so they simply press a button in Access and the report is produced
with all the data completed, this will include calc's etc in tables and
charts too eventually.
I have found ALbert Kallal's very useful mail merge instructions and some
others from Ken Sheridan - thanks guys for these, I will try to replicate
something similar for my system!!
I have a query in Access currently which contains the single record for the
data source. I will code the document to save automatically as 'Audit -
[Dealer Name]' where Dealer Name comes from the db. We want the end user to
be able to print the report only and not modify in any way (by
changing/adding any of the wording or results etc). So if they change any
data for the audit they will have to do it in the Access system and run the
report again (replacing the original report).
Is this possible to do via the same Access code after the report is produced?
Thanks in advance for any help.
Sue
My company use Word to compile a long and detailed report from results of an
audit they use a MS Access database to perform. I want to automate this
process so they simply press a button in Access and the report is produced
with all the data completed, this will include calc's etc in tables and
charts too eventually.
I have found ALbert Kallal's very useful mail merge instructions and some
others from Ken Sheridan - thanks guys for these, I will try to replicate
something similar for my system!!
I have a query in Access currently which contains the single record for the
data source. I will code the document to save automatically as 'Audit -
[Dealer Name]' where Dealer Name comes from the db. We want the end user to
be able to print the report only and not modify in any way (by
changing/adding any of the wording or results etc). So if they change any
data for the audit they will have to do it in the Access system and run the
report again (replacing the original report).
Is this possible to do via the same Access code after the report is produced?
Thanks in advance for any help.
Sue