Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-03-2019, 06:42 PM   #1
henryihunter1954
Newly Registered User
 
Join Date: Mar 2016
Posts: 89
Thanks: 6
Thanked 3 Times in 3 Posts
henryihunter1954 is on a distinguished road
Finding the best option to display a contract

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

henryihunter1954 is offline   Reply With Quote
Old 01-03-2019, 07:38 PM   #2
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,291
Thanks: 0
Thanked 535 Times in 531 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Finding the best option to display a contract

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.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Old 01-03-2019, 07:47 PM   #3
henryihunter1954
Newly Registered User
 
Join Date: Mar 2016
Posts: 89
Thanks: 6
Thanked 3 Times in 3 Posts
henryihunter1954 is on a distinguished road
Re: Finding the best option to display a contract

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.

henryihunter1954 is offline   Reply With Quote
Old 01-04-2019, 02:03 AM   #4
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,291
Thanks: 0
Thanked 535 Times in 531 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Finding the best option to display a contract

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.
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
Old 01-04-2019, 03:42 AM   #5
henryihunter1954
Newly Registered User
 
Join Date: Mar 2016
Posts: 89
Thanks: 6
Thanked 3 Times in 3 Posts
henryihunter1954 is on a distinguished road
Re: Finding the best option to display a contract

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 is offline   Reply With Quote
Old 01-04-2019, 03:49 AM   #6
henryihunter1954
Newly Registered User
 
Join Date: Mar 2016
Posts: 89
Thanks: 6
Thanked 3 Times in 3 Posts
henryihunter1954 is on a distinguished road
Re: Finding the best option to display a contract

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.
henryihunter1954 is offline   Reply With Quote
Old 01-04-2019, 05:40 AM   #7
mike60smart
Newly Registered User
 
mike60smart's Avatar
 
Join Date: Aug 2017
Location: Dunbar, Scotland
Posts: 430
Thanks: 21
Thanked 90 Times in 89 Posts
mike60smart will become famous soon enough
Re: Finding the best option to display a contract

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.

mike60smart is offline   Reply With Quote
Old 01-08-2019, 07:53 AM   #8
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,166
Thanks: 15
Thanked 1,577 Times in 1,499 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Finding the best option to display a contract

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.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Option to display/not display image in report AnTa Reports 2 09-27-2018 12:50 AM
How to display option group check box in subforms tahirsatti Forms 2 03-27-2012 05:11 AM
Display a message when the wrong Contract is input Stemdriller Queries 8 09-24-2008 07:39 AM
Option Group Display on other forms WinDancer Forms 5 05-03-2007 03:02 PM
Display Option Group - Check Boxes Navyguy Reports 2 09-04-2005 10:46 AM




All times are GMT -8. The time now is 12:13 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World