[denilynn]

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

[Peter Jamieson]

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

[Peter Jamieson]

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

[denilynn]

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

[Peter Jamieson]

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

[Norbert.Limbersky]

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