Recent content by MajP

https://www.access-programmers.co.uk/forums/threads/date-pickers-calendar-controls-and-calendar-resources.315041/

It does not need to get modified. It works with all lists.

Maybe, but it is far less work to use. It is two lines of code to instantiate and use. Private Sub Form_Load() Set lstUpDwn = New ListMoveUpDown lstUpDwn.InitializeList Me.lstSort, Me.cmdup, Me.cmdDown, Me.cmdTop, Me.cmdBottom, Me.cmdDeselect End Sub

You may be interested in this class. It turns any listbox into a sorter. Has many features including drag and drop. https://www.access-programmers.co.uk/forums/threads/ms-access-custom-control-built-in-another-language.307414/post-1646046

To understand why this fails If CurrentProject.AllForms(stDocName).Visible Then The allforms collection returns a very different object then the forms collection. Allforms returns an AccessObject which is a very simple object compared to a form returned from the forms collection. It does not...

From copilot ' ========= Module: BigIntValidate.bas ========= Option Explicit ' Public entry point: ' Returns True if s represents a valid signed 64-bit integer (Access Large Number / BigInt) Public Function IsValidLargeNumber(ByVal s As String) As Boolean Dim sign As Integer, digits As...

https://www.access-programmers.co.uk/forums/threads/manipulating-an-independent-check-box-field-in-a-form.324720/ There are several different approaches here.

Do not believe that is a true statement. You cannot set the specialeffect of a button in vba. "Property or method not found". If so, can you provide an example demo?

I think the issue is with "use theme controls". Prior to that you could choose "Special Effect" for a command button of raised, flat, sunken. Although you can do that with most controls still you cannot do that with command buttons that use theme. I might be wrong but that property does not...

after But your options depend on what version you have of access.

Here is a very good explanation of how the OP does away with comboboxes. However, again the question is would anyone prefer this over a combox. Without seeing it in action it sounds as a less favorable UI. So again does the ease in development outweigh the less preferrable UI. However, I can...

Although the concept sounded interesting at first I lost interest pretty quick because lmb sounds like the guy pitching a Time Share presentation that you are forced to sit through to get the free weekend at the resort with the all you can eat and drink buffet option. Lots of platitudes and...

I do not interpret that the same way 1. You have cboCompany with company ID 2. You have cboOpportunity based on qryActivityOpportunity which has a foreign key to the company 3. You pick a company in cboCompany and want a message if no company in cboOpportunity Private Sub...

That sounds like a horrible idea to me, doing the opposite of what you should do. 99% of the time when you see a blank field in access it has a null value in it not an empty string. You have to jump through hoops to force an empty string into a field. So instead of defaulting to the thing that...

@Gasman This is legal getDaysSoFar (strPeriod) But this would give a syntax error getDaysSoFar (strPeriod, AnotherArgument) Although this would be legal getDaysSoFar (strPeriod),(AnotherArgument) The parentheses rules in VBA seem kind of arbitrary. But the reason why yours work (single...