Partager via

Using OMPM to assess macros? Check out this fix to repair links in the Macro Summary tab

  • Article

Update: This issue has been fixed as of August 2011 in Update 1 of OMPM. See our recent blog post for more information.

 

Today's post is brought to you by Curtis Sawin, a Senior Consultant with Microsoft Consulting Services.

Recently, we discovered a small bug in the Office Migration Planning Manager (OMPM) reporting tool (OMPM.accdr) when working with the Macro Summary tab of the reports. This article describes the issue, the steps taken to correct it, and provides an updated OMPM.accdr file that contains the updates as a workaround. The OMPM.accdr file is provided as-is and offers no support or warranty.

Macro Summary Tab

The OMPM reporting tool provides a tabbed layout to report on the data captured by the OMPM file scans. Each tab provides shows the first 1,000 records returned for a given report. Also, there are links at the bottom of each tab that allows you to see all records returned and to view the data in a report. Selecting New Window opens a new window that returns all records. Selecting Report View opens a built-in report that displays the data in a report format. Below is a screen shot this functionality:

On the Macro Summary tab, these links do not work. Specifically, when clicking on the New Window link, nothing happens. Clicking on the Report View link opens a report...for Scanned Files! A few simple modifications to this were all that were needed.

First, we modified the New Window text to add an "OnClick" event to rerun the query that returns the macro summary data for all records, not just the first 1000 records.

Next, we saw that the "Hyperlink SubAddress" property of the Report View text was running the report for Scanned Files. After changing this to run the Macro Summary report, we found that such a report does not exist.  So we made one! We copied an existing report (to keep the same report design) and updated the fields to return the same data that the Macro Summary tab provides. 

Below is a screen shot of this report (with some customer data blurred).

 

How to Install

To use the updated reporting tool, download the zip file below and extract the file, "ompm.accdr" into the Report folder where the OMPM toolset was extracted.  Below is a screen shot for details.

 

Summary

Making such changes was not too difficult, and now we have the ability to view more information about macros from files that were imported into the OMPM database.  The updated file is provided below.

ompm.zip

Comments

  • Anonymous
    January 01, 2003
    VP, I'm not clear from your post whether you downloaded the new file and are still having problems seeing all records. Did you install the download that is included with this blog post? This new file will allow you to see more than the first 1000 records.

  • Anonymous
    December 07, 2010
    I have problem with numbers of rows. In database are 6000 PC, and ompm.accdr shows only 1000...help me please.

  • Anonymous
    January 12, 2011
    Hi, Is there a reason you don't allow editing the Access file? I can't make any changes to it. Do you only recommend writing custom reports from scratch? It would be helpful to be able to copy a report and change filter criteria, much in the same way Curtis Swahn did. I need to tidy and re-organize the macro information for some reports. Or do you take feedback to include such reports (requested by real customers in real cases of course). Thanks, Carl

  • Anonymous
    January 12, 2011
    Carl - Good question.  To edit "accdr" files, one needs to change the file extension to "accdb."  Once this is done, the file can be altered.  When you're finished making changes, change the extension back to "accdr." Thanks for the comment! Curtis

  • Anonymous
    January 12, 2011
    Thanks Curtis, I guess you would have caught that one if you were Access savvy :-) Anyway, is there any documentation about which tables, forms and queries are used for which reports? That would make it a lot easier and quicker than having to reverse engineer the structure. I want to add the file owner to the macros report but that field is not available to add when opening the macro summary report in Layout View. The information is in there somewhere as it is available in other reports. Thanks, Carl