Assignment 10-1: Create a PHR Summary Report Command Button
Written Tutorial
1. Copy file and paste as save as new version. Open this version
2. Open Personal Health Record Form.
3. Go to Design View and expand the footer because we are going to put the Command Button in the Footer.
4. Click Design Tab and click on the Button Tab. Make your button box at the bottom of the page.
5. The Wizard will then open. We want to open a Report so click Report Operations, Open Report, next.
6. Select the report you want to open, PHR Summary Report, click next.
7. We will select Text that says Open PHR Summary Report, click next.
8. Don’t change the Command name/number or your database won’t pull up the right command. Just add “Open PHR Summary-“ before the listed command. Click Finish.
9. Go to Form View and you should see the button and it should open your summary reports.
10. The next module will allow you to pull up only the particular report you want.
Assignment 10-2: Create a PHR Summary Report Macro
Written Tutorial
1. Copy file and paste as save as new version. Open this version
2. We are going to create a unique command so that only the specific patient’s information will show up.
3. Click Create, Macro, and a Wizard opens. We want to Open Report, open PHR Summary Report.
4. We have to set a Condition so that the Personal ID’s match. Click the botton on the Where Condition line.
5. The command will be built in the top box. On the left box click the plus side and Click the plus button by Reports, click All Reports and click on PHR Summary Report.
6. Now in the middle box you can find and click twice on the Personal ID field. The SQL commands will appear in the top box.
7. Delete everything in the top box except “[Personal ID]”. Then add an = sign after that.
8. Go back to the Left box and select Form, Loaded Forms, Personal Health Record and select Personal ID in middle box by clicking twice. The command should now say, “[Personal ID]=Forms![Personal Health Record]![Personal ID]”. Click OK.
9. Close the Macro and save as Open PHR Summary Report 1.
10. Go to the Personal Health Record Design Review. Select Summary button. Go to Properties.
11. Select Event, On Click. Click on pull down box and Select Open PHR Summary Report 1. Click on that and close.
12. Switch to Form view and the only information that shows up should be for the specific patient.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|