Using MS Access to populate fields in other documents.

[Xproterg]

Hi,

I'm relatively new to VBA, and MS Access in general; however, I am very interested in learning absolutely everything I can about this application and its uses.

I have two questions in particular that I cannot find detailed information for. From a command button in ms access, how does one populate fields for a specific record in MS Word. Additionally, how does one populate fields in PDF files. MS word is more important to me at this time, because I can always convert the Word documents into pdf files later.

I am seriously contemplating undertaking an enormous project that will reduce (nearly eliminate actually) the paper usage for my entire company. I would love to get started on this, but I really need to-the-point reference material in order to make this a reality. Any help from you guys would be greatly appreciated. Thank you in advance for your assistance.

 

[CBrighton]

I have no knowledge of populating PDF documents however it's worth looking into the mail merge functionality of Word as this is basically designed to populate word documents based on a table of data.

It can be done programmatically via VBA or through the menus within Word.

 

[Xproterg]

I would rather use the VBA method, as I plan on generating a form based on a single record, not an entire set of records. Any links?

 

[CBrighton]

The first result from a Google search: http://www.tek-tips.com/faqs.cfm?fid=3237

When building the template in MS Word you will use the functionality it provides to designate fields for the mail merge. I'd find it in the tools menu, but it depends on your version of Office.