[mhammond]

Hi Guys

I'm really really stuck on something at work, I've set up a customer database and forms to input data etc which all works nice but the boss wants a button to send a single record either to the clipboard or straight to word so that when a customer phones in the detials are entered in to the database then the cursor is placed in a certain place on a word document and pasted in. I know its a rubbish system but thats how he wants it for now.

I've spent most of today playing around with code on the net that uses ADO and SQL to no avail, is there an easier way of doing it? Or even better has anyone done it before and got some samples? ps I have using forms in word.

Basically is there an ADO - paste record to clipboard command?

I've attatched the database (minus records for data protection), I would really appreciate any help I'm begining to look like a right div in the third week of my new job!