What gives with Right string functions

[openurbanspaces]

I have built a database (on my laptop) that takes data from a spread sheet, uploads it into Access and the strips garbage out of the file. I designed it with Access 2000 on Windows 95. When I bring it into the office the office computers (Win98's) reject my 'clean up' query using (Right([bid]),4).

Why does this qork in 95 and not in 98???

 

[raskew]

Probably syntax.

try: Right([bid],4)

 

[openurbanspaces]

Sorry for the typo but still getting same error. I had in fact already listed as Right([Bid],4) to no avail. The error Im getting reads: Function is not available in expressions in query expression 'Right([Bid],4)'

 

[pdx_man]

This is a funky little thing that drove me nuts until I figured it out. Check out this thread.

http://www.access-programmers.co.uk...p?s=&threadid=34247&highlight=tools+reference

http://www.access-programmers.co.uk...?s=&threadid=39893&highlight=tools+references


The problem is that on your home machine you are referencing a library that doesn't exist on your other computer. Access hiccups and gives you this error.

 

[openurbanspaces]

The thread you sent refers to a form. Does this also apply to an append query?

 

[pdx_man]

Refers to any objects in an Access DB. You must look in a code module, under Tools ... References. Look for something Missing

 

[openurbanspaces]

I Finally found the missing element but when I changed it, my rtf conversion of reports from access to word seemed to become corrupted. Is this my imagination???
Jim

 

[pdx_man]

seemed to be corrupted

That sounds like being almost pregnant!

What do you mean by seemed? What were the symptoms?

What references do you and did you have when you look under Tools ... References in a code module?