Recent content by mfougere

Excellent, that worked like a charm! Thanks CMP that's a load off my mind. Now I just have to do some error trapping so I can use an update statement if the interface_num is already in the database and I'll be rockin and rollin! I'm still going to try my old code on my home computer this...

Hey Uncle Mike, I have the fields defined as text fields in the Access Database since this is only intended as a tool to track documents and the real meat of the info will reside at the document level. The problem I'm having is that I can no longer even get my info to the DB since the String...

Hi CMP, I get the following error when I try to step past the .AddNew line. run-time error '3251' application-defined or object-defined error Any ideas? Thanks again for helping me, Mike

Thanks CMP, I'll try that right now. I was thinking of some crazy update messing with me but at my company I have no control over that stuff, it just gets pushed out every couple of weeks. I'll let you know how it goes and thanks again. -Mike

Yes, I just checked the value, and if I take the value down to only a few characters, it will get the full value into the string, but it simply truncates the next value (Range("F" & I).Value) so that once again, the string is only 255 characters long. Bizarre isn't it? I was wondering if there...

Since the insert statement is really just one line, it truncates immediately as you F8 through the line. The value that it gets truncated at is usually the Range("E" & I).Value point, but that's only because that's where the string maxes out at 255. If I remove a bunch of columns and have little...

Hello, I'm trying to use and sql query to insert data into an Access database from an Excel spreadsheet. For some reason, code that was working last week now seems compelled to truncate my string to 255 characters. Here's my code, does anyone see anything wrong? As I said, it was working last...