Search results

Good evening all! I use the following Ribbon XML code in a UsysRibbon table. I got it from these forums. I need to remove the (File) menu and also to remove the title that appears at the top of the database (which displays the file name and path). Thanks in advance <customUI...

I'll try your kind suggestions. Many thanks

this: DoCmd.RunCommand acCmdFilterMenu is a part of the function (Filterform) this recalls the standard filter that's found just on the right top corner of a field. I think the idea will be clear only when you have a look on the database

Thanks for your prompt reply. An image attached.

Attached a sample database. In form (expense), the combo box (expense_item) collates data from (expenses) table and (revenues) table. There's a filter button on form header. it shows only the contents of (expenses) table to which the combo box is bound. I hope it's clear now

Good day! I use the follwoing code to filer a filed on a form Public Function FilterForm() On Error GoTo errlbl Set SelectedButton = ActiveControl Me.Controls(ActiveControl.Tag).SetFocus Me.Recordset.MoveFirst DoCmd.RunCommand acCmdFilterMenu Exit Function errlbl: If Err.Number =...

I works fine. Thanks for everyone

Attached a sample form (form1) with the text in footer section. you will notice the huge gap between the detail section and footer seciton.

Thanks all. I'll check out. Best regards

Good day everyone! I need urgently to remove the gap between form detail section and form footer, either by vba code or changing the properties. Need your urgent help please

Great. Everything is OK now. thank you very much

I've created the Newmenu using the above code but I'm talking about the case upon deploying my program on another machine in which the office 16.0 reference is not activated. i.e. every time I place my program on any other machine, I need to enable the reference manually. In case of my absence...

This code works perfectly, but the issue is that it needs office 16 library reference. On implementing my project, user will need to add it manually. Is there any VBA code to add (Microsoft Office 16.0 Object Library). Thanks in advance

Thaaaaaaaaaaaaaaaaaanks for all

Good day very helpful people! I've a custom shortcut menu bar in my reports. I need to add a button that prints directly (2 copies) to default printer. I've tried the code: newMenu.Controls.Add(1, 15948, , , True) newMenu.Controls.Add 1, 12499, , , True But both lead to a dialogue box. Any...

Yes, it works fine now. Thanks alot

Good day! if a text box property includes "can grow" then its border appears taller than other textboxes, how to dynamicllay change the height of remaining text boxes in the form where a text box height changes?

Yes. I'm sure. (keyDown) event.

Good day gentlemen! I'm using (F6) key with fields on form for specific purpose. it works fine with textboxes but doesn't work with any comboBox? Here's my code If KeyCode = 117 Then dosomething End If Any ideas!!!

Thanks great people