Category Archives: My UI Design Patterns

Database Normalisation – a review of the rules to refresh my knowledge

Here is a review of the 6 forms of normalisation (yes the 4th is called 3.5 for some reason) – there are lots of summaries on the web of these, but I wanted to re-write them in my own words … Continue reading

Posted in All, Continual Professional Development, Database Design, My UI Design Patterns, Personal Development | Comments Off on Database Normalisation – a review of the rules to refresh my knowledge

Predictable URL design

As we move to more and more web based applications it is going to be more and more important for developers to really think about how users access their web applications. Individual pages or search options may be more important … Continue reading

Posted in All, My UI Design Patterns | Comments Off on Predictable URL design

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

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

BANISH DOUBLE CLICKING – My UI Design Patterns

I eluded to it in my last post but when I have tabulated forms I like to have the labels activated and set to sort alphabetically ascending on left click and descending on a right click. I use the mouse … Continue reading

Posted in All, Configuration, Database Design, MS Access, My UI Design Patterns, User Interface Design, VBA Code MS Access | Comments Off on BANISH DOUBLE CLICKING – My UI Design Patterns