andrewsw's Profile User Rating: *****

Reputation: 4446 Guru
Group:
Mentors
Active Posts:
16,471 (17.68 per day)
Joined:
12-December 12
Profile Views:
127,761
Last Active:
User is offline Today, 01:31 AM
Currently:
Offline

Previous Fields

Country:
GB
OS Preference:
Windows
Favorite Browser:
Who Cares
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Who Cares
Dream Kudos:
3475
Expert In:
VB.Net/VB6
Icon   andrewsw Giggity, Giggity, Goo!

Blog entries

andrewsw's Blog > VB.NET Get SQL Server INCREMENT Value

Posted 14 June 2015

This isn't a tutorial, just a lump of code that I wanted to make available that demonstrates retrieving INCREMENT values for newly inserted SQL Server (Express) records, and displaying them on a WinForm. (There are some links in the code to articles on this subject.)

Of course, you should question whether you need to retrieve, or even...

Read Full Entry →

andrewsw's Blog > Post-It Notes in localStorage

Posted 05 June 2015

I started to explore this earlier today, a web page to create post-it notes, and then save, and retrieve, them from localStorage. I was going to entitle this blog "..work in progress" but I actually found that I managed to complete everything that I intended to include. (Note: I use jQuery.)

You can press the plus sign to create a new...

Read Full Entry →

andrewsw's Blog > Multi-line replace in Sublime Text

Posted 18 May 2015

I recently needed to find and replace blocks of code across multiple files. For example, to replace the footer of every HTML page. (Normally I would use PHP includes so that there is only a single footer, in a single file, but I wasn't allowed to do this for this site.)

It took a bit of digging to achieve this in Sublime Text. (Maybe it is...

Read Full Entry →

andrewsw's Blog > Excel with Andy: Dynamic Drop-Down

Posted 04 April 2015

Using Defined Names (formerly called Range Names) and Data Validation we can create a drop-down list where the list of choices changes according to the value chosen in an adjacent cell. In the screenshot the list of items in the drop-down changes according to whether Fruit or Veg is chosen in the adjacent cell in column A.

Image reduced in size...

Read Full Entry →

andrewsw's Blog > Excel with Andy: More Functions

Posted 26 March 2015

Most people are familar with Excel's basic statistical functions: SUM, AVERAGE, MAX, MIN, COUNT and possibly COUNTA. I will demonstrate the use of some more functions:

INDIRECT, ADDRESS, ROW, MATCH, OFFSET, COUNTA

Image reduced in size...

Read Full Entry →

My Information

Member Title:
I'm not here to twist your niblets
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:
Interests:
Fixing you
Programming Languages:
VB.NET, C#, Java, SQL, PHP, JavaScript, jQuery, HTML, CSS, Python, VBA, VB6, Regex

Contact Information

E-mail:
Private

Comments

  • (2 Pages)
  • +
  • 1
  • 2
  1. Photo

    mbole87 Icon

    01 Apr 2015 - 00:58
    Andrewsw helps me second time, awesome.
  2. Photo

    farad Icon

    15 Nov 2014 - 16:34
    One of the best...
  3. Photo

    abdalraheem Icon

    31 Dec 2013 - 04:59
    Thanks
  4. Photo

    Michael26 Icon

    14 Nov 2013 - 04:21
    Boom, 2000 rep points :)
  5. Photo

    laytonsdad Icon

    21 Aug 2013 - 14:03
    Getting close to 1500 rep, you are a robot.
  6. Photo

    Flukeshot Icon

    14 Jul 2013 - 16:09
    1337 reputation points, truely elite!
  7. Photo

    Michael26 Icon

    09 Jun 2013 - 14:11
    Wow andrew, you're on fire this month
    82 reputation points, nice :)
  8. Photo

    Michael26 Icon

    27 May 2013 - 16:14
    Great for you andrew, keep up the good work :)
  9. Photo

    jon.kiparsky Icon

    15 May 2013 - 13:13
    Jinx, buy me a coke!
  10. Photo

    laytonsdad Icon

    29 Mar 2013 - 14:15
    You are awesome.
  11. Photo

    kai_itz me Icon

    19 Mar 2013 - 23:10
    superb keep going....
  12. Photo

    _HAWK_ Icon

    04 Mar 2013 - 23:18
    Diggin on your Avatar man!
  13. Photo

    raghav.naganathan Icon

    26 Feb 2013 - 03:05
    Congrats on the 500 Mr.Enlightened :)
  14. Photo

    lar3ry Icon

    11 Feb 2013 - 05:50
    Very helpful answer on converting a string to an HtmlDocument! That one gets immediate use for me.
  15. Photo

    raghav.naganathan Icon

    11 Feb 2013 - 04:34
    Congrats on the 400 :) Excellent answer indeed!!! :)
  • (2 Pages)
  • +
  • 1
  • 2