PC Review


Reply
Thread Tools Rate Thread

basic advice needed..

 
 
snowman via AccessMonster.com
Guest
Posts: n/a
 
      30th Apr 2006
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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...dules/200604/1
 
Reply With Quote
 
 
 
 
Larry Daugherty
Guest
Posts: n/a
 
      30th Apr 2006
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
--
-Larry-
--

"snowman via AccessMonster.com" <u21023@uwe> wrote in message
news:5f8cb62d7981d@uwe...
> 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
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200604/1



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
basic new build advice Mr. G DIY PC 4 26th Mar 2008 04:01 AM
please I need help with basic ado.net save, basic syntax needed =?Utf-8?B?TmV3YmVlIEFkYW0=?= Microsoft Dot NET 5 28th Jun 2005 07:09 AM
Re: Basic advice Ken Snell Microsoft Access VBA Modules 4 1st Sep 2003 08:17 PM
Re: Basic advice Marshall Barton Microsoft Access VBA Modules 0 1st Sep 2003 12:16 AM
Advice needed & tutorials on ports and basic security to protect a network Sean Microsoft Windows 2000 1 16th Aug 2003 12:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:12 AM.