 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / June 2006access reports with company letterhead
ACCESS 2003 I have an inspection DB with 50 addresses in it, the forms consists of a regulation then a yes\no check box. it has 5 different headings on 6 forms I want to: Generate a report for the specific address just inspected. I want the report to be on Company letterhead with the our typical intro paragraph. if a yes/no box is checked I want it to show the information and the corrective action. I assume the correctine actions must be somewhere in a table? how can i do this? thank you for your help > ACCESS 2003 > I have an inspection DB with 50 addresses in it, the forms consists of a > regulation then a yes\no check box. it has 5 different headings on 6 forms > I want to: > Generate a report for the specific address just inspected. > I want the report to be on Company letterhead with the our typical intro > paragraph. > if a yes/no box is checked I want it to show the information and the > corrective action. I assume the correctine actions must be somewhere in a > table? > how can i do this? thank you for your help Yes, you'll need a separate table with its own unique identifier for the records (aka "key") for the Corrective Action. I am assuming you already have a Table that contains the Regulations, and a separate Table with the Addresses. If this assumption is incorrect, please clarify. As to company letterhead, you can either have a specific printer preloaded with letterhead paper and design your reports to begin below the letterhead area, or you can scan in the letterhead and include it in one of several types of Control in the Report header or page header of your Report. Yes, the corrective action information would need to be stored in a Table, and there would have to be some sort of "linkage" between the regulation and the corrective action. That is a "foreign key" field containing the unique identifier of the field in the other table. Most likely, in this case the Corrective Action should contain a field with the key of the associated Regulation. But if more than one Regulation can be associated with each Corrective Action, you may need a "junction table" with keys of both the Regulation and the Corrective Action tables -- that is a way to represent what's called a "many-to-many" relationship. Larry Linson Microsoft Access MVP Yes I have tables for addresses and regulations, I will make one for the corrective actions. Thank you for your help, you have pointed me in the right direction > > ACCESS 2003 > > I have an inspection DB with 50 addresses in it, the forms consists of a [quoted text clipped - 32 lines] > Larry Linson > Microsoft Access MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.