Steve Conklin (Developer@UltraDNT)
Developer at UltraDNT.com
Wed Dec 22 10:24:07 CST 2004
I do this by taking out the punctuation from Now(), replacing it with underscores, so I get something like: 12_22_2004-10_00_00_am And appending that to the end of the file name. As long as its not done more than once per second, its ok. hth Steve -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Rodgers Sent: Wednesday, December 22, 2004 10:19 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Inserting into an exported doc title I export the fields of an Access form to Word and save it in a stated path. Can I add something unique to the name of the document so that Access will allow an unlimited number of this document to be saved, please Experts? appWord.ActiveDocument.SaveAs "t:\WorksAllocation\FridayReports\FR.doc" The only unique field among the fields is the date. Cheers paul -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com