ACCESS FEED: Re: [MS_AccessPros] Access To Word

Selasa, 04 November 2014

Re: [MS_AccessPros] Access To Word

Hi Abraham,

I have an example of writing to Word from Access here:

https://groups.yahoo.com/neo/groups/MS_Access_Professionals/files/Crystal//WriteToWord_MDB_DOT_TXT__Crystal.zip

Warm Regards,

Crystal

(: have an awesome day :)

On Tuesday, November 4, 2014 2:57 AM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:

Abraham-

If the "standard" document is 70 pages, it would probably be better to keep it outside the app. You can use Word automation to pull up the boilerplate, edit it, delete sections as necessary, then save as PDF with a name that relates to the particular bid. You can then import the PDF into the database in an Attachment data type field if you want to keep it all within the database.

As for Word automation - I have found with both Word and Excel that you can turn on the "macro recorder" and then perform the exact actions you want to automate from Access. Turn off the recorder when done, then copy the VBA created into Access and tweak it to word against a "Word.Application" object. A real Word expert could probably generate cleaner code, but it's a good way to do it when you're not a Word or Excel expert. 😃

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Nov 4, 2014, at 10:41 AM, abraham@owentechkenya.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello,

I have the following scenario.
I have an existing Access application that is used to manage procurement.
Each Procurement Project has a Financier.
Each Financier allows various Procurement methods, such as International Competitive Bidding or Request for Quotation etc.

As part of the procurement process, a rather large document (about 70 pages in Word, 20,000+ words) is generated and is given to bidders.
At the moment, a chunk of this document is maintained outside the system in Word.
We would like this document to be generated by the system.

The following rules apply:
1) Each Financier has a standard document used for each of their Procurement Methods.
The document has sections that may be added or removed depending on the procurement method used.
For example, one document may have Sections A, B, C and D while another document may have sections B, D and E.
2) Within each section, there may be data to be looked up by the application, from within the application, such as a Bid Opening Date or Bid Security percentage. Ideally, the users should not be able to change such data in the document. I have a search and replace function that can do this nicely.
3) The document needs to have some formatting - bold, italics, some numbering - the more it can look like the current Word document, the better.

Any pointers on how this can be achieved?
Any existing applications that can be integrated with the current application to manage this?
Any ideas to achieve a similar result in a simpler way?
Is it too much?

Thanks.

Abraham