Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / December 2007

Tip: Looking for answers? Try searching our database.

Merge Access form/subform fields into Word 2007 document?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
denilynn - 12 Dec 2007 01:17 GMT
Is it possible to merge Access 2007 form and subform fields into a Word 2007
document?
Signature

Thanks in advance for your time!
denilynn

Peter Jamieson - 12 Dec 2007 10:24 GMT
Word really works with the underlying data rather than the data sitting on a
particular form (although an Access SQL query can reference "Form" fields,
not just "database" fields, if you issue such a query from Word you have to
be connected to Access using DDE and I don't think you can rely on the
results.

Your best best is probably to put a button on your form that saves the data,
or references to the data in a format that Word can use - for example, you
might export the referenced record(s) to a delimited text file, or save
it/them in a special table in the database, or save the record number in a
special table, etc.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Is it possible to merge Access 2007 form and subform fields into a Word
> 2007
> document?
Peter Jamieson - 12 Dec 2007 10:44 GMT
You may find Albert Kallal's macros at

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

do something useful in this area.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Word really works with the underlying data rather than the data sitting on
> a particular form (although an Access SQL query can reference "Form"
[quoted text clipped - 11 lines]
>> 2007
>> document?
denilynn - 14 Dec 2007 18:18 GMT
I have the data that was input into the forms in a datasheet/subdatasheet. Is
this where I need to begin?
Signature

Thanks in advance for your time!
denilynn

> You may find Albert Kallal's macros at
>
[quoted text clipped - 17 lines]
> >> 2007
> >> document?
Peter Jamieson - 14 Dec 2007 18:45 GMT
Albert's macro either
a. gets the field names and values that are actually displayed on the form
and export them to a delimited text file. That's if you click the "merge one
record" button, or
b. executes a SQL query that you supply and exports the results to a text
file, if you click "All".

As I understand it, an Access subform will typically be populated  with data
that is related to the main form using query syntax that references the
form. e.g. in Albert's sample, there's a query with the text

SELECT Contacts.*
FROM Contacts
WHERE (((Contacts.City)=[forms]![contacts]![city]));

which clearly references a specific form and field on that form.

I think you should be looking to get you data using a similar query, but you
really need to run this type of query within Access while the Form is open,
not from outside Access.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I have the data that was input into the forms in a datasheet/subdatasheet.
>Is
[quoted text clipped - 23 lines]
>> >> 2007
>> >> document?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.