Trim Command in a Query Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

To All on MSDN Access Query Newsgroup:

I have an Access query with one field that is a concatenation of fields using the Trim command. I had no problem with this query on any machine in my office. I then tried to duplicate this query at a remote site but I kept getting an error message in this query field in Datasheet view. I narrowed down the error to Trim command. The Datasheet view for this field displayed #Error. Does anyone know why this error would occur with the Trim command? Any help or hints on this topic would be greatly appreciated. Thanks in advance.
 
When commonly-used functions work fine on one computer but fail on another,
the cause is frequently a missing reference on the computer displaying the
failure.

At the computer where the function is causing a failure, open any code
module and then click Tools|References. Look for any that are marked
"MISSING:" and if you find any so marked, you will need to re-set them.
There is more information regarding references at the following links:

http://allenbrowne.com/ser-38.html

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html


--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Michael Volz said:
To All on MSDN Access Query Newsgroup:

I have an Access query with one field that is a concatenation of fields
Click to expand...
using the Trim command. I had no problem with this query on any machine in
my office. I then tried to duplicate this query at a remote site but I kept
getting an error message in this query field in Datasheet view. I narrowed
down the error to Trim command. The Datasheet view for this field displayed
#Error. Does anyone know why this error would occur with the Trim command?
Any help or hints on this topic would be greatly appreciated. Thanks in
advance.
 
Back
Top