PC Review


Reply
Thread Tools Rate Thread

Access change Word form field value

 
 
Jake F
Guest
Posts: n/a
 
      31st Aug 2009
I'm creating a form in Word to send to different clients and then pull back
into access when they fill it out. I need to fill the information regarding
their name, address,etc before I send it to them. Is it possible to do that
from access vba saying wordform!textbox1.value = "A", similar to what I would
do on a form in access? Thanks.
 
Reply With Quote
 
 
 
 
Piet Linden
Guest
Posts: n/a
 
      1st Sep 2009
On Aug 31, 10:27*am, Jake F <Ja...@discussions.microsoft.com> wrote:
> I'm creating a form in Word to send to different clients and then pull back
> into access when they fill it out. *I need to fill the information regarding
> their name, address,etc before I send it to them. *Is it possible to dothat
> from access vba saying wordform!textbox1.value = "A", similar to what Iwould
> do on a form in access? *Thanks.


If you create a bookmark in your Word document, then you can just dump
the value in

wrdDoc.Bookmarks("BookmarkName")=Forms!MyForm!MyControl

or you could use a recordset if you have to do a lot of these.
 
Reply With Quote
 
Jake F
Guest
Posts: n/a
 
      2nd Sep 2009
Great, thanks!

"Piet Linden" wrote:

> On Aug 31, 10:27 am, Jake F <Ja...@discussions.microsoft.com> wrote:
> > I'm creating a form in Word to send to different clients and then pull back
> > into access when they fill it out. I need to fill the information regarding
> > their name, address,etc before I send it to them. Is it possible to do that
> > from access vba saying wordform!textbox1.value = "A", similar to what I would
> > do on a form in access? Thanks.

>
> If you create a bookmark in your Word document, then you can just dump
> the value in
>
> wrdDoc.Bookmarks("BookmarkName")=Forms!MyForm!MyControl
>
> or you could use a recordset if you have to do a lot of these.
>

 
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
How do I change the size of a text form field box in Word? Blink Microsoft Word Document Management 1 29th Nov 2009 01:10 PM
Form Text Field Won't Change Font Size-Word 2007 DP Microsoft Word Document Management 3 3rd Mar 2009 01:06 AM
Word form fixed length text field that doesn't change formatting? =?Utf-8?B?Q29saW4=?= Microsoft Word Document Management 3 25th Jan 2006 07:35 PM
Word 2003 forms (checkbox form field) change default x to tick?? =?Utf-8?B?VG9ueQ==?= Microsoft Word Document Management 1 13th Jul 2005 09:19 PM
Export Access form field info. to Word form fields? =?Utf-8?B?RG91Z19D?= Microsoft Access Forms 0 5th Apr 2005 11:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:11 PM.