Linking an Access report to Word .doc file for E-Signature

  • Thread starter Thread starter JimN
  • Start date Start date
J

JimN

It is my understanding that Microsoft Access Reports
cannot directly accept a legally binding E-signature link.
We have several MS Access reports that require e-
signatures. The signature pad and software that has been
selected can link an e-signature to a MS Word .doc format.
It would help, with the frequency the reports are
generated, to be able to output a report to a MS Word .doc
file, using VB coding, without manually going to the Tools
Menu, Office Links, etc.

Thank you,

Jim N
 
Hi Jim,

You could do it with VBA code that does the following:

1) use DoCmd.OutputTo to export the report to a temporary rtf file

2) get hold of the current instance of Word, if it's running, or else
launch a new instance.

3) have Word open the rtf file and save it as a Word document ready for
the signature software.

The links below should get you started.

However, exporting to rtf format means that you may lose some of the
layout of your report. In your place I'd investigate exporting the
reports to PDF format (I assume that your software can sign PDFs)
instead.

Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

http://www.mvps.org/word/FAQs/index.htm

http://www.mvps.org/access/modules/mdl0043.htm
Opening a new Word document based on a template through Automation
 
Hey John,

Thanks, looks like I have something to do over the weekend
and during spring break.

You have a good one,

Jim N


-----Original Message-----
Hi Jim,

You could do it with VBA code that does the following:

1) use DoCmd.OutputTo to export the report to a temporary rtf file

2) get hold of the current instance of Word, if it's running, or else
launch a new instance.

3) have Word open the rtf file and save it as a Word document ready for
the signature software.

The links below should get you started.

However, exporting to rtf format means that you may lose some of the
layout of your report. In your place I'd investigate exporting the
reports to PDF format (I assume that your software can sign PDFs)
instead.

Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

http://www.mvps.org/word/FAQs/index.htm

http://www.mvps.org/access/modules/mdl0043.htm
Opening a new Word document based on a template through Automation
It is my understanding that Microsoft Access Reports
cannot directly accept a legally binding E-signature link.
We have several MS Access reports that require e-
signatures. The signature pad and software that has been
selected can link an e-signature to a MS Word .doc format.
It would help, with the frequency the reports are
generated, to be able to output a report to a MS Word .doc
file, using VB coding, without manually going to the Tools
Menu, Office Links, etc.

Thank you,

Jim N
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Back
Top