Copying specific fields.

[mollow]

Hi,

I don't know if this can be done, but I'll ask here anyway

I have a printable form that the users of my DB use to enter specific job information (then print off and give to the shop floor). The problem is that on several occasions we have jobs that are almost identical and it would help the Account Managers if we could simply copy the entire form and paste it into a new record.

I know this is a simple process to do when you are dealing with tables (just highlight the entire row click copy, choose a new row and press paste) but our Managers are not so computer literate and I know they would struggle with such great feats.

So I was wondering if its possible to write a module to copy all the fields of a specific record and paste it into a new record?

Looking through Access 97's help the only reference I can see to copying is CopyObject, but I don't think that is relevant.

Any advice you could throw in my direction would be gratefully appriciated

Mike

 

[Spellman]

What about using the following query

Insert into tablename values (Select * from tablename where condition).

I haven't tested this so it might not work but you could give it a try. Mark

The key to immortality is to make a big impression in this life!!