Improve the “Find and Replace”

The “Find and Replace” can be improved a little by:

  1. Change these dialogs to default to expanding the search
  2. Move the dialog if it is covering the found text
  3. Change the message box to say:
    • 0 records found in the field ‘SupplierID’ for exactly ‘Olive’. Would you like to expand the search to try “like ‘Olive'”? [Yes] [No]
    • 0 records found in the field SupplierID? Would you like to expand the search to all fields? [Yes] [No]
Figure: The "Find and Replace" window

Figure: The “Find and Replace” window

Help me work with the Macros via XML

I wish could copy the text via a button “Edit Macro XML”… And the XML was formatted nicely :-)

Figure: Add a menu item "View XML"

Figure: Add a menu item “View XML”

    < ?xml version="1.0" encoding="UTF-16" standalone="no"?>
    < DataMacros xmlns="http://schemas.microsoft.com/office/accessservices/2009/11/application">< DataMacro Event="AfterUpdate">
    < Statements>< ConditionalBlock>< If>< Condition>[Table1].[Salary]>50000< /Condition>< Statements>< EditRecord>< Data/>
    < Statements>< Action Name="SetField">< Argument Name="Field">Table1.Notes< /Argument>< Argument Name="Value">
    "he is paid too much"
    < /Argument>< /Action>< /Statements>< /EditRecord>< /Statements>< /If>
    < Else>< Statements>< EditRecord>< Data/>< Statements>< Action Name="SetField">< Argument Name="Field">Table1.Notes
    < /Argument>< Argument Name="Value">"too little"< /Argument>< /Action>< /Statements>< /EditRecord>< /Statements>< /Else><
     /ConditionalBlock>< /Statements>
    < /DataMacro>< /DataMacros>

Figure: This ugly URL should be changed to nicely formatted XML

What has happened to Data Analyzer?

It was a great tool that was discontinued. It should reappear in Access!

Users should be used to “discover” data… and only afterwards, go into Excel or Reporting Services.
If the cube is decent (Levels / AVG’s, MAX’s, etc), it’s a really cool thing. it’s shocking that we don’t promote it as real world tool for execs and I hope MS keeps upgrading it.
Note: Not saying to show any MDX that is advanced and MDX can be done manually or in Proclarity (not Panorama).

Maybe OLAP data is a bit of a move away from core stuff but then again so is SharePoint integration in Access 12 and that does not seem to be a bad thing.

Snapshot Viewer

Microsoft’s Access Snapshot Viewer is a useful tool for viewing and printing Snapshot files (*.snp). While we can use its graphical interface, it would be good if the program could also be operated using command-line switches, such as ‘/openfile’ or ‘/print’.