"Func Not Avail" Error Message

[canadaboy]

I have a database (2000) whose code works fine on my home computer, but not when I brought it to work to begin implementation.

I make the following assignment in code in a Form-Load event:

Forms![Experiment_Num_FRM]![TestNumber] = LastTestNum

[TestNumber] is a textbox and LastTestNum is declared as an integer in the Form-Load event. When this line of code executes it gives the following error message:

"Function is not available in expressions in table-level validation expression"

Can anyone offer any explanations and/or work-arounds to what is happening??????

 

[Pat Hartman]

This is most likely a references problem. If you don't know what I'm talking about, search for MISSING references and you'll find lots of help.

 

[canadaboy]

It makes sense. I printed the references box from the computer at home and I'll compare it with the one at work tomorrow. In searching other threads I saw a few cases where people complained that it fixed the problem, but that the references needed to be updated with every use. I guess I'll ask that question if it happens. I'll let you know.

 

[canadaboy]

I unchecked the "MISSING" reference (CompatUI 1.0 Type Library) and the database works fine, even when I shut down and start up again, so I should be ok.

I was not able to find the library or reference in the list when I went into check the references again though. Does that mean that the database never needed that reference? If the reference was not needed in the first place, why did certain functions fail, [ie. left()]?

 

[Pat Hartman]

Sometimes you add something that needs a particular library and then delete the code/object but the library stays selected. When Access starts it attempts to resolve all references as soon as you do something that involves any code. That's why reference issues normally show up as seemingly off the wall problems. The real problem is almost never apparent since the code that tirggers the error is random.

 

[canadaboy]

Thanks Pat.

It seems like you have personally saved several of my problems. You should go into psychology.

I think I found another issue that might need your consultation, but I'll start another thread.

Thanks again.