G
Gummy
Hello,
I have the following code on a form:
For Each ctr In Forms(strCurrentFormName).Controls
If TypeOf ctr Is TextBox Then
intTxtCount = intTxtCount + 1
Else
textBoxOrigValueArray(intTxtCount) = ctr.Value
ElseIf TypeOf ctr Is ComboBox Then
intTxtCount = intTxtCount + 1
textBoxOrigValueArray(intTxtCount) = ctr.Value
End If
Next
On the networked database this works just fine for me (using Access 2003).
On another computer (Access 2003 - SP1) I get the error on ctr.Value that
the following error:
Run-time error '2447': There is an invalid use of the dot (.) or !
operator or invalid
parentheses.
Why would it work fine on my machine and not her's. Plus we have all the
same references loaded.
Thanks for the help.
I have the following code on a form:
For Each ctr In Forms(strCurrentFormName).Controls
If TypeOf ctr Is TextBox Then
intTxtCount = intTxtCount + 1
Else
textBoxOrigValueArray(intTxtCount) = ctr.Value
ElseIf TypeOf ctr Is ComboBox Then
intTxtCount = intTxtCount + 1
textBoxOrigValueArray(intTxtCount) = ctr.Value
End If
Next
On the networked database this works just fine for me (using Access 2003).
On another computer (Access 2003 - SP1) I get the error on ctr.Value that
the following error:
Run-time error '2447': There is an invalid use of the dot (.) or !
operator or invalid
parentheses.
Why would it work fine on my machine and not her's. Plus we have all the
same references loaded.
Thanks for the help.