HBSMR/PACS reports fail if no default printer present If trying to print a report in HBSMR or PACS (or any other MS Access application) gives an error message along the lines of "cannot find report or form MonFullRpt", even though this report does... read more Posted by Crispin Flower 06 February 2008 Categories: HBSMR PACS Comments(0)
Setting Microsoft Access Macro Security Settings using the registry If the Macro Security setting cannot be changed through the Access application (can be disabled in the installation), this registry setting can help. To set the security to... read more Posted by Crispin Flower 27 February 2007 Categories: HBSMR PACS Comments(0)
How to run Mapbasic code whenever a .tab file is opened Mapbasic code can be run whenever a .tab file is opened by inserting code in the .tab file just after the header. e.g. ... !charset WindowsLatin1 Run Application... read more Posted by Crispin Flower 31 October 2006 Categories: MapInfo Professional Comments(0)
How to check what geometry types are present in a MapInfo table How to check what geometry types are present in a MapInfo table In MapInfo Pro, the following query will summarize the contents of a layer by geometry type: (type this into the... read more Posted by Crispin Flower 16 May 2006 Categories: MapInfo Professional Comments(0)
How to setup new file types in LibraryLink/ThumbsPlus To register a new file type in LibraryLink/ThumbsPlus do the following (example: ".mdb" files): Open ThumbsPlus Go to "Options=>Preferences" and activate the "File... read more Posted by Crispin Flower 26 April 2006 Categories: LibraryLink ThumbsPlus Comments(0)
How to recompile all views in SQL Server DECLARE @viewname varchar(128) DECLARE @viewname_header varchar(128) DECLARE vnames_cursor CURSOR FOR SELECT name FROM sysobjects WHERE type = 'v' OPEN vnames_cursor FETCH NEXT FROM... read more Posted by Crispin Flower 21 April 2006 Categories: SQL Server Comments(0)