Standard Letter / Report

[Guest]

I have a standard disclaimer form letter that I ned to print out for each
record. Not sure how to do this.

Suggestions.

Ty

 

[Rick B]

Build it as a report and include any of the fields from the records that you
would like to put in the letter.

For example.

=Format(Date(),"long date") <--- unbound text field

[CompanyName] <--- bound field
[Address1] <--- bound field
=[City] & ", " & [State] & " " & [Zip] <---- unbound field




etc.

 

[Guest]

I used the wizard to create the report and now I need to paste the standard
disclaimer letter in here. I tried text box and label, but both will not let
me choose different font types sizes for certain sections of my letter.

In Crystal I can add multiple "sections" in my report - for example detail
a, detail b, etc. Can you do this in Access and if so how?

Thanks.

Ty

Build it as a report and include any of the fields from the records that you
would like to put in the letter.

For example.

=Format(Date(),"long date") <--- unbound text field

[CompanyName] <--- bound field
[Address1] <--- bound field
=[City] & ", " & [State] & " " & [Zip] <---- unbound field




etc.


--
Rick B

I have a standard disclaimer form letter that I ned to print out for each
record. Not sure how to do this.

Suggestions.

Ty

 

[Rick B]

Sure just make each report a separate control on the report.

You can't vary the formatting for various words within one control using the
standard Access controls though. In other words, you can't underline one
word in the middle of a paragraph.

I don't have it anymore, but I used to administer a databse where we had an
agreement in WORD and we used merge to put the specific data in the Word
document and then printed it. You might try that route. Basically use the
mail merge in Word with your database as the data source.

--
Rick B

I used the wizard to create the report and now I need to paste the standard
disclaimer letter in here. I tried text box and label, but both will not let
me choose different font types sizes for certain sections of my letter.

In Crystal I can add multiple "sections" in my report - for example detail
a, detail b, etc. Can you do this in Access and if so how?

Thanks.

Ty

Build it as a report and include any of the fields from the records that you
would like to put in the letter.

For example.

=Format(Date(),"long date") <--- unbound text field

[CompanyName] <--- bound field
[Address1] <--- bound field
=[City] & ", " & [State] & " " & [Zip] <---- unbound field




etc.


--
Rick B

I have a standard disclaimer form letter that I ned to print out for each
record. Not sure how to do this.

Suggestions.

Ty

 

[Rick B]

That first sentence should say to make each PARAGRAPH a separate control.

--
Rick B

Sure just make each report a separate control on the report.

You can't vary the formatting for various words within one control using the
standard Access controls though. In other words, you can't underline one
word in the middle of a paragraph.

I don't have it anymore, but I used to administer a databse where we had an
agreement in WORD and we used merge to put the specific data in the Word
document and then printed it. You might try that route. Basically use the
mail merge in Word with your database as the data source.

--
Rick B

I used the wizard to create the report and now I need to paste the standard
disclaimer letter in here. I tried text box and label, but both will

not

let
me choose different font types sizes for certain sections of my letter.

In Crystal I can add multiple "sections" in my report - for example detail
a, detail b, etc. Can you do this in Access and if so how?

Thanks.

Ty

that

you

would like to put in the letter.

For example.

=Format(Date(),"long date") <--- unbound text field

[CompanyName] <--- bound field
[Address1] <--- bound field
=[City] & ", " & [State] & " " & [Zip] <---- unbound field




etc.


--
Rick B



I have a standard disclaimer form letter that I ned to print out for each
record. Not sure how to do this.

Suggestions.

Ty

 

[Guest]

Thanks Rick, but unfortunately because I have a relational database I cannot
do a merge in word as I need to pull from two separate tables to do my merge.

How do I make each paragraph a separate control - sorry I have never done
this.

I know how to do this in Crystal, but not access.

Thanks.

Ty

That first sentence should say to make each PARAGRAPH a separate control.

--
Rick B

Sure just make each report a separate control on the report.

You can't vary the formatting for various words within one control using the
standard Access controls though. In other words, you can't underline one
word in the middle of a paragraph.

I don't have it anymore, but I used to administer a databse where we had an
agreement in WORD and we used merge to put the specific data in the Word
document and then printed it. You might try that route. Basically use the
mail merge in Word with your database as the data source.

--
Rick B

I used the wizard to create the report and now I need to paste the standard
disclaimer letter in here. I tried text box and label, but both will

not

let
me choose different font types sizes for certain sections of my letter.

In Crystal I can add multiple "sections" in my report - for example detail
a, detail b, etc. Can you do this in Access and if so how?

Thanks.

Ty



:

Build it as a report and include any of the fields from the records

that

you
would like to put in the letter.

For example.

=Format(Date(),"long date") <--- unbound text field

[CompanyName] <--- bound field
[Address1] <--- bound field
=[City] & ", " & [State] & " " & [Zip] <---- unbound field




etc.


--
Rick B



I have a standard disclaimer form letter that I ned to print out for each
record. Not sure how to do this.

Suggestions.

Ty

 

[Rick B]

You can pull from as many tables as you need to. Just put all the data you
need in a query and use the query as your source.


--
Rick B

Thanks Rick, but unfortunately because I have a relational database I cannot
do a merge in word as I need to pull from two separate tables to do my merge.

How do I make each paragraph a separate control - sorry I have never done
this.

I know how to do this in Crystal, but not access.

Thanks.

Ty

That first sentence should say to make each PARAGRAPH a separate control.

--
Rick B

Sure just make each report a separate control on the report.

You can't vary the formatting for various words within one control

using
the

standard Access controls though. In other words, you can't underline one
word in the middle of a paragraph.

I don't have it anymore, but I used to administer a databse where we

had
an

agreement in WORD and we used merge to put the specific data in the Word
document and then printed it. You might try that route. Basically

use
the

mail merge in Word with your database as the data source.

--
Rick B



I used the wizard to create the report and now I need to paste the
standard
disclaimer letter in here. I tried text box and label, but both

will
not

let
me choose different font types sizes for certain sections of my letter.

In Crystal I can add multiple "sections" in my report - for example detail
a, detail b, etc. Can you do this in Access and if so how?

Thanks.

Ty



:

Build it as a report and include any of the fields from the

records
that

you
would like to put in the letter.

For example.

=Format(Date(),"long date") <--- unbound text field

[CompanyName] <--- bound field
[Address1] <--- bound field
=[City] & ", " & [State] & " " & [Zip] <---- unbound field




etc.


--
Rick B



I have a standard disclaimer form letter that I ned to print out for
each
record. Not sure how to do this.

Suggestions.

Ty

 

[Guest]

Excellent idea - I just tried this and the problem now is it is creating a
new letter for each inventory item. I have a database with a customer "ABC
Inc." who has 14 items in inventory - I need to list ABC Inc. at the top with
their address - which I have done successfully, however, their 14 items of
inventory are showing up 1 item at a time on each letter. I need all 14
items to be listed together in the one letter to ABC Inc.

Suggestions?

Thanks !!!

Ty

You can pull from as many tables as you need to. Just put all the data you
need in a query and use the query as your source.


--
Rick B

Thanks Rick, but unfortunately because I have a relational database I cannot
do a merge in word as I need to pull from two separate tables to do my merge.

How do I make each paragraph a separate control - sorry I have never done
this.

I know how to do this in Crystal, but not access.

Thanks.

Ty

That first sentence should say to make each PARAGRAPH a separate control.

--
Rick B



"Rick B" <Anonymous> wrote in message
Sure just make each report a separate control on the report.

You can't vary the formatting for various words within one control using
the
standard Access controls though. In other words, you can't underline one
word in the middle of a paragraph.

I don't have it anymore, but I used to administer a databse where we had
an
agreement in WORD and we used merge to put the specific data in the Word
document and then printed it. You might try that route. Basically use
the
mail merge in Word with your database as the data source.

--
Rick B



I used the wizard to create the report and now I need to paste the
standard
disclaimer letter in here. I tried text box and label, but both will
not
let
me choose different font types sizes for certain sections of my letter.

In Crystal I can add multiple "sections" in my report - for example
detail
a, detail b, etc. Can you do this in Access and if so how?

Thanks.

Ty



:

Build it as a report and include any of the fields from the records
that
you
would like to put in the letter.

For example.

=Format(Date(),"long date") <--- unbound text field

[CompanyName] <--- bound field
[Address1] <--- bound field
=[City] & ", " & [State] & " " & [Zip] <---- unbound field




etc.


--
Rick B



I have a standard disclaimer form letter that I ned to print out for
each
record. Not sure how to do this.

Suggestions.

Ty