Gustav Brock
Gustav at cactus.dk
Fri Apr 21 10:30:29 CDT 2006
Hi Paul Of course, so simple, no ADO needed. It must be Friday here as well ... time for some coffee. /gustav >>> paul.hartland at fsmail.net 21-04-2006 17:15:06 >>> Thanks yet again gustav but I used this method instead, can't believe I couldn't remember this (having a Friday moment today I think): DoCmd.CopyObject , "schednew" & "_" & Format(Now(), "DDMMYYYY") & "_" & Format(Time(), "HHMMSS"), acTable, "schednew" Makes a copy with a new name. Thanks again. Paul Hartland