Search results

Yes i have, i have removed the entire data and tried to "import" , no way , i think the problem must be the "with attachment" record because same problem was encountered in another two tables that were "with attachment" field.

Hi, no multiple value fields but "with Attachment" which i haven't used, maybe there is one pdf somewhere, i will check . It is my application at home pc which oi office 19, i ll chack the exact version. I ll try to remove the attachment field and chack again.

Hi, very strange I have recreated the tables in my new db from scratch, but, just for the history, i tried repair compact, no import, i tried without data, nothing, i removed all records from source db, again invalid argument

Hi There I am trying to transfer two objects in my new database for 2022, while many other objects have been transferred without hassle, there are two tables that i get invalid argument, i tried to transfer in another testing db, same problem ?! What could be wrong ? Now I will recreate from...

Hi there With docmd.transferspreedsheet, we can import a spreadsheet in our table. So far so good. Could we import a spreadsheet on a child table that requires generation of key that is linked to the PR.key of mother table ? So far, i use the primitive method, i display the excel that i want...

Hi, the + , no, i typed it manually just to show the parts i copy paste, the data are always on the same position and with string functions you can remove not needed and keep the good stuff.

Hi , no it is not from website, it is from our online application that we can retrieve and upload data. This environment is strictly used by employs.

Private Sub CoPast_DblClick(Cancel As Integer) Refresh If Not IsNull(voy) Then MsgBox "hey there" Else voy = "AIG-" & Mid([CoPast], 11, 3) & "-" & Mid([CoPast], 37, 3) & " " & Mid([CoPast], 40, 1) vess = Trim(Mid([CoPast], 17, 20)) eta = Mid([CoPast], 46, 2) & "/" &...

Have a look 11HIGH CARBON +TBF+ CONTSHIP ECO +190S+ 210505210506 001+BSIU2872993+N4960338 +2210+NF+FI-CY+ N000027BM 26920002000000000000 GC269200004960338 I have typed manually the + Now, the first, i must make the voyage number which is the first bit TBF and the 190S ...

The first info piece i can copy from our only application, it is a very large line with many piece of info in bulk but always on standard position. Yes, i can copy paste the bits i want manually but this is a bit of a pain and I must be very careful/precise in order to collect the bits I want-...

Hi, i have tried this already, in the test database, it worked, HOWEVER, in the main DB, one field that i want to paste, is the primary key, i can't change primary key now. So, i can't paste it in the record (at help field) because i must type the pkey first. So i wonder IIFthere was a chance...

DoCmd.RunCommand acCmdPaste Hi, could we add string function on the above line? For example, we copy on our clipboard one large piece of info, say 100 digits but paste on the field only the Mid(clipboard, 18,5)

Hi DB guy The goal is how to export one excel with two pages by using just one command. So far, I can export several business reports from Access to excell with he perfect format, then, manually i add one or more sheets to main excel document and I am done. Where should i use this add...

With .Range("J10:J" & i).FormatConditions.Add(xlCellValue, xlEqual, "=""F""") .Interior.Color = RGB(150, 150, 50) End With Hi there, the above code works just fine. However, my goal is to apply format on the condition that the field is NOT equal to "P" or "C" I...

Hi there I have two controls in a form that i have locked (enabled yes) . In some cases, i have to copy paste manual data from one control to another while for other cases this is not needed. To avoid manual copy paste, i have written the below code in which, i set focus on one control, copy...

Hi, yes okay , i edited first message to include the code into </>

Okay, i found it, It was a typing error, Anyway, is there any smart way , tool or something, that we could use in order to compose flawlessly such lines ?

Yes, i is a number that counts records i = 10 then i = i + 1 But, since i works on the first part of the formula, why doesn't work on the next parts ?

Works .Range("E7").Formula = "=SUMIFS(I10" & ":I" & i - 1 & " ,D10" & ":D" & i - 1 & " ," & """OFT""" & ",F10:F2500," & """USD""" & ",J10:J2500," & """P"")" Doesn't work .Range("E8").Formula ="=SUMIFS(I10" & ":I" & i - 1 & " ,D10" & ":D" & i - 1 & " ," & """OFT""" & ",F10" & ":F" & i -...

Hi, not exactly, this convert a string that represent a number to a number For example =VALUE("$1,000") converts to 1000 In my case, i have a cell 15 t (stands for 15 tones) , i cannot make calculation with only the number in it.