Access record exporting into word documents

[harleyskater]

I was wondering if there is an awesome way out there somewhere to take a record and export it into a word document, like a template and have the fields go where you want them to?

 

[GaryPanic]

check out the super easy word option in the samples

and see if you can find my notes on it

-

 

[Dennisk]

the standard way is mail merge. Create an Extract file in Access and Mailmerge in Word. There is a mailmerge wizard in word to help you.

Or

You can link an access table in word

Or

You can create a Word Document object in access and use that.

 

[harleyskater]

do you have an example you can send me? of a linked table in word and a word document object in access???
I would love to see how this works with what I have been doing : )

the standard way is mail merge. Create an Extract file in Access and Mailmerge in Word. There is a mailmerge wizard in word to help you.

Or

You can link an access table in word

Or

You can create a Word Document object in access and use that.

 

[GaryPanic]

the "super easy" version is very easy
essentially its the fields on a form and then you open up a template letter and insert the fields into the letter this becomes a .dot file
then you merge it and it becomes a .doc file

you have have as many .dot files as you like - easy to maintain
full word fuction

 

[harleyskater]

I am just looking for some examples. you have one? if so please post and I will try it out ; ) thank you!

the "super easy" version is very easy
essentially its the fields on a form and then you open up a template letter and insert the fields into the letter this becomes a .dot file
then you merge it and it becomes a .doc file

you have have as many .dot files as you like - easy to maintain
full word fuction

 

[harleyskater]

ok i found your old post i might have some questions : ) chao!

the "super easy" version is very easy
essentially its the fields on a form and then you open up a template letter and insert the fields into the letter this becomes a .dot file
then you merge it and it becomes a .doc file

you have have as many .dot files as you like - easy to maintain
full word fuction

 

[GaryPanic]

in essense
what you need to do on this is collect your data (to go into your word dot.doc) this needs to be appended into a table
so you need to set up a table with these fields in it - then use append to populate the fileds (with the use of open form and use the open form button to use append ) and then follow the instructions - put all of the fields on the form (vsible or not as long as they are there) then open a dot following the notes - works a charm - then on close have the delet qry empty the table

make sure the table is on the front end not the back end - so never link this table

 

[harleyskater]

I was thinking of applying this to a record set.
like a single job with a lot of operations

i just look at the attachment from the other .mdb on the page, its nothing but miles of vba code. I am guessing the easy way is not so easy : )

 

[GaryPanic]

no - easy

download the d/b - and import 2 modules - ignore the coding its all predone

took me 1/2 hour to do it all - no coding

 

[GaryPanic]

Super Easy Word Merge.

Finally, some code to stop the crazy solutions to merging a single record in ms-access to a word document. Like everyone else, I asked why does this have to be so hard?

I also have a very high dislike of bookmarks, since end users can not possibly be expected to work with them when trying to create a template. My above approach is so slick, that your END USERS in most cases can figure this out WITH NO training.

In addition, this code is late binding, so it works even if your version of ms-word is different then that of ms-access.

How to use:
Simply merge the 2 forms and 2 modules of code into your application. Then place a button on you ms-access form with the following ONE LINE code.

MergeSingleWord

That is it!! You are done!. Now, just hit the "add new template" button to create a word template". Now insert your merge fields, and SAVE the document. Next, just try hitting the word merge button again. This is way cool, and easy. I will write up some better instructions, but I have included a sample form for you to try.

Note that if you do import the code into your a2000 application, then you MUST set the
"Microsoft DAO 3.6 Object Library" in the references window.

Access97 : click here for access 97 merge code

Access2000: click here for access 2000 merge code


Update: Feb 14, 2004. I have modified the above merge example to work with office 2003. I your version is before Feb 14, 2004, then you want to re-load the above software


For some screen shots and some more notes on using this merge code please click here Merge notes.

 

[harleyskater]

Yes I see : ) I looked at all of that, but It doesn't seem like it will support 1 - many recordssets
Like if i wanted to have a word doc that is something like Job Items
Top of the page would be like job # 1000
and the middle part of the page would be like
items
1
2
3
4
5
6

I am beginning to hate and love this problem hahah

Super Easy Word Merge.

Finally, some code to stop the crazy solutions to merging a single record in ms-access to a word document. Like everyone else, I asked why does this have to be so hard?

I also have a very high dislike of bookmarks, since end users can not possibly be expected to work with them when trying to create a template. My above approach is so slick, that your END USERS in most cases can figure this out WITH NO training.

In addition, this code is late binding, so it works even if your version of ms-word is different then that of ms-access.

How to use:
Simply merge the 2 forms and 2 modules of code into your application. Then place a button on you ms-access form with the following ONE LINE code.

MergeSingleWord

That is it!! You are done!. Now, just hit the "add new template" button to create a word template". Now insert your merge fields, and SAVE the document. Next, just try hitting the word merge button again. This is way cool, and easy. I will write up some better instructions, but I have included a sample form for you to try.

Note that if you do import the code into your a2000 application, then you MUST set the
"Microsoft DAO 3.6 Object Library" in the references window.

Access97 : click here for access 97 merge code

Access2000: click here for access 2000 merge code


Update: Feb 14, 2004. I have modified the above merge example to work with office 2003. I your version is before Feb 14, 2004, then you want to re-load the above software


For some screen shots and some more notes on using this merge code please click here Merge notes.

 

[GaryPanic]

I don't think the super easy word will work on your requirements
Oh well

good luck

regards

 

[harleyskater]

thanks for the help gary : ) there might be a solution out there. it doesn't seem difficult.. all the print fuctions in access 2007 are limited and exporting to other files. Its just exporting a field and importing a field into something else.. should be easy : /
I guess you can't always get whhhat you waaannntt haha

I don't think the super easy word will work on your requirements
Oh well

good luck

regards