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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
String longer then 256 in string does not insert or update
Hiya CautionMP, I used your suggestion and it works (2003). Thanks a lot. rjoubert tried yours and it didn't work. Thought I'd let you know. FYI I'm creating my own DVD database as I have a huge collection and have lost the overview. Again guys/girls thanks a lot. Jane :-)- CodeJane
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
String longer then 256 in string does not insert or update
Hiya everybody, I have a memo field in a table. In my code I do an insert with variables coming from the form. However, the system cuts the long string (memo). Here is what I have done (rather simple actually): 'first I do an insert addDVDSql = "INSERT INTO DVD ( Title, Actor1, Actor2...- CodeJane
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
