RAC_Proj 43 - Site Audit Report Automation

To scrape through an access db and insert the records in to bookmarks within a word.doc. The formatting of the final [login to view URL] must replicate the example document (enclosed). ## Deliverables This should be a pretty much straight forward bookmark insertion with only a little bit of logic. Currently the tables used are: Sd_Main - Pages 1-3, Fire Risk assessment page 16 and Fire/emergency action pages 28 & 29. THSPAuditReferences - References section of the [login to view URL] pages 9-12 THSPSiteAudit - The H&S, Environmental and Fire 'checklist' sections. e.g. Findings & Recommendations pages 4-7, Action Plan pages 13&14, Fire pages 17-26 It covers three components: H&S Environmental Fire I'm currently struggling with the H&S and Environmental components as I need to be able to add records on the fly to the various topics and I'm not sure how to handle this. Do you have any suggestions. the fire component is a relatively straight forward checklist, however each [login to view URL] row can have more than one response to a row. I've attached a bookmarked word template, a DB template and an example completed report as a PDF. A test db will be available shortly. It'd be most helpful is a working template could be made available ASAP as I have about a week before I have to start using this report format. Please note: the automation form should provide the option to output either all topics or each of the topics individually. All highlighted text in the document is just to indicate the various areas e.g. Yellow = bookmarks, Blue = topic headers. The highlighting should not be included in the final output report.