Search results

Okay, sorry to cause the noise, the issue was with the file name exceeding the number of characters I think, as when I renamed 2 of the csv files, it all worked perfectly :)

Okay, so I maybe getting there. I have created an import spec and named it "TextImportSpecs" I have created a table and named it "tblImportedFiles" Now the error message is "3011 could not find 'filename.cs' it appears to be losing the v at the end of .csv Private Sub bImportFiles_Click()...

Hello, I have a number of CSV files, which I want to import but I'm getting the error "3625 The Text file specification 'TextImportSpecs' does not exist. You can not import, export, or link using the specification" I have tried to tweak the code in this chain but as I'm using CSV not TXT...

Thanks Cronk, I have put this into a Module but get stuck on this line when I debug str = str&left(PCode, n-1) I've not done a module before, yikes. Anthony

Hi Cronk, I have a company name in 2 applications that don't match. I want to take the first 12 letters of the Account Name and add on the first part of the Post Code and then compare the 2. The data in the postcode is terrible and sometimes unpopulated. Where it's unpopulated I can use the...

Hi Cronk, Sorry for the delay, totally lost my access to our system ahhhhhh Is this what you need? SELECT IIf(IsError([Account Name] & " " & [Outcode]),[Account Name],[Account Name] & " " & [Outcode]) AS AccountName, Left([Postcode],(InStr(1,[Postcode]," "))-1) AS OutCode FROM CRM;

Hi all, I'm sure I used to be quite good at this but I appear to have forgotten everything :banghead: I'm having trouble with #Error in a query where I'm trying to bring in the Account Name with the Outcode at the end. When it errors, I just want the Account Name. This is what I have so far...

InStrRev Exactly what I needed, works perfectly. thank you stopher Anthony

Hi All, I've read a number of threads but still can't get this right. I want to return the characters to the right of the space but I'm getting back rubbish. This is the type of data in the field AccountName Z-Yachting Barcos y Apartamentos S.L 031 Zusi Ltd ST5 Leaders BR3 And this is the...

You're a gent.

I'm afraid E13 can be zero, I can ensure it's not Null but it's very likely to be zero. I shall read up on Nz. Although shouldn't it enter field G13 if it's zero?

Thanks again, I can't test it as I don't have Access at home, so to be totally thick, you mean: IIf(D13<0 OR E13<0 OR F13<0, G13, ([D13]/[E13] )*[F13]) becomes IIf(Nz(D13<0) OR Nz(E13<0) OR Nz(F13<0), G13, ([D13]/[E13] )*[F13])

That was very quick, thanks. I shall try when I get back to work. If D13, E13 or F13 are Null, will: IIf(IsNull(D13<0 OR E13<0 OR F13<0), G13, ([D13]/[E13] )*[F13]) simply work do you think?

Hi, I know there's lots of questions based around this and I'm still looking but haven't managed to find anything to exactly match my problem (although I'm sure it's easy). I'm trying to recreate an Excel calculation using Iif. In Excel I have: D13 E13 F13 G13 CALC Field 100 50...