Search results

Dick. That is exactly what I am trying to get at. Post #19 has nothing to do with trying to solve your problem. All it is is just words which do not contribute to your desired solution. Post #19 is totally irrelevant to the solution. It is being used simply as some social interaction. It is...

Dick. You need to focus on not making mistakes. We all make mistakes but some people seem to think that other people will make allowances for them. That may be true but a computer is not another person and VBA is not English. You need to think differently when speaking to a computer; it will...

Dick. You appear not to be able to focus on a single point. If you wish to try and write code then that is one of the first things you will need to learn. How long you have been using Access is totally irrelevant. What you have been using Access for is totally irrelevant. If you happen to be...

Dick. In your first post you placed this inside a code block for posting:- "On Error GoTo Err_cmdFindState_Click" but the above is not a line of code in your program. You need to be careful; you need to understand that the compiler will not make allowances for some things that people simply...

CJ. It is not about being suitably humbled it’s about being better informed. Even though the ‘effect is as described’ might be correct under this circumstance it is not the same thing. People who suggest that a Function can somehow ‘flip a coin internally’ to decide what data type can be...

G’day Galaxiom. Did you notify Microsoft of that error? I didn’t simply because I didn’t think they would do anything about it. Certainly amazes me how many other sites will copy and paste something from another site, including a Microsoft site, without even thinking about it. It...

John. Could you please post a sample database in MDB format? Chris.

To be reasonable I think InStrRev() is an exception. It was introduced in version 2000 along with some other VBA functions. http://trigeminal.fmsinc.com/usenet/usenet001.asp?1033 So, the intent of writing a version of InStrRev() would be to allow Access97 users to use that facility. The...

Banned from UA? I am sorry, I didn’t realise you were that good. :D Cybercow again? Sooner or later someone from Microsoft should look at the suitability of that MVP being one. Maybe they don’t care so long as someone promotes their product(s). UA has a predisposition to regurgitate what...

Galaxiom. http://www.utteraccess.com/forum/Call-Public-Function-t1998546.html What continues to leave me dumbfounded is that some of the people at UA still need, after all these years and their self-promotion, to be told the difference between a Subroutine and a Function. Post #16 is...

This sort of thing is not as easy as it may appear. The question about if a file exists could very well be ambiguous. For example: Does a file exist for all users in a multi-user environment? In other words; can they get at it? In any case, the following code is based on a few assumptions...

Yes, it is my understanding as well that reference counting is used in VBA to determine if the memory for the Object should be reclaimed. However, pointers to the Object may become Nothing (numerically 0) and that is somewhat of a different thing. For example, if there are two pointers to the...

We can watch this in Task Manager by looking at running Processes or the Total Commit Charge:- Option Compare Database Option Explicit Public Declare Sub Sleep Lib "kernel32" (ByVal lngMilliSeconds As Long) Private Sub TestIt() Dim tmp As New Excel.Application Sleep 5000...

SmallTime. If you wish to ask a question then please try to be succinct. If you wish to rant then please take it to the watercooler. Chris.

I’m normally very reluctant to call things bugs but I think you have one there. I don’t think I have seen that before but it is reproducible in Windows XP with Access 2003 (service pack 3 with the hot fix). Some research indicates that Allen Browne’s ‘Find as you type’ exhibits the same...

Too much code. There is a need to isolate what we are going to do from when we are going to do it. Try to look at the logical structure before even trying to fill in the blanks. Simplify, test and expand:- Option Compare Database Option Explicit Private Sub Incoming_Module_Sn_AfterUpdate()...

It looks like Me.end_user should return as string but Left(Me.end_user, 2) = "TW" should return True or False have you tried:- Select Case True Chris.

Linq. >>Sorry, but I certainly did give a reason!< and >>have never seen either an explanation nor a resolution to the problem.<< I have trouble with the above, unless you think that people just saying they have had trouble with the API call is sufficient reason not to use it. The web is full...

I think there is a lot wrong with this thread... ---------- I do not think it is appropriate to criticize an API call (post #5) without even giving the slightest reason for doing so. All that does is spread fear for no valid reason. Equally then, there is no reason to post an alternative to...

I think it should be asked why it is necessary to know where the Form is in order to position it? If the Form is sometimes already at the exact X/Y pixel then maybe it doesn't need to be moved but how often would that be the case? Using the Me.Move method will not position the Form 'on the...