Darren DICK
d.dick at uws.edu.au
Thu Dec 16 20:54:24 CST 2004
Sorry Dan Iwant to rename a file - outside of the db Not a db Object Many thanks DD -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, 17 December 2004 1:22 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] A2003: rename a file via vba Darren, Look up 'Rename' in help. This is the example they give: DoCmd.Rename "Old Employees Table", acTable, "Employees" HTH, Dan Waters ProMation Systems -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK Sent: Thursday, December 16, 2004 7:40 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] A2003: rename a file via vba Hello all Any suggestion on renaming a file via code PSEUDO CODE EXAMPLE Some thing like Call Rename "C:\mydB.mdb", "C:\mydb" & "_" & Format(Date,"dd/mm/yyyy") & ".mdb" Many thanks Darren -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com