Re: Mail merge between Access and Word - using VB-6

Hi Bruce.

Sorry, I forgot to mention that I am using Office XP Pro
components - 
Word 2002 and Access 2002 - not office 97.  Does that change
anything?

Richard

--- In helpwithvb@yahoogroups.com, "Neiger, Bruce
D" 
<Bruce.D.Neiger...> wrote:
>
> One obvious way is to use VBA from within Word to
obtain a 
particular value from the Jet database (create a recordset
object 
containing only the needed data).
>  
> Another is to use VB6 to do the same thing.
>  
> The techniques are the same as given in the textbook,
using DAO 
objects (which, as I have maintained for years, is still a
perfectly 
fine way to access Jet [Access] databases).
>  
> -=BDN=-
>  
> ________________________________
> 
> From: helpwithvb@yahoogroups.com on behalf of Richard
> Subject: [helpwithvb] Mail merge between Access and
Word - using VB-
6
>  
> Hi. I was working on the project out of Professor
Smiley's VB-6 
textbooks, and it seemed to me that he abandoned the
improvements 
made 
> in the Objects textbook when he enhanced it with the
Database. Is 
there any way to pass a value from a database to MS Word
using VB-6 
so 
> I don't have to completely start over from version one?
How would I 
go about doing that?
> 
> Thanks!
> Richard
>




 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://grou
ps.yahoo.com/group/helpwithvb/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://
groups.yahoo.com/group/helpwithvb/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:helpwithvb-digest@yahoogroups.com 
    mailto:helpwithvb-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    helpwithvb-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.c
om/info/terms/
 

lol -- that only makes things easier, once you make sure
things are up to date and consistent (MDAC installed, the
right version of DAO library, etc ) -- the Version of VBA in
post Office 97 is LOT more mature than those prior...
 
The concepts are the same though.  Say you have a database
with some data in it that you need.
You want to retrieve the values during (A VB6) program
execution. 
You can create a DAO database, and recordset objects,
following the examples in the database book, get the data,
and use it.
 
You could also write the same (kind of) code in Word's VBA,
right in the document.  
-=BDN=-
________________________________

From: helpwithvb@yahoogroups.com on behalf of Richard
Sent: Mon 2/19/2007 4:59 PM
To: helpwithvb@yahoogroups.com
Subject: [helpwithvb] Re: Mail merge between Access and Word
- using VB-6



Hi Bruce.

Sorry, I forgot to mention that I am using Office XP Pro
components - 
Word 2002 and Access 2002 - not office 97. Does that change
anything?

Richard

--- In helpwithvb@yahoogroups.com
<mailto:helpwithvb%40yahoogroups.com> , "Neiger,
Bruce D" 
<Bruce.D.Neiger...> wrote:
>
> One obvious way is to use VBA from within Word to
obtain a 
particular value from the Jet database (create a recordset
object 
containing only the needed data).
> 
> Another is to use VB6 to do the same thing.
> 
> The techniques are the same as given in the textbook,
using DAO 
objects (which, as I have maintained for years, is still a
perfectly 
fine way to access Jet [Access] databases).
> 
> -=BDN=-
> 
> ________________________________
> 
> From: helpwithvb@yahoogroups.com
<mailto:helpwithvb%40yahoogroups.com>  on behalf of
Richard
> Subject: [helpwithvb] Mail merge between Access and
Word - using VB-
6
> 
> Hi. I was working on the project out of Professor
Smiley's VB-6 
textbooks, and it seemed to me that he abandoned the
improvements 
made 
> in the Objects textbook when he enhanced it with the
Database. Is 
there any way to pass a value from a database to MS Word
using VB-6 
so 
> I don't have to completely start over from version one?
How would I 
go about doing that?
> 
> Thanks!
> Richard
>



 


 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://grou
ps.yahoo.com/group/helpwithvb/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://
groups.yahoo.com/group/helpwithvb/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:helpwithvb-digest@yahoogroups.com 
    mailto:helpwithvb-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    helpwithvb-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.c
om/info/terms/