[AccessD] Inserting into an exported doc title

Paul Rodgers Paul.Rogers at SummitMedia.co.uk
Wed Dec 22 10:32:05 CST 2004


Perfect for the job. That's a really handy tip, too. Many thanks, Steve
cheers paul

-----Original Message-----
From: Steve Conklin (Developer at UltraDNT) [mailto:Developer at UltraDNT.com]
Sent: 22 December 2004 16:24
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Inserting into an exported doc title


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

-- 
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