there is an invalid use of the . (dot) or ! operator or invalid parentheses

  • Thread starter Thread starter jac
  • Start date Start date
J

jac

I keep getting this error message:
"there is an invalid use of the . (dot) or ! operator or
invalid parentheses"

this is the code that seems to cause it:
curOrderSubTotal = Me!txtOrderSubTotal
 
jac said:
I keep getting this error message:
"there is an invalid use of the . (dot) or ! operator or
invalid parentheses"

this is the code that seems to cause it:
curOrderSubTotal = Me!txtOrderSubTotal
Click to expand...


What is txtOrderSubTotal? Double check the spelling every
where.
 
I keep getting this error message:
"there is an invalid use of the . (dot) or ! operator or
invalid parentheses"

this is the code that seems to cause it:
curOrderSubTotal = Me!txtOrderSubTotal
Click to expand...

Shouldn't. Could you post some more of the context? Is
curOrderSubTotal the name of a form control or of a VBA variable?
 
curOrderSubTotal is a VBA variable declared as currency.
txtOrderSubTotal is a textbox on the form.
I have tried curOrderSubTotal = Nz(Me.txtOrderSubTotal, 0)
but I still get the same error. There is a lot of code on
this command button.
Is it possible that the control is corupt?

thanks,
 
I tried that but it did not work. I even tried
curOrderSubTotal = Nz(Me.txtOrderSubTotal, 0),
and that did not work.
There is a lot of code on this command button. Is it
possible that the control is corupted?

thanks,
 
-----Original Message-----
jac said:
I keep getting this error message:
"there is an invalid use of the . (dot) or ! operator or
invalid parentheses"

this is the code that seems to cause it:
curOrderSubTotal = Me!txtOrderSubTotal
Click to expand...


What is txtOrderSubTotal? Double check the spelling every
where.
--
Marsh
MVP [MS Access]
.
New information: The controlsource is set to =[Forms]!
Click to expand...
[frmOrderEntry_debug]![ctlSubForm]![txtSubTotal]
but if I remove the controlsource, the code will work
fine.
What I am trying to do is assign the textbox a value from
a subform. Inside of the "add record" button code I want
to get the value in the textbox and assign it to the a
variable. This is where the problem is.

thanks,
 
curOrderSubTotal is a VBA variable declared as currency.
txtOrderSubTotal is a textbox on the form.
I have tried curOrderSubTotal = Nz(Me.txtOrderSubTotal, 0)
but I still get the same error. There is a lot of code on
this command button.
Is it possible that the control is corupt?
Click to expand...

That, or the . ! error lies somewhere else in your code. If you
Compile the project does it compile OK? or does it highlight this line
of code? Why do you feel that this line is at fault?
 
-----Original Message-----
jac said:
New information: The controlsource is set to =[Forms]!
[frmOrderEntry_debug]![ctlSubForm]![txtSubTotal]
but if I remove the controlsource, the code will work
fine.
What I am trying to do is assign the textbox a value from
a subform. Inside of the "add record" button code I want
to get the value in the textbox and assign it to the a
variable. This is where the problem is.
Click to expand...

You've lost me. What control source are you talking about?

If you have text box expression that calculates a value from
other text boxes and are trying to retrieve that value in
code, you could be running into a timing issue. If a
subform text box is trying to retrieve a value from a main
form text box, the subform may be trying to get the value
before the main form has loaded the data.

Other than those straw grasping thoughts, you should try
John's compile all suggestion.
 
-----Original Message-----


That, or the . ! error lies somewhere else in your code. If you
Compile the project does it compile OK? or does it highlight this line
of code? Why do you feel that this line is at fault?


.
I think this is line is at fault because when I single
Click to expand...
step thru the code, it goes from this line to the On
Error GoTo Err_cmdAddRecord_Click code.
Another thing that is going is that when I change the
textbox (Me.txtOrderSubTotal) controlsource to nothing it
works fine. But if I set the controlsource to =Forms!
frmOrderEntry!ctlSubForm!txtSubTotal it causes an error.

thanks,
 
=Forms!
frmOrderEntry!ctlSubForm!txtSubTotal it causes an error.
Click to expand...

Try

Forms!frmOrderEntry!ctlSubForm.Form!txtSubTotal

and check that ctlSubForm is the name *of the Subform control*, not
the name of the form within that control (I think you have this right,
that statement is more for the lurkers whom might be reading this)
 
John, thanks for staying with this.
I tried to fully qualify it as you suggested. It did not
work. ctlSubForm is the name the control that holds the
subform.
Click to expand...

I really suspect that you have some sort of subtle corruption in the
form. I'd suggest that you follow the repair suggestions at
http://www.granite.ab.ca/access/corruptmdbs.htm - repairing,
Decompiling, creating a new database and importing and so on as
needed.
 
Back
Top