Search results

John. You are continuing to deflect away form the technical aspects of this thread. You are quoting:- >>It is not a big thing ...<< when in fact I said:- >>It is not a big thing except if someone wants to refine their knowledge on a subject.<< You then use that miss-quote to go on and say:-...

And by the way, when Brian agrees with John and John thanks Brian then they are playing the personal game. I think they are both wrong:- Sub Test() Dim X As Variant Dim Y As Object X = Null Y = Nz(X) ' << Error. End Sub When either John or Brian can explain...

John. I think that is just a remark which indicates you have no intension of trying to understand what is going on technically. It is not a big thing except if someone wants to refine their knowledge on a subject. Some people, for whatever reason, don’t want to refine their knowledge and would...

Brian. >>What made me chuckle was that you spend two posts arguing that nz returns empty and yet say<< >>Produces 0 which is Empty<< In the line of code above “Produces 0 which is Empty”:- MsgBox VarType(Nz(x)) The MsgBox is reporting the return value of the VarType function. The VarType...

Esoteric can be a strange word. >>The long and the short of it is that if value_if_null is omitted the value that is returned will be directly determined by the type of value that is be requested.<< As I have been saying, that is incorrect. The value returned is Empty. MsgBox VarType(Nz(x))...

No it doesn’t, and that is what I’m trying to get away from. X holds Empty. On assigning X to S, the Empty is type cast to String because S is declared as String. On assigning X to I, the Empty is type cast to Integer because I is declared as Integer. The Nz function returned one and one only...

John. I didn’t say it invalidates the site you linked to I said I think it is in error in the statement I quoted. I think that is a big difference because if one statement invalidated a site then there would be very few valid sites, if any. I think it helps to try and prevent illogical...

Actually, I think that site is in error. Quote: “If this parameter is omitted and the variant is a null value, the Nz function will return a zero or a zero-length string.” I am inclined to think that if a Function is passed a Null, and no method of evaluation is supplied, then the Function can...

Hascons. Please upload the CSV file so we can see the data. Chris.

Hascons. The data in the Split array is indexed incorrectly. Equivalent code:- Private Sub ImportData(filePath As String, ticker As String) Dim arrData() As String Dim MyData As String Open filePath For Input As #1 With CurrentDb.OpenRecordset("Quotes1")...

An "analog medium". A fortune-teller who continuously changes their predictions. ;) Chris.

Just for fun, but a curious observation… Analogs vary continuously; Digitals step. Analog watches tick; digital watches don’t. (By the way, the internet is a wonderful source of knowledge but the things we find are not always correct. If we do a search on watches ticking we might find a...

Since it was mentioned in a previous post; what is the meaning of the word analog we use? For example: analog as opposed to digital; what is an analog Voltage? Chris.

The name of the argument passed to the Form_KeyDown event is KeyCode. If you use keyascii then it will be a Variant with a value of 0. Try adding Option Explicit to the code module. Chris.

Yep, push and pull also works for me. It’s a simple concept for which it is difficult to find the words. Perhaps the difference could be put as the difference between Instruction and Request. The Call is the Instruction for a single procedure to follow. If the Instruction is not done then an...

This is how I see the difference… 1. When we Call a Function or Subroutine we are making direct usage of one particular procedure. We Call it using its name. 2. When we use RaiseEvent we are sending a signal which other procedures listen for. In 1, we will invoke one procedure directly. In 2...

Col. There are some links which I regard as okay. For example, I have a link to a SkyDrive site which I consider to be a Microsoft site which I manage. We could quibble about words here but the proof of the pudding would be if Microsoft wanted to shut down SkyDrive then I would have no say in...

Col. I don’t know about the auto-registering thing. As for the post count limit… There are people who register for the sole purpose of placing a link to some other site. We don’t know what that site may be but, generally speaking, if the sole purpose is to post a link then the link is not...

>>Did you suggest she should do ads for King Kong in the jovial aussie way?<< The term used was a put-down of a person and it has no racial connotation whatsoever. It could have been used against any person of any race. It may have originally been said as ape, and not neanderthal, simply...

There is a demo here:- http://www.access-programmers.co.uk/forums/showthread.php?t=243278 Chris.