Search results

I do not believe it would prove fruitful to try and stuff all the code into one class module. A common variable needs to be accessible from each instance of each Class. That variable could be a Public/Global variable or it could be a variable behind the Form. With this code I’ve gone for a...

This will also happen if error handling is set to Break on All Errors. Chris.

If we clear out all the stuff not need for the problem we should get to something like this. Behind the Form:- Option Compare Database Option Explicit Private col As New Collection Private newCmd As New clsEvents Private Sub Form_Load() Dim ctl As Control ' Do the Form and...

It would look something like this:- Private Sub cmdResetLists_Click() myReset Me End Sub And you do not need the Else in the Function, and while you are at it you can remove the commented line. The requery is a bit different. If you are going to have a GotFocus event for a Combo Box...

AccessBlaster. In post# 91 you are drawing some connection between Edgar F. Codd and me. Where did you get that connection; which thread, which post? Are you sure you have the right person? I try to stick to VBA and not go near things I know little about. Re post #93. No one is being cut down...

Robert. I doubt if anyone is going to ban you for what you have said so far, if that’s what I wanted I would have done it myself. (I am a moderator of this site and that information is available if you wished to look for it.) You seem to be saying that it is just your opinion and how you are...

Robert. >>You missed the point.<< Are you talking to me? If so, I take exception. The reason I take exception is that you have drawn attention to me and made an absolute statement that I missed the point. You do not know very much about me at all so your statement is actually coming from a...

One could say that there is another Commandment:- First, read that which has already been written. The GoTo’s were covered in Commandment #9 in post #1 in this thread. The spaces were mentioned in post #2 and in many posts since then. Another Commandment should be:- Don’t simply believe...

I like the concept but it seems a little too easy to break. These days, anytime I see code in the Form_Unload or Form_Close events I get a bit suspect. The failures caused can be very subtle. The problem in this case is that if a Quit command is issued, anywhere in the database, then...

Spikepl. I think all post #17 is, is an attempt to tear down another perfectly good method of doing it. I think this is an educational site so why try to tear down another method based on your perception of what is obscure and what you might forget in 6 months time? If you have so much...

>>This has an advantage over using OpenArgs which can only pass a string.<< That’s another thing we can blame the Microsoft documentation for. OpenArgs is a Variant which means it can be a String or a Long which means it can be a numerical value such as a pointer which means it can be an...

You probably already have more methods than you need but there is another one. Code in the calling Form suspends if the called Form is opened in acDialog mode. The code stays suspended while the called Form is open and visible. The called Form can set itself to invisible and the code in the...

This thread was deleted by Joe8915 after specifically being asked not to do so by a moderator and an administrator. I have undeleted this thread in order to preserve the replies of the other members who have contributed to it. I will suggest that Joe8915 does not delete it again. Chris.

Joe, please do not delete this thread. By deleting this thread you will also be deleting the opinions of others and the opinions of others are not yours to simply delete. Learn by your mistakes and try to verify the information you supply before posting. If you have made a mistake then simply...

Thank you, Nigel. :) Chris.

The attachment is using Windows 7 and Access 2003. It works as expected. Are you saying that it does not work on other systems? Chris.

I still think we are wasting our time until Lana can specify the problem. At this point she has not posted any code at all so we really are guessing at the requirement. What we really need is:- 1. This is how the variable is defined. 2. This is how it is initialised. 3. This is how it is being...

Lana. I think you still have this problem because you can not describe the problem. I doubt if anyone could replicate the fault from the information you have supplied. Can you please post accurate information? Chris.

Can you please describe in more detail why you think you need to do this “regardless of whether they're open or closed”? If you are talking about changing the natural language, such as English or German, that a database displays in Label Controls then it would normally be done while each...

I would like to say yes; but no, it was just a mistake. :D