Monthly Archives: October 2014

Trusting Your Gut or When Not to Use Computers.

As good as computers are at calculating numbers they are really really bad at doing somethings that humans are just great at like making decisions based on fuzzy logic or translating things between languages. In such situations always go for … Continue reading

Posted in All, General Opinion, Personal Development, Problem Solving, Software Purchase | Comments Off on Trusting Your Gut or When Not to Use Computers.

Graphics vs Text

So today it is a bit slow for me so I answered a question from a lad in Phnom Phen in Stack Overflow. He was looking for support for Khmer in MS Access 2013, the official language of Cambodia. He … Continue reading

Posted in All, Configuration, Database Design, My UI Design Patterns | Comments Off on Graphics vs Text

Caspol.exe

Never heard of it? I hadn’t either – it is however a small exe that stands for Code Access Security Policy Tool which enables users and administrators to modify security policy for the client machine to .NET framework. This tool … Continue reading

Posted in All, Configuration, dot NET framework | Comments Off on Caspol.exe

OBJECT NAMING CONVENTIONS – My UI Design Patterns

I like to do several things. Name my tables T001TextVariableInCamelCase incrementing the number Name my queries Q001TextVariableInCamelCase incrementing the number Name my forms F001TextVariableInCamelCase incrementing the number This works well for me – some of my first applications only had … Continue reading

Posted in All, Database Design, MS Access, My UI Design Patterns | Comments Off on OBJECT NAMING CONVENTIONS – My UI Design Patterns

HIDE MENUS – My UI Design Patterns

Really simple – create a new module and create the following simple functions. I usually name them TurnMenuOn and TurnMenuOff. Public Function TurnMenuOn() Application.CommandBars(“Menu Bar”).Enabled = True End Function Public Function TurnMenuOff() Application.CommandBars(“Menu Bar”).Enabled = False End Function Then you … Continue reading

Posted in All, Database Design, MS Access, My UI Design Patterns, VBA Code MS Access | Comments Off on HIDE MENUS – My UI Design Patterns

SEARCHING RECORDS – My UI Design Patterns

Well if it is good enough for Google One single variable field with filtering only occurring after return has been hit. Search is across complete range of fields and searches for a string within all of the fields. Search string … Continue reading

Posted in All, Database Design, General Opinion, My UI Design Patterns | Comments Off on SEARCHING RECORDS – My UI Design Patterns

COLOUR – My UI Design Patterns

Use it – for those things just built for me I have arguable gone a bit mental before. Conditional formatting is particularly good for dates and allowing people to quickly see what is coming up and what is past. I … Continue reading

Posted in All, Database Design, MS Access, My UI Design Patterns | Comments Off on COLOUR – My UI Design Patterns

Enabling Geospatial integration in applications.

Despite the fact that spatially enabled databases have been around pretty much everywhere for quite sometime there’s still a heck a lot of enterprise applications out there that are not using the feature even though their backends support it. SQL … Continue reading

Posted in All, Database Design, Geographical Information Systems, SQL 08 R2, SQL Server | Comments Off on Enabling Geospatial integration in applications.