VBA modification error

(0) Share

Report

Posted on by Community Member

I've made this little modification to "Sales Documents Print Options" screen to default 'Currency to Print' to Originating. This works and does what intend it to do.

But now, when I open 'Sales Transaction' Window and click on the print button (without opening any sales doc) it brings up the Print options screen with a Run-time Error, below

1222.error.JPG

it says that we've set a default value to a disabled field.

this is not a hindrance to day to day work but still is there a way to remove this ?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Tim Foster 8,515 on at

Like (0)

Report

RE: VBA modification error

<Content Removed>

Was this reply helpful? Yes No
Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: VBA modification error

Do you have Multicurrency Installed or not?

Please reply this first and do not try to unlock /Enable any field which is locked by gp default procedures, it will mess up things.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: VBA modification error

yes we have multicurrency installed

Was this reply helpful? Yes No
Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

RE: VBA modification error

How you checked it?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: VBA modification error

I know for a fact that we use multi-currency and we have it enabled

Was this reply helpful? Yes No
Verified answer

David Musgrave MVP ... 14,069 Most Valuable Professional on at

Like (0)

Report

RE: VBA modification error

Hi Sinnerv

You can only change a value of a field that is editable.

You might need to check if the field is enabled first and wrap your code with an If then Endif.

If CurrencyToPrint.Enabled = True Then

CurrencyToPrint.Value = 2

EndIf

David

PS: You might want to use the AfterOpen event rather than AfterActivate. Activate occurs every time you click on the window after being on another window.

Was this reply helpful? Yes No
Tim Foster 8,515 on at

Like (1)

Report

RE: VBA modification error

David has the correct answer here. Sorry for my original answer.

Tim

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: VBA modification error

Thanks

I figured this out :)

works alright on AfterActivate, however I'll take your advice and change it to AfterOpen

Cheers

Was this reply helpful? Yes No