Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Reserved Error (-1517)
LittleSmudge - Thanks for your help! Yes, that field is the Primary Key, but it doesn't appear to be trying to add a duplicate value. Plus, I'd expect to get a regular Access message if I tried that. You're right, I should have copied/pasted the code. I re-checked, though, and no typos...- HokieFan
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Reserved Error (-1517)
I received the following error message: Run-time error '3000': Reserved Error (-1517);there is no message for this error. Clicking "Help" reveals that there is no help for this error. Here is the code that produces the error: dim db as Database dim rst as Recordset dim strName as...- HokieFan
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
TransferSpreadsheet and datatypes
I just ran into this same problem. Based upon what you said in your question, I changed the first cell of data in the field in question from numeric to text by putting a single quote at the beginning. Not pretty, but it worked.:-)- HokieFan
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
