A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Merging query fields into Word document



 
 
Thread Tools Display Modes
  #1  
Old May 25th, 2010, 05:39 PM posted to microsoft.public.access.queries
Used to Know Access
external usenet poster
 
Posts: 1
Default Merging query fields into Word document

I'm trying to fill out some forms with fields from a query. The forms are
built in MS Word. So far all I get is inserted lists into the form but the
fields are scattered throughout the form. While the basic form is generic, I
want to fill in certain information from the query (i.e., name, SSN, date of
birth, etc.) and these fields around scattered throughout the form. I was
certain I could do this but after 3 days of frustration I'm still batting
zero. Any help?
  #2  
Old May 25th, 2010, 05:56 PM posted to microsoft.public.access.queries
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default Merging query fields into Word document

Used to Know Access wrote:
I'm trying to fill out some forms with fields from a query. The forms are
built in MS Word. So far all I get is inserted lists into the form but the
fields are scattered throughout the form. While the basic form is generic, I
want to fill in certain information from the query (i.e., name, SSN, date of
birth, etc.) and these fields around scattered throughout the form. I was
certain I could do this but after 3 days of frustration I'm still batting
zero. Any help?


Are these bookmarks you're filling out? Then it's easy.

Say you have a form in Access showing the data you want... base your form on
the query.
Then you can put a button on your form that does something like

docWord.Bookmarks("FirstName") = me.Controls("txtFirstName")

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1

 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:36 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.