Category Archives: Database Design

MS Access like development environments for the Web – 3 alternatives

So you would like to construct simple applications that you can at the moment create in MS Access but you want to do it on the web. By that I mean you would like to create a data driven application … Continue reading

Posted in All, Code Generators, Continual Professional Development, Database Design, Dev Ops, dot NET framework, General Opinion, Learning, Low Coding Platforms, MS Access, Personal Development, RAD Web Tools | Comments Off on MS Access like development environments for the Web – 3 alternatives

nuBuilderPro – a database driven Web Framework for simple Form Design

I have been seeking a way of designing simple web forms for a reasonable cost for some time. I was continually coming across either very professional products with really quite large annual charges (alpha anywhere) or alternatively products that charge … Continue reading

Posted in All, Continual Professional Development, Database Design, Dev Ops, nuBuilderPro | Comments Off on nuBuilderPro – a database driven Web Framework for simple Form Design

SQL Saturday #388 Edinburgh

Went along to SQL Saturday BI Edition on 13th of June. Honestly I thought it was really great. Many thanks to Jenny Stirrup for being the event organiser. If you are thinking about going next year you really should. This … Continue reading

Posted in All, Continual Professional Development, Database Design, Dev Ops | Comments Off on SQL Saturday #388 Edinburgh

Setting up a Blank SQL Server Spatially enabled Table using Microsoft SQL Server Management Studio 2008R2 Express and displaying it in QGIS 2.8.1

Programs used; 1- SQL Server 2008R2 Express 2- SQL Server Management Studio 2008R2 Express 3- QGIS The example uses UK national grids coordinates to create a Triangle Polygon in a SQL Server Table I’ve previously written that while we’ve had … Continue reading

Posted in All, Configuration, Database Design, Dev Ops, QGIS General, SQL 08 R2, SSMS | Comments Off on Setting up a Blank SQL Server Spatially enabled Table using Microsoft SQL Server Management Studio 2008R2 Express and displaying it in QGIS 2.8.1

Spatially Enabling an existing Table – which has Eastings and Northing fields UK National Grid

The following TSQL will spatially enable a SQL Server Table called T1RainbowTable when it has two Fields called East and North with UK National Grid References. UPDATE T1RainbowTable SET Coordinates=geometry::Point([East],[North],27700)

Posted in All, Database Design, Dev Ops, QGIS General, SQL 08 R2, SQL Server, SSMS | Comments Off on Spatially Enabling an existing Table – which has Eastings and Northing fields UK National Grid

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

Save Record before Event

If users are editing or creating a record and there is an option on the form to print out the form if they press it they will expect the information that they have just created to appear on the print … Continue reading

Posted in All, Database Design, MS Access, VBA Code MS Access | Comments Off on Save Record before Event

Forcing or Limiting Columns Using Cross Tab Queries

MS Access has a version of SQL that can be edited to enforce specific columns being shown in queries. Within the query editor navigate to the SQL View Normally when a cross-tab query is selected MS Access will generate columns … Continue reading

Posted in All, Database Design, MS Access, SQL MS Access | Comments Off on Forcing or Limiting Columns Using Cross Tab Queries

Project Management – Things that help lead to successful outcomes

Many roles within organisations now require good project management skills especially when it comes to implementing new IT systems and applications. But are there things that can be put in place at the beginning to improve your chance of success. … Continue reading

Posted in All, Database Design, Dev Ops, General Opinion, Project Management | Comments Off on Project Management – Things that help lead to successful outcomes

Dealing with Dates can still catch you out

The other day I was dealing with dates and I found a cracking little gotcha that might just be catching a few people out. When is 07/11/14 not 07/11/14 When one is 17 November 2014 and one is 17 November … Continue reading

Posted in All, Configuration, Database Design, Win 8.1 | Comments Off on Dealing with Dates can still catch you out

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

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.

The devil is always in the detail – Setting constants to Russian cyrillics in VB

With programming the devil is always in the detail. Just out of curiosity I was thinking about the code that I have posted that randomises information in a database and I was thinking why don’t I try to randomise the … Continue reading

Posted in All, Database Design, Learning, MS Access, Programming, VBA Code MS Access | Comments Off on The devil is always in the detail – Setting constants to Russian cyrillics in VB

40 Useful Facts to Know about a System

A list of points I should remember to ask when doing ongoing system development, total re-design or external purchase. For alternative systems rank both existing and new and compare. Collection of facts is as objective as I could make it … Continue reading

Posted in All, Configuration, Database Design, General Opinion, Software Purchase | Comments Off on 40 Useful Facts to Know about a System

VBA access code – Passing a selection of e-mail addresses to Outlook

This is similar to the previous post except uses the inbuilt SendObject object to pass the string sBcc directly to Outlook. Outlook picks up the variables and so there is no need to set up public variables. CODE Private Sub … Continue reading

Posted in All, Database Design, E-mail, MS Access, VBA Code MS Access | Comments Off on VBA access code – Passing a selection of e-mail addresses to Outlook

VBA access code for pulling together a list of e-mails and passing to a form

Below some standard code that I use to loop through a selection of records and create a string from the individual [Email] s in the below case the e-mails are passed to a form (FORMTOOPEN) – if you are using … Continue reading

Posted in All, Database Design, MS Access, VBA Code MS Access | Comments Off on VBA access code for pulling together a list of e-mails and passing to a form