Search results

Hello, I have a runtime error when using a DLOOKUP function. The code is following : StrValue = DLookup("[English]","LanguageTable","[German]=German") StrValue = DLookup("[English]","LanguageTable","[FieldRef_123]=Abc") it is indeed strange, but the first line is just to show that it works with...

Hei, I’d like to mark the difference between two text boxes. I have the following code to open and compare the text but I don’t know how to change the colour of the letter/character which is checked different. The .selcolor method and Selection.font.colorindex don’t work, the .forecolor isn’t...

Hello, Before I dive into finding the solution, I'd like to know whether it's possible to create columns in a text box? The idea is to show the history of changes of a text box (Rich Text formatted) with the old value on the left and the new value on the right. Something like: Changes on...

Hello, I have a continuous form on which the user can navigate through record. When found, the user can click on a record to view or edit it (nothing new here). The continuous form (let’s call it LogHeader) is a subform of a form (LogList) and on the form there is a header than contains...

Hello, I have a report (ReportMain) with two unbound subreport (Sub1 and Sub2). I would like to create the report through VBA so that the user can input custom date (field Date/Time of the table Log). when using the VBA code docmd Openreport, I can pass the condition to the whereCondition. It...

Hello, I would like to create a report with the attachments of my database. But I would like to have the attachments at the end of the report instead of having them together with the records they are linked to. This is to ease the reading of the report as the attachment will be full page and...