Error at Break point

B

banem2

Hi All

I am using MsAccess XP on Windows XP ,I have a problem when I put a break
point in code to debug sum variables ,Debug window  flashes for 2 seconds
then an error message pops up "This expression is typed incorrectly, or it
is too complex to be evaluated. For example, a numeric expression may
contain too many complicated elements. Try simplifying the expression by
assigning parts of the expression to variables."

I tried to put a break point on another Form but I did not get this error
,Any help will be appreciated.

Thanks In Advance

Wael.

It looks like your form needs to have focus in order to perform
calculation.

Regards,
Branislav Mihaljev, Microsoft Access MVP
 
W

Wael

Hi All

I am using MsAccess XP on Windows XP ,I have a problem when I put a break
point in code to debug sum variables ,Debug window flashes for 2 seconds
then an error message pops up "This expression is typed incorrectly, or it
is too complex to be evaluated. For example, a numeric expression may
contain too many complicated elements. Try simplifying the expression by
assigning parts of the expression to variables."

I tried to put a break point on another Form but I did not get this error
,Any help will be appreciated.

Thanks In Advance

Wael.
 
B

banem2

<[email protected]> ???????(?) ? ????????
?????????:[email protected]....

I could not read this.

Sample when form needs to have focus to perform calculation is when
you use under some event code like this:

MyCalcField = Me.MyField1 + Me.MyField2

If you move focus to VBA screen, program cannot find those 2 fields.
Instead, you can use something like this:

MyCalcField = Forms!frmMyForm!MyField1 + Forms!frmMyForm!MyField2

This is wild guess only as I don't have more details.

Regards,
Branislav Mihaljev, Microsoft Access MVP
 
W

Wael

I have noticed that the problem occurs after I set the default value to a
combo box.the problem is that I feel that the code is running in the
background even when the debug window is paused with a break point .

I Do not know if this will help you to analyze the problem

Thanks for your help

Wael

Hi All

I am using MsAccess XP on Windows XP ,I have a problem when I put a break
point in code to debug sum variables ,Debug window flashes for 2 seconds
then an error message pops up "This expression is typed incorrectly, or it
is too complex to be evaluated. For example, a numeric expression may
contain too many complicated elements. Try simplifying the expression by
assigning parts of the expression to variables."

I tried to put a break point on another Form but I did not get this error
,Any help will be appreciated.

Thanks In Advance

Wael.

It looks like your form needs to have focus in order to perform
calculation.

Regards,
Branislav Mihaljev, Microsoft Access MVP
 
B

banem2

I have noticed that the problem occurs after I set the default value to a
combo box.the problem is that I feel that the code is running in the
background even when the debug window is paused with a break point .

I Do not know if this will help you to analyze the problem

Thanks for your help

Wael


VBA code could not run when the VBA is at break point. First question
is: do you have calculation field(s) on form?

Regards,
Branislav Mihaljev, Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top