"Numeric field overflow"????

[Roach]

Greetings all,

There are times when I'm running a certian macro (to update tables and spreadsheets) and the message "Numeric field overflow" pops up. After that the macro cancels and I can't update what I need.

Does anyone know why this happens and if there is a way to prevent it?

Any feedback will be much appreciated. Thank you very much.

Peace,
Roach

 

[jeremie_ingram]

I encountered this problem a few times myself. Are you linking to an outside data source? If so, try importing the data into the database, then link to the tbl. Amother trick to work around (doesnt always work) is to conver the macro into VB code.