Search results

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.

As others have said, a lot of time can be wasted trying to create controls at runtime. However, there is still a need to create controls automatically under some circumstances. For example: if we needed 700 controls, which are sequentially numbered, then it would be a right pain to do it...

Using Dale’s data, the A2003 attachment may be one way of doing it. Chris.

The poster has been removed. Chris.

I do not believe in gurus so I don’t care about that link. From me:- >>It also appears that clsObjXMLFASMessagesItems inherits clsObjXMLFASMessagesItem.<< From you:- >>No, the Items class is a custom collection containing instances of the Item class.<< How do those two statements differ...

Too much stuff; condensed from the posts… You appear to have two classes:- clsObjXMLFASMessagesItems and clsObjXMLFASMessagesItem It also appears that clsObjXMLFASMessagesItems inherits clsObjXMLFASMessagesItem. It also appears that in class clsObjXMLFASMessagesItem there is a Private...

Well, I’m glad someone found it useful. :) If you would like to, you could create a demo (MDB please) and submit it to the sample database forum. I know it might be a bit of work, so only if you have the time. Chris.

And another thing which make the often quoted advice utter nonsense… The reset might happen when we come out of debug mode. In an MDE file we can’t go into debug mode and so we can’t come out of debug mode. Since we can’t come out of debug mode the reset does not happen. Since the reset does...

Not exactly… The ERROR did not cause A to lose its value, but the RESET will cause A to be reset to zero if the RESET occurs. The resetting of the Global variable is done by the RESET not the ERROR. Now people might say “Oh! We knew that, you’re just being pedantic.” Well, I’ll not just being...

One step at a time:- Public A As Long Sub Test() Dim B As Long A = 10 B = A / 0 End Sub Run the code. Enter debug mode. Hover over A. A has a value of 10. The ERROR did not cause A to lose its value. I can not make it simpler than that. Chris.

Doc. In a computer, things happen for a reason, they don’t just happen. Global variables, and that includes Global Objects, don’t just lose their value they get reset. The reset is deliberate and the variables are reset to a particular value. Numbers, including dates, to 0. Strings to a zero...

To my way of thinking, this is the essence of Uncle Gizmo’s post:- >>in other words there's no good reason for using a global variable except that it's quick and easy<< I think we could also add to that >>except if there is no other way<< This is how I see the problem: quantity on the www...

B is not declared, turn on Option Explicit. On Error GoTo err_hand would reset the error object. A small change and there is no need for recursion in this case:- Option Compare Database Option Explicit Sub CallMyTest() Dim a As String a = "myFieldBad" MsgBox myTest(a) End...