Search results

Thank you so much. This is exactly what I was looking for,

Hi there, I have a main form (Daten) with a sub form (BewerberUF) in my database. The sub form is shown as a table. In the sub form one of the columns ("Ausgewählt") is made up of checkboxes. Is there a way (possibly with a command button) to loop through one of the columns and set all the...

Thank you for the many tips. I finally got it to work by inserting the code If Len(Me.txtSuchen) <> 10 Then Exit Sub into the module. Thanks again.

I have a Date Picker on my form to jump to the record that corresponds to the date in the Date Picker using the change event As long as I select the date with the date picker, everything is Ok. If I wish to select a date by typing it in manually, I get an error message because the change event...

Unfortunately, still getting the same "with block" error.

Thanks for the quick answer. Unfortunately trying to invalidate the ribbon invariably causes an "object variable or with block variable not set" error.

In my custom ribbon I use the getLabel function to write data to a button lable. Sub GetLabel(control As IRibbonControl, ByRef label) ' Callbackname in XML File "getLabel" ' To set the property "label" to a Ribbon Control Select Case control.ID Case "Btn_25" label =...

Thanks for the quick reply. Unfortunately the problem remains. The message box always appears when cycling through the records even if the date in the form field is not in the public holiday table.

Hi there, I have a split database. On the backend there is a linked table with all the dates of the public holidays occuring in the next few years. The table is called "ArbFreieTage" and the column with the dates is called "Datum". When I open the form "Außenpforte" I would like to check if...

Open your form in design view and open the property shhet. Select the "All" tab and scroll down to "Name of Ribbon". Select the custom ribbon you would like. When you now active the form this ribbon will always be displayed.