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 ?

Thanks, but where do you get the current form size from ? It's not form.width and form.height because they don't change as the form is resized by dragging the form edge.

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...

Thanks. Having read the blurb it talks about using transactions too. But that is just plain daft, because how do you know to issue an explicit rollback if you can't detect the error. Hmmm, I think I'll experiment with .addnew Thanks for the prompt to read the blurb.

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...