R
Ronk
I am working on creating the following database system. Any help/suggestions would be appriciated
I am creating a Home Inspection Database System. As I am just learning access (scripting) I welcome any comments and suggestions from the pros here. I need to track customers, the properties that I inspect, the type of inspection and findings for each property (ie General Home Inspection, Termite Inspection, Water Test, etc).
Database that I would use consist of: 1. CustomerContacts 2. TypeofInspection 3. PropertiesInspected 4. InspectionsFindings. Plus a database for canned findings for each item inspection (about 100)
When I do an inspection I report on a number of items (ie Roof, Electric, Plumbing, etc) with subcatagories under each of these (ie Roof Section would have - Condtion of Roof Surface, Gutters, Attic, and Flashings). Each of these sub catagories could have multiple comments (ie Nails loose on shingles, shinges are cracked, roof should be replaced soon).
So here is what I have in mind for the reporting system: I set up a combo box that I select the Section that I want to report on (Roof Section etc.). Once I make my selection, another combo box opens with subcatagories for the choosen Section (Roof: Condition of Roof Surface ...). On that selection a multi-select list-box opens and I select the comments that I want (often more than one). At this point I don't know how to store these multi-selected comments. Can I store them in a single record?
Then comes reporting. I know little about Access's reporting ability. What I want to do is print or create a PDF of the report with the items that I reported on. I want to be able to include photos and diagrams as well. What I had in mind was setting up a mail merge of the records into word, then adding photos and diagrams, then final formating and finish. I like word because of its ease of formating and adding phoots. Is there a way to have real time mail merge (ie as I finish a subcatagory it updates the word doc real time and I can view it while during the inspection
Thanks
Ron
I am creating a Home Inspection Database System. As I am just learning access (scripting) I welcome any comments and suggestions from the pros here. I need to track customers, the properties that I inspect, the type of inspection and findings for each property (ie General Home Inspection, Termite Inspection, Water Test, etc).
Database that I would use consist of: 1. CustomerContacts 2. TypeofInspection 3. PropertiesInspected 4. InspectionsFindings. Plus a database for canned findings for each item inspection (about 100)
When I do an inspection I report on a number of items (ie Roof, Electric, Plumbing, etc) with subcatagories under each of these (ie Roof Section would have - Condtion of Roof Surface, Gutters, Attic, and Flashings). Each of these sub catagories could have multiple comments (ie Nails loose on shingles, shinges are cracked, roof should be replaced soon).
So here is what I have in mind for the reporting system: I set up a combo box that I select the Section that I want to report on (Roof Section etc.). Once I make my selection, another combo box opens with subcatagories for the choosen Section (Roof: Condition of Roof Surface ...). On that selection a multi-select list-box opens and I select the comments that I want (often more than one). At this point I don't know how to store these multi-selected comments. Can I store them in a single record?
Then comes reporting. I know little about Access's reporting ability. What I want to do is print or create a PDF of the report with the items that I reported on. I want to be able to include photos and diagrams as well. What I had in mind was setting up a mail merge of the records into word, then adding photos and diagrams, then final formating and finish. I like word because of its ease of formating and adding phoots. Is there a way to have real time mail merge (ie as I finish a subcatagory it updates the word doc real time and I can view it while during the inspection
Thanks
Ron