Error out of nowhere

[polina]

I have this string assigned to the variable in the query:

strFullName = Trim$([BlackBerryRecord].[LastName]) & ", " & [BlackBerryRecord].[FirstName]

It worked find, but all of the sudden started given me the error FUNCTION ISN'T AVAILABLE IN EXPRESSIONS IN QUERY EXPRESSION ' Trim$([BlackBerryRecord].[LastName]) & ", " & [BlackBerryRecord].[FirstName].'

Why did it work before and does not work now? What could have gone wrong with query?

Please help

Thanks

 

[DES]

Possible reference problem

Have you moved the database to another computer?

 

[polina]

No...but I've replaced the table that was used in the query with a table from another db....

 

[DES]

Structure changed?

Has the structure of the tables changed between the two tables?

 

[polina]

No, ... it is the same structure

 

[DES]

Confidential

If it is not confidential information you could send me the database and I will have a look at it for you.

 

[polina]

ok,

table and a query is in db attached

 

[DES]

wrong table

does not include the Blackberry table so the query is no good

 

[polina]

Well, sorry....i just renamed BlackBerryRecord to Record........if you rename table back to BlackBerryRecord......then query will be good

 

[DES]

Did you realize

That there was another table being looked for in this query. It is a table called Configuration. Once that table has been removed from the query and the $ taken out of the Trim equation you are fine.

 

[polina]

But i need to have Configuration table involved in this query.
And this query worked fine before.....what is wrong with TRIM$?

 

[DES]

Not sure why

Trim$ returns a String while Trim return a Variant. That seems to be making a difference in your equation

 

[polina]

I have just tried TRIM......removed Configuraion table........it still gives the same error....

 

[DES]

Hmmm

It is working here. Check to make sure you have all your references and nothing is missing there.

 

[polina]

You were right ...it was the references problem
I have installed SQL Server recently and after that TRIM$ function stopped working. So I had to refresh references used in my Access application. Now it works fine.

Thank you very much for your help. I appreciate it a lot.