getting error 3075 on one PC only (Function is not available in expressions in query expression

[avayaman]

This is only happening on only one laptop, the program runs fine on every other one I have tried.

Error message: Function is not available in expressions in query expression 'Duespaid>Date() AND status="In Default"

This is the hunk of code it is hanging up on

sql = "UPDATE tblAddies SET status-'Active'" _
& " WHERE Duespaid>Date() AND status="In Default'"
DoCmd.RunSQL sql

The last line is yellowed out

Access 2033 on a win 7 64 bit machine.

There are several similar segments in the same routine and it goes through them before hanging up on this one.

Paul Beddows

Consulting, Avaya/EAS implementation, Training
Vancouver, Canada
E-mail paul at natcoa.com

 

[PHV]

No misssing reference ?
Does the project compiles properly ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[avayaman]

yes I suspect missing references from looking at another thread. The project does not compile properly, but it has been in use for a long time so i am not quite sure that to do about that. It gets hung up on quite a few lines that appear OK on the surface

Paul Beddows

Consulting, Avaya/EAS implementation, Training
Vancouver, Canada
E-mail paul at natcoa.com

 

[avayaman]

compiling hangs on this line for example

Me.lblWarning.Visible = True

Paul Beddows

Consulting, Avaya/EAS implementation, Training
Vancouver, Canada
E-mail paul at natcoa.com