Access fields Word printing

[Khalil]

Hello,
Hope this is possible!!

I have a word template with fill in fields to print certificate using:
person's name, place of birth, date of birth....
Can I have a button on an Access form (using macro or VBA code) to:
1- Start Word program with specified template.
2- Use some of the fields of the current record and fil them in the Word
document.

This method to me is easy than creating report in Access.

Khalil

P.S. I can close Word application manualy after it finish prinitng.

 

[Guest]

I don't know quite what the solution may be, but I can just about promise you
it will be far more complex than making an Access report. What difficulty do
you encounter in trying to make a report?

 

[Guest]

I did not realize justified text was part of the problem. You may wnat to
try a Google groups search. That's where I found the attached quote. There
is probably something about importing into Word.
You may want to check the following, which was previously posted in this
forum. It is by Stephen Lebans, who is among the finest resources for Access
information, and who has provided free of charge many workarounds for things
they should have thought of but didn't when designing Access. Lebans quoted
text follows.

***************
A2K or higher supports a Distribute property for TextBox controls. There
is a bug/feature of the Distribute property whereby the last line of the
paragraph is fully justified even if it contains a single word.
Unfortunately there is no fix for this issue.

There are several other options on my site:

1) For Reports only:
http://www.lebans.com/justidirect.htm
JustiDirect.zip is a database containing Functions to produce fully
justified text within standard TextBox controls on your Reports.
Allows a standard Access TextBox, bound to a Memo field to not only
produce fully justified text, but use the CanGrow/CanShrink properties
as well.

2) The Justify ActiveX control for Forms or Reports here:
http://www.lebans.com/xjustifytext.htm
Produce Fully Justified Text. Bind this control to your Memo field to
create professional looking reports! This is an ActiveX control that can
act as a Label or TextBox. This control has a RecordSource just like a
normal Access TextBox so it can be bound to a field or contain a
calculated expression. Developed for Microsoft Access97.
Requires VB6 Runtime files.

3) The RTF ActiveX control for Forms or Reports here:
http://www.lebans.com/richtext.htm
RTF2 control is an ActiveX RTF solution written in VC++. The RTF2
control is a complete editing/printing solution for Access 97 or higher.
Autosizing of the RTF2 control is supported for A2K or higher.

 

[Khalil]

Hi,
I'am using text boxes for the text in each line. This doesn't look
"Justified" like in Word.

Khalil

 

[Albert D.Kallal]

Try downloading and running my word merge sample.

It allows you to merge the ONE record you are looking at in a form with the
click of a button.

You can find it here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

 

[Khalil]

Thanks a lot. you are a great help.
Khalil