Creative Connections

You are here Blog

Welcome to the Creative Connections blog, we hope that you find our blog to be an interesting useful resource that you can follow or simply dip into when required. You can also contact us for advice or support at This e-mail address is being protected from spambots. You need JavaScript enabled to view it .

 

The aim of our blog is to publish useful snippets of information based on answers to problems we have recently solved for customers and to provide an ongoing tutorial for search engine optimization (SEO), social media, Microsoft Office, VBA and pretty much anything we think would be great to share.
 

Please feel free to comment on any of the posts. All comments will be moderated before being published.

Google Search Page Layout Algorithm improvement

Saturday, 21 January 2012 07:11 Derek

In Googles continuous strive to deliver users with the most relevant and meaningful content, they have recently confirmed a change in their page layout search algorithm that takes into account the quality of content at the top of the page (or “above the fold” to use the correct terminology). This is targeted at pages that have a large amount of ads at the top of the page and / or very little, if any, relevant content. Google has stated that “these type of sites may not rank as highly going forward”.

The vast majority of sites should not be affected, but it is a useful reminder that it is really worth thinking about the layout of your page to ensure that your visitors can easily find the information that they are looking for and as in Googles words “Continue to focus on delivering the best possible user experience”. You can find out more about this change by visiting Googles Webmaster Central Blog.

Add new comment

How to Automatically Change Text From Lower Case to Upper Case in Access 2007

Friday, 20 January 2012 09:05 Derek

Applies to: Access 2007, 2010 (untested in earlier versions)

The following tutorial shows you how you can use VBA to set a field in your form so that regardless of how a user enters text in a field on a Microsoft Access form it will be automatically change all the letters to upper case.

1. Select the field you want to use

2. In the tools section of the “Design” tab click on the item called “Property Sheet”

3. Select the “Event Tab”

4. On the “After Update” property click on the little black down arrow / triangle

5. Select “Event Procedure”

6. Click on the three dots next to the little black down arrow / triangle - this will open up the VBA window and you should see the following:

Private Sub YourFieldName_AfterUpdate()

End Sub

(The text “ YourFieldName” straight after the words “Private Sub” will have automatically been replaced by the name of the field you are using)

7. On a new line directly between the two lines above add the following:

YourFieldName = StrConv(YourFieldName, vbUpperCase)

(Replacing the text in red “YourFieldName “ with the name of your field).

8. Save your changes and test your form / report

Note:  The text changes only once the user has finished entering data and clicked away from the field.

More Articles...

Page 4 of 6