I have a function which is reading in numeric values from a large excel spreadsheet into access, once I get everything in, the function sorts them and updates the apropriate tables and values.
The problem I'm having is that some of my users don't always follow the rules on values and will put text strings in when a number isn't applicable.
Currently this causes a break error and I lose that line of information. What I'd like to do is have the function recognize there is text in there and set the value to something else. is there a way to do this in vba?
The problem I'm having is that some of my users don't always follow the rules on values and will put text strings in when a number isn't applicable.
Currently this causes a break error and I lose that line of information. What I'd like to do is have the function recognize there is text in there and set the value to something else. is there a way to do this in vba?
