[AccessD] Copy a record in a table

Stuart:

I'm using
        db.Execute "INSERT INTO tblJobMaster SELECT tblJobMaster.* FROM
tblJobMaster " _
     & "WHERE fldJobMasterID = " & rstJobMasterEquipmentIn!fldJobMasterID

But I get the cryptic 'Too few parameters.  Expected 1'.  Can you see what
I'm doing wrong?

Thanks.

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Tuesday, November 14, 2006 5:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Copy a record in a table

On 14 Nov 2006 at 17:11, Beach Access Software wrote:

> 
> Dear List:
> 
>  
> 
> Is there a quick or slick or elegant way to copy a record in a table to a
> new record in the same table - just duplicating a record  

INSERT INTO tblTable
SELECT tblTable.*
FROM tblTable
WHERE  fldID = IDofRecordToCopy



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.5/533 - Release Date: 11/13/2006
8:56 PM