Click here to Skip to main content
15,887,083 members

The Weird and The Wonderful

   

The Weird and The Wonderful forum is a place to post Coding Horrors, Worst Practices, and the occasional flash of brilliance.

We all come across code that simply boggles the mind. Lazy kludges, embarrassing mistakes, horrid workarounds and developers just not quite getting it. And then somedays we come across - or write - the truly sublime.

Post your Best, your worst, and your most interesting. But please - no programming questions . This forum is purely for amusement and discussions on code snippets. All actual programming questions will be removed.

 
GeneralRe: Val Grind (the wrong kind) Pin
LesF4-Jan-13 9:51
LesF4-Jan-13 9:51 
GeneralRe: Val Grind (the wrong kind) Pin
Rob Grainger4-Jan-13 10:09
Rob Grainger4-Jan-13 10:09 
GeneralRe: Val Grind (the wrong kind) Pin
Sander Rossel4-Jan-13 11:56
professionalSander Rossel4-Jan-13 11:56 
GeneralRe: Val Grind (the wrong kind) Pin
Member 46088986-Jan-13 11:45
Member 46088986-Jan-13 11:45 
GeneralRe: Val Grind (the wrong kind) Pin
Sander Rossel6-Jan-13 12:26
professionalSander Rossel6-Jan-13 12:26 
GeneralRe: Val Grind (the wrong kind) Pin
Chris Quinn24-Dec-12 0:19
Chris Quinn24-Dec-12 0:19 
GeneralRe: Val Grind (the wrong kind) Pin
Rob Grainger29-Dec-12 3:19
Rob Grainger29-Dec-12 3:19 
GeneralRe: Val Grind (the wrong kind) Pin
Chris Quinn31-Dec-12 0:17
Chris Quinn31-Dec-12 0:17 
It's not pretty, admittedly, but VB6 did not include the NZ function that later versions of VBA had.

The alternative would be to create an NZ function and use that e.g.
VB
Function Nz(ByVal V As Variant, Optional ByVal ValueIfNull As Variant) As Variant
	If Not IsNull(V) Then
		Nz = V
	Else
		If IsMissing(ValueIfNull) Then
			If VarType(V) = vbString Then
				Nz = ""
			Else
				Nz = 0
			End If
		Else
			Nz = ValueIfNull
		End If
	End If
End Function

====================================
Transvestites - Roberts in Disguise!
====================================

GeneralRe: Val Grind (the wrong kind) Pin
Rob Grainger31-Dec-12 2:57
Rob Grainger31-Dec-12 2:57 
AnswerRe: Val Grind (the wrong kind) Pin
Mark Hurd3-Jan-13 14:32
Mark Hurd3-Jan-13 14:32 
GeneralRe: Val Grind (the wrong kind) Pin
Rob Grainger4-Jan-13 9:55
Rob Grainger4-Jan-13 9:55 
GeneralRe: Val Grind (the wrong kind) Pin
Mark Hurd4-Jan-13 14:56
Mark Hurd4-Jan-13 14:56 
GeneralRe: Val Grind (the wrong kind) Pin
playstation328-Dec-12 21:22
playstation328-Dec-12 21:22 
JokeRe: Val Grind (the wrong kind) Pin
RafagaX3-Jan-13 4:57
professionalRafagaX3-Jan-13 4:57 
GeneralRe: Val Grind (the wrong kind) Pin
dshillito3-Jan-13 10:58
dshillito3-Jan-13 10:58 
GeneralRe: Val Grind (the wrong kind) Pin
Rob Grainger4-Jan-13 9:56
Rob Grainger4-Jan-13 9:56 
GeneralRe: Val Grind (the wrong kind) Pin
cpkilekofp11-Jan-13 7:02
cpkilekofp11-Jan-13 7:02 
GeneralRe: Val Grind (the wrong kind) Pin
Rob Grainger11-Jan-13 7:42
Rob Grainger11-Jan-13 7:42 
GeneralI am the Legend of Grimrock Poster Pin
Rob Grainger17-Dec-12 11:35
Rob Grainger17-Dec-12 11:35 
GeneralRe: I am the Legend of Grimrock Poster Pin
Brisingr Aerowing17-Dec-12 17:25
professionalBrisingr Aerowing17-Dec-12 17:25 
JokeRe: I am the Legend of Grimrock Poster Pin
BuggyTimes21-Jan-13 3:01
BuggyTimes21-Jan-13 3:01 
GeneralIt does what now? Pin
Member 869907216-Dec-12 8:23
Member 869907216-Dec-12 8:23 
GeneralRe: It does what now? Pin
Brisingr Aerowing16-Dec-12 9:47
professionalBrisingr Aerowing16-Dec-12 9:47 
GeneralRe: It does what now? Pin
Brady Kelly16-Dec-12 20:40
Brady Kelly16-Dec-12 20:40 
GeneralRe: It does what now? Pin
Pete O'Hanlon17-Dec-12 3:59
mvePete O'Hanlon17-Dec-12 3:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.