Overflow error

[dfenton]

I would be glad to be proved wrong, David, so can you please supply the proof and not just statements which you believe to be the fact.

I lived through it, changing the setting in A2000 and not needing to do so in A2002 and A2003.

If you don't believe that, well, there's nothing I can do about it. I don't understand why you feel the need to make an issue of it.

 

[ChrisO]

>>I lived through it, changing the setting in A2000 and not needing to do so in A2002 and A2003.<<

Three part answer…

Part 1.
>>If you don't believe that, well, there's nothing I can do about it. <<
Why should I believe you, David, you have given no proof.

I have given two traceable links…
-------
The first link was about something stated on Sunday 1st November 2009.
The second link was dated June 2003.
------

But all you have said is that they were out of date.
Saying something does not constitute proof, just hearsay.

Flip the coin to the other side; under the circumstances, would you believe me?
Would you believe hearsay from me if you had some proof to the contrary?
I think not; so why should I believe you?
And if I believe you, I’m put into a position of not believing them.
I’m not going to do that, David.

There’s a lot of garbage spoken on the web, as I’m sure you already know, so what are we to believe?
My general principal is not to believe anyone, not even myself, until some proof comes along which is not just hearsay.
That is why I would welcome some proof of the matter.


Part 2.
>>I don't understand why you feel the need to make an issue of it.<<
The ‘issue’, of which you speak, is truth; not just hearsay but provable truth.
But you have not given any proof; all you have done so far is to contribute hearsay.
Is the truth just another ‘issue’ to you?


Part 3.
This discussion, between you and I, could be seen by some as hijacking a thread.
However, I don’t believe it is hijacking if the thread comes back on track.
If a thread comes back on track then it is simply a ‘thread within a thread’ and the OP gets served.

What service have you done for the OP since their last reply?

 

[dfenton]

The quotes are out of date, period, end of statement. Luke Chung has tons of articles out there that have information in them that dates back to A97 and has not been updated (many of them on MS's website). Just because it's stated on the web indeed does not make it true.

Access defaults to OPTION EXPLICIT except for version 2000.

This is a true statement. You may believe it or not.

 

[gemma-the-husky]

PublicConst SCARD_PROTOCOL_RAW As Integer = &H10000

where is this declared - in VBA you dont type constants do you?

just

Public SCARD_PROTOCOL_RAW = &H10000

(not sure if you can use Hex directly)

is this an Access VBA problem, or not?

 

[ChrisO]

G'day Dave (note not David )

Something from the Help File: -

"If you don't explicitly declare the constant type using As type,
the constant has the data type that is most appropriate for expression."

Sub Test()
    
  [color=green]'  Const Thousand = 33000              ' data type Long
  '  Const Thousand = 33000@             ' data type Currency
  '  Const Thousand As Currency = 33000  ' data type Currency
  '  Const Thousand = 33000              ' no data type
  '  Const Thousand = 32000              ' no data type[/color]
     
    MsgBox Thousand * 2
 
End Sub

Try un-commenting and running each of the five lines in turn.
It would be re-opening a long story as to precisely why this happens but it could be worthwhile noting that it still does.