Hello folks !

[Old Bill]

I am trying to solve what *seems* a simple problem and my Access skills
(such as they were !) are very rusty; I'd be grateful for any help or
pointers to web resources.

Slimmed down, imagine a database that has the following record type :-

First Name
Last Name
Invoice details (date, amounts, usual stuff !)

Each record is written to a MS Word file in an invoice type layout, which
has the filename SM 05 Aug 06.doc (SM followed by today's date DD MMM YY).
There may be up to 20 or 30 invoices appended to the file in a session
(day).

Is there any way to add a field in the record, perhaps as a hyperlink or
command button, that when clicked on, will take you to that persons Last
Name (like a keyword search) in the open Word file?

TIA,

 

[Wayne-I-M]

Hi Bill - old or not

Could I make a suggestion. Why not simply create a report - it can look
like your word doc and use this to send out your invoices. You could very
simply save the date whioch the each reprt was printed and then call up all
report that were allocated to a specific person or a certain date, etc.

This is just what acccess was created for.

Good luck