Monday, July 19, 2004

How to Customise Menus and Menu Bars in MS Office This article uses MS Excel to demonstrate customisation of Office CommandBars.

Query Dependencies in MS Access Tracking complex query dependencies in Access was difficult before Access 2003, which provides this functionality natively. But what abour earlier versions of Access? Thankfully, questica.com provides an excellent add-in for earlier Access versions as donationware. Just run the setup.exe file and all your installed versions of Access will now have this functionality: right-click on a query in the Queries tab of the Database Window and select Dependencies from the popup menu to see a treeview of the dependencies in a custom dialog. There are addtional features: run a query from the dialog or view the design, or copy the dependencies to the Clipboard. Download



No comments: