access to word, once again!

[wannabepro]

Okay, m sorry to bring this topic up again!

I have created this command button from tools that output the access report into word file. However, it prints all the record into word file, is there a way that it would print one record or selective record at a time. I mean, lets just say if I am on record 3 after I am done I press the button and I don't want it to output 1 to 3 record just the 3rd one. Is it possible to do it like that or not?

 

[RichO]

Assuming you're outputting a report as RTF, you would need to set up your report's query to look at the current record on your form, using a field that would be the unique identifier in your table.

For example, if your were looking at an "employees" form, for the EmployeeID field criteria in your report's query you would want to put [Forms]![NameOfForm]![EmployeeID].

This will cause the query to return only the current record on your form.

 

[wannabepro]

k the prob is I am kind of writting a letter in ms access and that would be output in word. However, this letter is commitment letter of loan so its kind of long like 13 pages in word but taking around 4 forms space on ms access now to output these 4 forms at the same time on the same record is kinda hard.

 

[RV]

Have you by any chance got a lot of repetitive data (standard wording that is put on every Commitment?

If so, you could set up a template in Word and merge your template with the non-repetitive data in Access.

RV

 

[wannabepro]

Have you by any chance got a lot of repetitive data (standard wording that is put on every Commitment?

If so, you could set up a template in Word and merge your template with the non-repetitive data in Access.

RV

Yes I do. But, how would I do that? Can u please help me out. Thanx

 

[ansentry]

Just to understand your problem could you please answer a couple of questions.

1) You have a form with many fields that you want inserted into a word document (using a template)?

2) Does the same field need to be inserted more that once into the document (Template)?

3) Do you just want to merge using the current access record?

4 ) Do you want to merge several access records at once?

 

[modest]

I have created this command button from tools that output the access report into word file. However, it prints all the record into word file, is there a way that it would print one record or selective record at a time.

How are you outputting?

You can choose a single page of the report by filtering the query the report is based on.

 

[wannabepro]

sorry for bringing up this topic again, but I was wondering. If someone can still assist me in this matter. I have typed the data in two seperate forms. Since, it was too much info and couldn't be accomodate in one form. Keep in mind these forms contain the loan info.

my questions are

1) can they be link together by the borrower name?

2) how can I send all the data to word document, w/o having a template. And if its really necessary to create a template, then can you assist me in creating one. thanx in adv.

3)I wrote almost the whole document using a text box, would it cause any problem, when converting to word.

4)Is it necessary to have a report or can i convert to word using forms?

looking fwd to some assistance.

Thanx

 

[ansentry]

I posted a reply to your question on 18th May,not only didn't you reply, you repost in the same thread asking for more help and you did not even acknowledge my existance.

I have created similar to your problem using word and access. One runs to 43 pages and the other 23.

So yes it can be done.

 

[wannabepro]

I posted a reply to your question on 18th May,not only didn't you reply, you repost in the same thread asking for more help and you did not even acknowledge my existance.

I have created similar to your problem using word and access. One runs to 43 pages and the other 23.

So yes it can be done.

oh I am sorry about that. if I can remb it correctly, I did reply to ur query, but after writing so much, my comp got stuck or something and the whole thing erased. neways really sorry for that.


1) You have a form with many fields that you want inserted into a word document (using a template)?

Yes, I have way too many fields. I don't have a template though, so its w/o the template, is it necessary to have a template?

2) Does the same field need to be inserted more that once into the document (Template)?

Yes, w/o template again.

3) Do you just want to merge using the current access record?

Yes, but I want all the records to use a query or something to inserted on a word document based on the borrower's name.

4 ) Do you want to merge several access records at once?
no, just one at a time.

I hope u r not mad at me now would really appreciate some help.

 

[ansentry]

You are forgiven.

Have a look at this sample:

Before you use it:

1> Copy the access sample database to your Desktop

2 > Copy the template AccessTest.dot to C:\Temp



From Access you select a customer (Using the customer look up) , details appear on the form, you then click a button and a word document will open and there is the data from the access form instered into word. You can then print save email etc.

This has been done using bookmarks, or in this example only 1 bookmark.

Have a look at the code behind the "Create Document" command button.

You can use as many different bookmarks as you have fields in access.

As you may be aware you cannot use the same bookmark twice in a word document, unless you want to write code that will reproduce them again and again.

I find that if I have to use the same "bookmark" twice in the document then I use {DocVariable}, which are more flexible.

Let me know re your progress.

 

[wannabepro]

thanx, but I think u didn't include AccessTest.dot file in the zip folder. I am missing that. thanks though

 

[ansentry]

Sorry about that posted the access db and not the folder.


Here it is.

 

[wannabepro]

this is awsome, let me try working with it. Thanx a lot eh. Its gr8 much appreciated.

But I have a question, on few lines I have to add money value date and customer's name in between the sentences or in a paragraph. Would it be possible to do that. If yes, then I will try this on my own first and then I will pm you if I don't find you online. So you could assist me more. I am sorry, I know I am being a burden. You don't have to reply, if you don't feel like it.

However, I really appreciate it, thank you so much

 

[ansentry]

As I said in my previous post:

You can use as many different bookmarks as you have fields in access.

As you may be aware you cannot use the same bookmark twice in a word document, unless you want to write code that will reproduce them again and again.

I find that if I have to use the same "bookmark" twice in the document then I use {DocVariable}, which are more flexible.

 

[wannabepro]

oh yeah, sheesh not only my eyes but my memory is also going bad.

thanx

 

[wannabepro]

okay done!

Instead of using the docvariable i used bookmark. But now my only query is, how can i format the currency bookmarks. I have them formated on the form, but its not exporting that formating. Is there a way to do that on the template, or somehow I can export the formating?

TIA

 

[ansentry]

Here is the answer to your problem.

 

[wannabepro]

Here is the answer to your problem.

You know what, you are the best. Thanks a lot. It worked just fine. much appreciated.

 

[wannabepro]

Okay, since I have bothered you this much, I am going to throw a last straw at you, its in regards of subform, I have datasheet subform on the main form. And this subform has a drop down menu, do you think it’s possible to copy the selected items and export it to word template?