[AccessD] Inserting into an exported doc title

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




More information about the AccessD mailing list