Monthly Archives: May 2014

Code for altering tables on the fly

Most of the time when you are wanting to enter information automatically in fields as a result of a user interaction it is easiest to use some kind of event trigger from the form. Regularly you want to close down … Continue reading

Posted in All, Database Design, MS Access, VBA Code MS Access | Comments Off on Code for altering tables on the fly

Clear instructions on making your own Ethernet Cabling

Last week I needed to make up some new ethernet cabling. I’ve got round to getting my own set of crimpers and a testing kit as well. The best wiring diagram and instruction I could find is listed below. http://www.groundcontrol.com/galileo/ch5-ethernet.htm … Continue reading

Posted in All, Networking and Cabling | Comments Off on Clear instructions on making your own Ethernet Cabling

Attaching an existing SQL data file to a new SQL Express Instance

Link for information http://technet.microsoft.com/en-us/library/ms165673(v=sql.105).aspx

Posted in All, Configuration, SQL 08 R2, SQL Server, SSMS | Comments Off on Attaching an existing SQL data file to a new SQL Express Instance

Stopping and Starting SQL Server Instance 08R2 Express

Simply within SSMS right click on the instance and hit STOP and To start an instance if you are still in SSMS you can simply right click and hit start Note if you stop a SQL Server instance from within … Continue reading

Posted in All, Configuration, SQL 08 R2, SQL Server, SSMS | Comments Off on Stopping and Starting SQL Server Instance 08R2 Express

Allowing sa login and altering password SSMS SQL 08 R2 Express

Recently I installed SQL Server 08 R2 Express. As part of the standard installation the sa login is disabled as default. Clearly although this is a useful security feature it is a bit awkward if you are wanting to undertake … Continue reading

Posted in All, Configuration, SQL 08 R2, SQL Server, SSMS | Comments Off on Allowing sa login and altering password SSMS SQL 08 R2 Express

Building Timing Software for Athletic Races

A while back I got the opportunity to work with a friend who times athletic races. After a bit of questioning he showed me some of his equipment and how it worked. I realised I could probably put together some … Continue reading

Posted in All, Database Design, Problem Solving | Comments Off on Building Timing Software for Athletic Races

Attach DSN Less Connection to Link MS Access to SQL Server

This code is generally available all over the tinternet nonetheless I list it here for my own personal use. I use an autoexec macro to trigger the code on open With a Run Code action to trigger the AttachDSNLessTable… So … Continue reading

Posted in All, MS Access, SQL Server, VBA Code MS Access | Comments Off on Attach DSN Less Connection to Link MS Access to SQL Server

Why you and your Organisation should make Web Bespoke part of your operations.

Don’t get me wrong as a platform for communication I consider things like facebook and Linkedin as necessary evils for what is essentially cloud service market places but my preferences are always… No adverts No demands to have login prior … Continue reading

Posted in All, Problem Solving, Productivity | Comments Off on Why you and your Organisation should make Web Bespoke part of your operations.

VB – code behind to go to url

Where Link is a field containing URL. DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Dim Link As String Link = Me.Link Application.FollowHyperlink “http://” & Link

Posted in All, MS Access, VBA Code MS Access | Comments Off on VB – code behind to go to url

A Story about User Interface Design

At work we recently moved to a new building which has been adapted several times, some spaces have had multiple uses and multiple security level changes. The present use of rooms is different from the original design. As a result … Continue reading

Posted in All, User Interface Design | Comments Off on A Story about User Interface Design

An example application for use learning Русский

I quite often put together various databases / applications to help me with my side projects. This is a good example. In an effort to help me remember my Russian verbs I put together a small database to assist in … Continue reading

Posted in All, Database Design, MS Access, Русский | Tagged | Comments Off on An example application for use learning Русский

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