Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
denilynn denilynn is offline
external usenet poster
 
Posts: 12
Default Merge Access form/subform fields into Word 2007 document?

Is it possible to merge Access 2007 form and subform fields into a Word 2007
document?
--
Thanks in advance for your time!
denilynn
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merge Access form/subform fields into Word 2007 document?

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.

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

"denilynn" wrote in message
...
Is it possible to merge Access 2007 form and subform fields into a Word
2007
document?
--
Thanks in advance for your time!
denilynn


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merge Access form/subform fields into Word 2007 document?

You may find Albert Kallal's macros at

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

do something useful in this area.

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

"Peter Jamieson" wrote in message
...
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.

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

"denilynn" wrote in message
...
Is it possible to merge Access 2007 form and subform fields into a Word
2007
document?
--
Thanks in advance for your time!
denilynn



  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
denilynn denilynn is offline
external usenet poster
 
Posts: 12
Default Merge Access form/subform fields into Word 2007 document?

I have the data that was input into the forms in a datasheet/subdatasheet. Is
this where I need to begin?
--
Thanks in advance for your time!
denilynn


"Peter Jamieson" wrote:

You may find Albert Kallal's macros at

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

do something useful in this area.

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

"Peter Jamieson" wrote in message
...
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.

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

"denilynn" wrote in message
...
Is it possible to merge Access 2007 form and subform fields into a Word
2007
document?
--
Thanks in advance for your time!
denilynn




  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merge Access form/subform fields into Word 2007 document?

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.

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

"denilynn" wrote in message
...
I have the data that was input into the forms in a datasheet/subdatasheet.
Is
this where I need to begin?
--
Thanks in advance for your time!
denilynn


"Peter Jamieson" wrote:

You may find Albert Kallal's macros at

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

do something useful in this area.

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

"Peter Jamieson" wrote in message
...
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.

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

"denilynn" wrote in message
...
Is it possible to merge Access 2007 form and subform fields into a
Word
2007
document?
--
Thanks in advance for your time!
denilynn






  #6   Report Post  
Norbert.Limbersky Norbert.Limbersky is offline
Junior Member
 
Location: Prague, The Czech Republic
Posts: 1
Default

Well, there is a way how to export data from both form and subform to Word.

It is a 2 step process:

1)
Export data of form with subform all at once to Excel.
You will need to use 'A2EE.mda' Access add-in for this part.
This is an add-in that can export data from form with subform, all at once to Excel, while keeping the original Access-like drill-down structure.
You will download the add-in and find more details about it on:
www.limbersti.cz/A2EE/

2)
Once you get parent-child (form-subform) structured output into the Excel, you can now export it from Excel into any other file formats, including Word.

You can also find an example of such Access to Word export on the above mentioned link.


BR
Norbert
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge document with form fields Dottie Microsoft Word Help 1 May 26th 06 04:20 AM
Text form fields and merge document Scott Schaffer New Users 2 May 8th 06 04:02 PM
Add related subform to mail merge document Carolyn M Mailmerge 2 March 19th 06 01:29 PM
Access form fields to Word Form Doug_C Mailmerge 1 April 6th 05 06:59 PM
Mailmerge - Catalog - Access Database with subform [email protected] Mailmerge 1 January 6th 05 04:30 AM


All times are GMT +1. The time now is 08:54 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"