Search results

I need to know how big a number I can hold in a "Long Integer". The only documentation I can find says it's roughly +/- 2 billion. Is that a USA billion (10^9)or a UK billion (10^12) ? I'm guessing it's a 32bit number so that would be a USA billion. Can anyone confirm this ?

I've got a form and have set the border style to "sizable" and when the form/code is running I can change the size of the form by dragging the edge with the mouse, BUT, form.width and form.height do not change. Hence I cannot pick up any value for the new form size and recalulate control sizes...

I have a simple table called "dummy" with one field that is the primary unique key. The following code does NOT produce a duplicate key error. Why is that ? Private Sub Form_Load() Dim dbsCurrent As dao.Database Set dbsCurrent = CurrentDb() On Error GoTo ooops...