Macro generating an error - Totally Confused

[siena]

Hi everyone,
I have a macro that allows users to print reports.
The macroname is my$Macro
Action name: OpenQuery
Arguments are: upd$AmountsPC-1,Datasheet,Edit.

It works in some users machine but in others, they just get an error that says:
Action Failed, then it goes on to list macro name, action, etc.
I am so confused as to what the problem is.
Can anyone please, please help.
Thanks

 

[EastWind]

Could you go to the SQL of your action query and post it?

 

[siena]

Hi,
This is the sql:

UPDATE tblPCardExp SET tblPCardExp.[CertMFBE$] = Null, tblPCardExp.[Non-CertMFBE$] = Null, tblPCardExp.[NonMFBE$] = [$ Amount];

 

[EastWind]

I have no definitive idea about what is going-on, but a problem that I've run into before is UPDATEing columns of data-type Text to NULL; sometimes (I don't know when exactly), I must UPDATE to "" (empty text string).

Also, part of your argument list is upd$AmountsPC-1; to which arguement does this correspond? If it is a table name, is minus one (-1) part of the table name?