H
HankO
I am trying to import the summed value from an Excel
workbook (coinciding with a table I have linked) to a
form's text box used as a base in other calculations on
the form. I set the Control Source to that cell, but get a
#Name? Error in the text box. What should I have as data
type? I have tried Decimal/2 places, General Number/2
places on the Access end; General Number and Fixed on the
Excel end. How do I resolve this to get the value to
display and integrate with the other (simple)calculations?
workbook (coinciding with a table I have linked) to a
form's text box used as a base in other calculations on
the form. I set the Control Source to that cell, but get a
#Name? Error in the text box. What should I have as data
type? I have tried Decimal/2 places, General Number/2
places on the Access end; General Number and Fixed on the
Excel end. How do I resolve this to get the value to
display and integrate with the other (simple)calculations?