Action Failed for extracting data to append on another table

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

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.

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

 

[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.

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

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.

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

 

[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).