Action Failed for extracting data to append on another table

S

Siew-Ming

Hi,

One of the strangest things I come across. Tested fine on my workstation.
Executed the same macro on another workstation which has the same version of
ACCESS 2000 (9.0.2720) and ran into this error "Function is not available in
expressions in query 'RIGHT([tblname!fieldname],7)'."

Any ideas will be greatly appreciated.


Thanks,
Siew-Ming
 
D

Dennis

It is missing a reference. Go into any module or code for any form and select
Tools, References. Uncheck any that have missing against them.
 
S

Siew-Ming

Dennis,

I just checked the references on both machines, they look identical.

VB for applications
Microsoft Access 9.0 Object Library
OLE automation
Microsoft Active X Data Object 2.1 library
Microsoft DAO 3.6 Object Library

Something is still missing.

Siew-Ming

Dennis said:
It is missing a reference. Go into any module or code for any form and select
Tools, References. Uncheck any that have missing against them.

Siew-Ming said:
Hi,

One of the strangest things I come across. Tested fine on my workstation.
Executed the same macro on another workstation which has the same version of
ACCESS 2000 (9.0.2720) and ran into this error "Function is not available in
expressions in query 'RIGHT([tblname!fieldname],7)'."

Any ideas will be greatly appreciated.


Thanks,
Siew-Ming
Click to expand...
Click to expand...
 
J

John Spencer (MVP)

They may look identical, but I would still uncheck one, close the window, reopen
it and recheck it. There is a good probability that there is a difference you
are not seeing.

Siew-Ming said:
Dennis,

I just checked the references on both machines, they look identical.

VB for applications
Microsoft Access 9.0 Object Library
OLE automation
Microsoft Active X Data Object 2.1 library
Microsoft DAO 3.6 Object Library

Something is still missing.

Siew-Ming

Dennis said:
It is missing a reference. Go into any module or code for any form and select
Tools, References. Uncheck any that have missing against them.

Siew-Ming said:
Hi,

One of the strangest things I come across. Tested fine on my workstation.
Executed the same macro on another workstation which has the same version of
ACCESS 2000 (9.0.2720) and ran into this error "Function is not available in
expressions in query 'RIGHT([tblname!fieldname],7)'."

Any ideas will be greatly appreciated.


Thanks,
Siew-Ming
Click to expand...
Click to expand...
Click to expand...
 
V

Van T. Dinh

This is not the cause of the problem you posted but the Field reference is
incorrect. It should be:

RIGHT([tblname]![fieldname],7)

(square brackets added).
 
Top