VBA_SetAddr type mismatch

(0) Share

Report

Posted on by Q

900

In the process of upgrading SL 7. On one of the screens, I changed Call SetAddr(NOLEVEL, "bAccount", bAccount, nAccount, LenB(bAccount)) to Call VBA_SetAddr(NOLEVEL, "bAccount", bAccount, nAccount, LenB(bAccount))

But now I am getting "Type mismatch" on nAccount. Thoughts?

*This post is locked for comments

All responses (4)

Answers (0)

Q 900 on at

Like (0)

Report

Re: Re: Re: VBA_SetAddr type mismatch

Yes, I looked at VBA_SetAddr function definition and figured that out. Thank you all for the responses.
Community Member Microsoft Employee on at

Like (0)

Report

Re: VBA_SetAddr type mismatch

Hi,

Chris: You are correct. In SL7 customizations, VBA_SetAddr accepts only 4 arguments.

Please use the below syntax to resolve the "Type mismatch" error.

Call VBA_SetAddr("bAccount", bAccount, nAccount, LenB(bAccount))

Thanks & Regards

D.Santhosh
Chris Schack on at

Like (0)

Report

Re: Re: VBA_SetAddr type mismatch

Hi Q,

I beleive that the VBA_Set Addr statement has changed recently and it now only accepts 4 arguments. See below for an example:

Call VBA_SetAddr(TableNameStr, bTableName, nTableName, bTableNameLength)

Hope this helps.

Thanks,.

Chris Schack
pbrattin 1,850 on at

Like (0)

Report

Re: VBA_SetAddr type mismatch

Do you have the DH file for the Account table in your VBA program? That DH file sets the Type for the table.