Finding the best option to display a contract

[henryihunter1954]

Thanks again for the great help.
My project has really moved along much smoother and quicker since I've gotten help from the contacts in ACCESS WORLD.

TO my issue now:

I have a database that stores information for orders.
My Order Form is performing great, (now).

The data that is collected gives the user:
1. The Business Info
2. The Client Info
3. The Purchased Item Info and Details

The Form has a subform that gives the details.

The lady that will be using the database will need to print out a "CONTRACT", using this information.
I tried the Report method to print out the information.
(Does not look very professional when I try this method)

I thought about using Word to import the fields needed to create the contract. I was thinking of using mail-merge to match the fields.
(I am wondering if anyone is laughing now?)

I need suggestions as to what would make a better looking Contract, along with providing the correct information that the database will provide.
I don't want the the lady to do too much to accomplish this because she is not a tech person, if you know what I mean.

So, suggestions are needed from your professional experiences.

Thank you all again for great suggestions.
I am amazed at the help that I've gotten.
Again, Thanks

 

[June7]

Why does report 'not look very professional'? I use Access reports and in my view, they look very professional. True, text formatting is limited but good enough for my needs.

Word/Access document merging is valid option but can be challenging.

 

[henryihunter1954]

June7:

I had problems trying to get all the information to show up in the report.
That was the first problem.

The information in the subform was not showing up, to be more specific.

I may not be running the report correctly.

But I taught myself how to do SubReport. Lots of modifying to get that correct too.

Once the information showed up, the report did not have the wording that was needed to place on the contract.

June7, thank you for responding to my question. I had not done any database work in more than 20 years. Getting back into this is really like learning all of this all over again.

 

[June7]

And where should that wording come from? Data in records or static text on report in labels or textboxes? Can even concatenate literal text with fields.

 

[henryihunter1954]

Thank you June7 for responding.

The text info is coming from the static text that will be displayed on the contract.
I can place this on the form or the report that will be generated when the person
enters the information needed to process the contract.
Good question.

Thank you.

 

[henryihunter1954]

June7:

It is definitely not the program's inability to generate a professional looking report.
It is my lack of knowledge of how to do so. I've generated reports years ago and they were great for what the individuals wanted and/or needed. But I did not have to use a subform or subreport to help generate the information. This is where I lack the knowledge of placing these on the current project that I'm working on.

Thanks again. I will study more on how to do so. I just feel that suggestions from Access World will give me better insight on how it should be done.

 

[mike60smart]

Hi Henry

You would normally have a Report with all relevant paragraphs.
Then specific Information from the Form displaying the Current Record would be embedded within the Report as necessary.

 

[Pat Hartman]

If you are using the .accdb format, you might be able to use a Rich Text control to get better formatting for embedded text. We don't have enough information to determine how to solve your problem because we can't "see" it. Try posting a picture of the report page and tell us what you don't like about it.