Activity Stream

Hi Davegri, I'll answer the questions, but CJ_London gave me everything I needed. 1. F1 and F2 are fields that are in the "ZAPR*_csv" files. They...

Hi CJ_London, Thanks so much. This works, with one change. The fields didn't concatenate, but I can do that once I get everything all in the...

No, no. Don't know what your error message about a collection is all about, but it certainly isn't stating you need a collection for this. Please...

don't know who's telling you you need a collection, certainly not here. your brackets are all wrong, and I'm not at all clear why you are...

I'm not sure I'm understanding your requirements. I'm guessing your linked table is an xl file or csv. What exactly is your long text field?...

Ok I give up. I'm going a different direction now. I'll just import each field F1, F2, and the variable FieldName. I thought it would be a simple...

Hi thanks for your help, but I don't understand why examples of F1 and F2 are needed. This is proprietary information. They are both field names in...

Thanks moke123, Yes, both F1 and F2 fields are Short text. The field I'm appending to is long text. I'm hoping this isn't an issue. I tried the...

Assuming they are strings. Sub ConcatSQL() Dim F1 As String, F2 As String, strSQL As String, Filename As String, fieldname As String F1 =...

if you have 25,000 rows, I would expect your sql to have select and from parts can you show some example data and the result required to insert...

Welshgasman Well I read Normalization Parts I, II, III, IV, and V, got a lot more to read for that Post. Can you tell me if there is away in...

You are putting single quotes around the concatenation. Do not even try to run the sql until you get it correct. Show examples of f1 and f2.

I have an SQL that runs but it is not working correctly: strSQL = "INSERT INTO IT_Orig_Data (,) VALUES ('F1 & F2', '" & FieldName & " ');"...

1. Turn off warnings until you have resolve the issue 2. use debug.print sqlstr to see what it looks like before you run it

Assuming those fields are text I would think it should look more like strSQL = "INSERT INTO IT_Orig_Data (AllFields,FileName) VALUES (""" & F1 & "...

Thanks so much Welshgasman, I've printed the below: INSERT INTO IT_Orig_Data (,) VALUES ('ZAPR003_P9006_csv 'F1' & 'F2', ZAPR003_P9006.csv...

Debug.print strsql and check it is correct. Looks like you also have an errant single quote? No continuation character and " in incorrect placement.

If every tube is a record, the coil serial number (or perhaps better, the pk from the coil table) would have to be part of that record. If not, then...

shorter - If estimate status is complete, a completion date is required. No need to say please - just do what I say because I'm the...

We take steel coils and convert it into tubing. What we used would be a coil and what it made would be a bundle of tubes. I can't provide a copy of...

Agree with CJ and would also suggest a copy of your database and instructions to pinpoint the issue. Also helpful if you provide a description of the...

probably, but not enough information to know whether your present structure could do it. Also need a more detailed explanation of what you mean by...

Not enough info but if you are only putting in the footer, maybe that is the issue. Are you grouping by Quarter, you could put the Quarter totals and...

I went with: "You have marked the Estimate Status as 'Complete', however the Actual Completion Date has not been entered. Please enter the...

Or "Please enter the Completion Date to complete this request."

Maybe this: r = MsgBox("You have marked the Estimate Status as 'Complete', however the Actual Completion Date has not been entered. Please enter...

The straight answer would be ... strSQL = "INSERT INTO table1 (...) SELECT ... FROM table2 WHERE Col3 = " & ICount ...