basic advice needed..

  • Thread starter Thread starter snowman via AccessMonster.com
  • Start date Start date
S

snowman via AccessMonster.com

hey guys

please bear with me - i have some basic q's about modules and procedures that
im sure would be best explained by someone on the forum

heres my situation: i need to include some VBA code to export info from an
Access form to a Word doc. Im reading up and learning about how to do this
(Access/Word automation) . my q's are about procedures and modules.

reading through posts it seems that i need to perhaps create a
procedure/module in which to reference to the Word lib? how can this be done?
im seeing examples of codes that call for 'DAO', or 'ActiveDocument' and im
really condused about this..

i need a helping hand with these procedures and modules - what do i need to
do/include before writing the code to export the info? my db consists of
tables, forms, subforms and queries - nothing too complicated. do macros come
into play?

thanks
 
Open any module in Access. Tools|References. Find the Word Object
library and check it.

That takes care of your reference to Word.

You still have to create the Word object, open Word, open a document,
etc. as shown in the examples for automation. Remember to close the
objects when you're done.

HTH
 
Back
Top