Search results for query: *

I have code that will find the number of .TXT files in a folder. I normally only process the one that is usually found in the folder, but I need to know how to process as many .TXT files as are found. Has anyone done this before? Here's the code I use to identify ONE in the folder. Public...

I used to manage hockey! I have another question about importing so I'll post a new thread here in a sec.

Ignore me. That won't work. I better get some rest now.

You can try Set variableX = 5, but that will make an assumption about the data type, if that's OK.

Mike: I tried and it would even compile LOL (but then we all know the kind of day I'VE had)

mike777: You sure have a way of calming down a hysterical programmer-in-distress with your demeanor. Thanks a million!

scriverb: I'm in beautiful Toronto, Canada. Great selection of beers here.

I GOT IT! No syntax errors, and it INSERTS perfectly. Here's the full SQL (I had narrowed it down to two fields for simplicity earlier). The trick is to put SINGLE quotes AROUND the double quotes, like: '" & variable & "' so here's my new code: db.Execute "INSERT into...

I GOT IT! No syntax errors, and it INSERTS perfectly. Here's the full SQL (I had narrowed it down to two fields for simplicity earlier). The trick is to put SINGLE quotes AROUND the double quotes, like: '" & variable & "' so here's my new code: db.Execute "INSERT into...

scriverb: I'm not getting a syntax error any longer, BUT nothing it making it to the table. No message, nothing.

scriverb: Yes that's what it looks like

Mike777: I tried: I would say: db.Execute "INSERT into tblAAAccidentTemp(OldAccountNumber,RejectCode) values ('123456789111','SomeString30CharactersLong')" or: db.Execute "INSERT into tblAAAccidentTemp(OldAccountNumber,RejectCode) values...

scriverb : That's correct. It's like a "remarks" field. Sometimes it has text in it, and sometimes it doesn't.

mike777: I'll try that right now and let you know. I REALLY appreciate everyone's help and I hope I get through this.

jiqjaq : I had tried that as well, since that's the way I used to always do my SQL. It still didn't work. That's why I've been going mental over this today. Nothing seems to work.

scriverb: I still get the SQL syntax error. The field AN has numbers in it (which looks ok on the watch..it has quotes around it. The field "RC" is blank on import, but it also appears like a proper text import with the quotes around it

Quehay: I tried that, but it still won't work. I've done this a million times before, so I just don't know what the problem is?!?!?!?!

I'm getting a syntax error on the SQL below now and after staring at it for FIVE hours now I'm about to go mental. Can someone help me please? Public Function ParseAndStoreAADetailRecord(GFile) On Error GoTo Err_Handler Dim db As Database Dim AN As String Dim RC As String Set db =...

Can anyone please fix this syntax for a reasonable fee? At this point, I will pay for it, as I'm TOTALLY stuck in my tracks here.

Thanks Bob: I tried adding the space to after rejectcode), I tried adding it to before Values, I've tried EVERYTHING and I'm going mental here. I'll PAY someone to get this to work at this point!!!!!!