Exegesis Spatial Data Management
Posts in Category: VBA
How to do a typeahead incremental search control in Microsoft Access
Posted by Crispin Flower
11 January 2015
Categories:
MS Access
UXD
VBA
When a user needs to find an existing record or value by typing something in a box, it is well recognized that a "typeahead" or incremental search is a powerful and user-friendly solution. Of...
read more
Comments(7)
Handling different character encodings when importing tabular data from CSV
Posted by Crispin Flower
24 September 2012
Categories:
HBSMR
MS Access
VBA
I’ve been fixing some minor issues with the utility in HBSMR that imports data from the Portable Antiquities Scheme. One issue was that some characters were mojibaked during the import, for example...
read more
Comments(0)
ACCDE problems on Access 2010 (and Access 2010 SP1)
Posted by Crispin Flower
11 February 2012
Categories:
Microsoft Office
MS Access
VBA
We’ve had a bit of bother over the past few weeks, where an Access application compiled as an .accde file in Access 2010 would not run on other machines. The error messages encountered varied...
read more
Comments(0)
Adding files to a SharePoint document list with MS Access – how to add new files
Posted by Crispin Flower
01 February 2012
Categories:
MS Access
SharePoint
VBA
MS Access can be a nice interface onto SharePoint. We’ve been implementing this for a client, allowing files and metadata that are managed in HBSMR (Access UI onto SQL Server database) to be...
read more
Comments(0)
MS Access DAO recordset + SQL Server: how to get the ID of a newly inserted record
Posted by Crispin Flower
23 December 2011
Categories:
HBSMR
MS Access
SQL Server
VBA
Sometimes when inserting records programmatically you want to create a parent record first, then add records into related tables where the Foreign Key is on an autonumber field. Therefore you need to ...
read more
Comments(1)
Categories
.Net Core
(2)
API
(1)
AppV
(1)
ArcGIS
(9)
ASP.Net
(4)
Azure
(5)
CAMS
(1)
CGI
(2)
Cloud
(1)
Cloudscribe
(2)
COM
(1)
Fiddler
(1)
GeoServer
(12)
GIS (general)
(18)
GISquirrel
(3)
HBSMR
(13)
Identity Server 4
(1)
IIS
(11)
Internet Explorer
(1)
jQuery
(1)
LibraryLink
(2)
Load-testing
(1)
MapInfo Professional
(11)
MapLink
(5)
MapServer
(14)
Microsoft Office
(2)
Mobile
(1)
mojoPortal
(11)
MS Access
(11)
OGR/GDAL
(6)
OpenLayers
(5)
Ordnance Survey
(4)
PACS
(2)
PostgreSQL/PostGIS
(3)
Projections
(2)
Python
(6)
Quantum GIS (QGIS)
(4)
RD Gateway
(1)
Regular expressions
(2)
Remote Desktop
(3)
RemoteApp
(1)
Security
(2)
SharePoint
(1)
SQL Server
(27)
ThumbsPlus
(2)
Tilecache
(3)
UXD
(1)
VBA
(5)
Visual Studio
(4)
WFS
(3)
Windows 8
(1)
Windows Server 2008
(2)
Windows Server 2012
(1)
WMS
(5)
XSLT
(1)
Archives
June, 2020 (1)
May, 2020 (1)
October, 2019 (1)
April, 2019 (1)
February, 2019 (2)
November, 2017 (1)
March, 2017 (2)
January, 2017 (1)
July, 2016 (1)
April, 2015 (1)
March, 2015 (1)
January, 2015 (1)
December, 2014 (1)
November, 2014 (2)
October, 2014 (1)
September, 2014 (1)
July, 2014 (1)
June, 2014 (9)
April, 2014 (2)
March, 2014 (3)
February, 2014 (1)
January, 2014 (2)
December, 2013 (2)
November, 2013 (3)
October, 2013 (2)
September, 2013 (2)
June, 2013 (6)
May, 2013 (4)
April, 2013 (3)
March, 2013 (3)
February, 2013 (2)
December, 2012 (1)
November, 2012 (1)
October, 2012 (2)
September, 2012 (2)
August, 2012 (5)
July, 2012 (4)
June, 2012 (5)
April, 2012 (1)
March, 2012 (3)
February, 2012 (4)
January, 2012 (8)
December, 2011 (6)
November, 2011 (10)
September, 2011 (1)
December, 2010 (1)
November, 2010 (1)
April, 2010 (1)
December, 2009 (2)
February, 2008 (1)
February, 2007 (1)
October, 2006 (1)
May, 2006 (1)
April, 2006 (2)