Search results

Hi I have a field, say ALFA, field size 3, type of value is text but some text contains 3 digits which i don't need to calculate so ALFA is text. I would like to make a query that filters these records where ALFA does have ONLY letters, not diggits. Example Record1, ALFA = ABC Record2...

Maybe i didn't explain it correctly In excell, i am at C2 cell and i can copy paste the C1 cell, if ... The cell above C2. C2=IF(A2=16,B2,C1) In Access query , i can't copy paste (repeat) the cell above. Can I ?

Hi In excel, say we are at C2 cell, we can make a formula like this: =if B2 is like this, then fetch B2 to C2, if not then fetch C1 to C2 =IF(A2=16,B2,C1) Could we make something similar in ACCESS queries ?

Okay Here you are a real example 001FCIU7196282NL572013 4510NFCY-CY N000840CT 11123504000000065380 GC11123500L572013 I have underlined or bold the pieces of string i want to separate FCIU7196282 is the container number L572013 is the seal number of the container, it may be...

Yes, there are more spaces between blocks of characters and yes, there may be three spaces

Hi, I have mastered the first "date" string problem. Thanks to everyone Now, i want from a field to use the MID function. Start from the 9th character(from lest to right) and stop at the first double space. Example the field is "123456789abc defg hzzzzzzz" return "ab cdefg". Note, between g...

Hi isladogs, apologies for being so perfunctory, you code works just fine. I took it wrong that "3" is the number of letters we have to remove from right side.

Hi CJ_London I get the below error message The expression you entered has an invalid.(dot) or ! operator or invalid parentheses. You may have entered an invakid identifier or typed parentheses following the Null constant.

December 10 2018 18:24:00 CST December 10 2018 18:24:00 CST EST Yes, because some records have more than three letters on the right end of string. Like the above example.

The -3 doesn't work because in some records would need -7 Yes, seconds most likely will always be 00

One problem is that "2018" might be 2019 and in few month 2020. So, could we replace somehow the string 2018 ?

Hi I have a text field as the below and i need to convert to date. How can I tell VBA to remove all data after third space? May 4 2018 12:47:00 CST ECT December 10 2018 18:24:00 CST December 10 2018 18:24:00 CST December 10 2018 18:24:00 CST November 30 2018 13:15:00 CST...

Gasman, i did this, the problem is that I can't remove the ACCESS from recommended, I can add applications but I can't remove from existing. So, two applications are recommended to open the xlsx files. By the time I try to open an xlsx attachmnent, MS ACCESS uses the wrong app to open it...

The problem is that in the "open with" .xlsx files, the excel is default but ms access is also default and I can't find some way to remove ACCESS from recomended

Hi there In one table, there is one "Attachment" data field type. I have uploaded some excel files and my problem is that when i try to open them, it uses the MS ACCESS application, file opens as an MS Access object, not as an excel... I can't find from which option i could fix this error.

I have been convinced that calculated fields on tables is a heavy database sin. It could make your life easier and then make your life hell. Suppose I have a table T and fields A,B,C,D etc I don't want to have A as calculated field but A takes date from B,C,D. I could create an...

Hi I made a test with 100K records, with one calculated field, it worked flawlessly, when I added a second calculated field, i took this file sharing lock count exceeded. Increase MaxLocsPerFile registry entry

Your comments are highly appreciated. One calculated field is like this IIf([TL] Like...

Hi I am building a new data base. I have created a table with more than 8 calculated fields. Some of these calculations include four or five IIF's and combination of three of four fields.The table will increase to 10000 records every year and there are around 30 fields. The table works just...

Thanks Ranman256, so, when I see ERP it is not just one specific software, There are many different softwares, ERP oriented. Same like a "spreadsheet", spreadsheet is not only excel although excel is the prominent one. I see some classified advertisements about job vacancies, they ask ERP...