AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 2,099
- Office Version
- 2019
- 2010
- Platform
- Windows
I've opened a connection for another workbook to copy it's data to my worksheet.
It's almost working but one column called "Time" is only copying some records. Those it skips give
Run-time error '3349':
You cannot record your changes because a value you entered
violates the settings defined for this table or list (for example, a
value is less than the minimum or greater than the maximum).
Correct the error and try again.
However I cannot get to the value to do that e.g. Debug.print rst![Time] just repeats the error.
The format for the source cells shows Time Type 13.30 and the target cells are Custom Type h:mm
My question is why does it work only for some, and what might work to fix this ?
It's almost working but one column called "Time" is only copying some records. Those it skips give
Run-time error '3349':
You cannot record your changes because a value you entered
violates the settings defined for this table or list (for example, a
value is less than the minimum or greater than the maximum).
Correct the error and try again.
However I cannot get to the value to do that e.g. Debug.print rst![Time] just repeats the error.
The format for the source cells shows Time Type 13.30 and the target cells are Custom Type h:mm
My question is why does it work only for some, and what might work to fix this ?