Copying VBA from one workbook to another not working

Hello. I am still relatively new to VBA, but I am having a problem copying a working VBA script from one workbook and having it work in another.

It is a simple code that takes 85 fields in one workbook and sends it to an access database. The code works fine in the original workbook. Once I copy it over to another wookbook, I start getting "Type Mismatch" errors. The code (in the new workbook only) gets tripped up when the value entered is text. When I delete out the text and put in numbers as a test, a blank error box appears and nothing gets sent to the access database. I checked the access database, and the field in question is text, so the text in excel should not have been a "mismatch" in the first place.

It seems so simple but it is driving me bonkers. Any ideas?

The code is below:

Please Login or Register  to view this content.