Figuring out an array

[crowegreg]

I've inherited a module that includes an array that I can't figure out. Any explanation of what is causing a problem is greatly appreciated!!



Within the attached DB, the module reads the record from the table Monument_Current. Within 1 field, wbs code, the array breaks it down. It writes a new record into Monument_Current_Split.

I started with a spreadsheet that has 1900 records, and it works except for this record.

Thank you in advance

[June7]

I step debugged your code and get error: The field is too small to accept the amount of data you attempted to add.

on the line

wbs_rsAdd!Expense_Account_Unit = ARY2(ii)

and ARY2(ii) has value of

6707827-218800520

except the hyphen doesn't look like a hyphen in the intellisense popup.


You should have seen that error message as well.

[crowegreg]

Yes, I've received the error message. Thanks for providing me a greater detail as to what is causing the error.

Any recommendations as to learning more of how this array functions. I've looked at arrays on the Microsoft website, but they don't look like detailed.

[June7]

Nope, I figured them out by reading various sources, including MS Knowledge Base and trial and error.

[crowegreg]

Sounds like I have a fun night for me. I normally use F8(Step Into) to follow the code. How can I better see what is happening?

[June7]

Review link at bottom of my post for guidance on debugging techniques.

Here is another article from Pearson, one that probably helped me a long time ago http://www.cpearson.com/excel/VBAArrays.htm

[crowegreg]

Thanks. I figured out the problem. Within that field, the dash that was between "6707827 - 218800520" was CHR(150) rather than CHR(45). When I inserted a replace command, everything worked fine. Thanks for your assitance, and I'll review the links you've mentioned.