Recent content by MajP

That is opposite of what you should be doing. Pop up brings it in front, and modal restricts leaving it. A Popup form floats above all other Access windows. What Popup does The form becomes a top‑level window, not embedded inside the Access application window. • It stays in front of...

In early vba it was common to see people do the opposite and not use functions but only sub routines. There was heavy use of In/Out parameters. I use to see it quite often and was always confused. I believe this was leftover habits from early limitations in VB and similar use in windows API...

According to Chat, what I guessed was wrong. It should display 15 digits. So no idea, but you could still try forcing the format.

My guess is you need to force the format property to something. I am not sure what. I am guessing all needed ####. But my guess without a default format specified it is limiting it to 13.

That is Copilot. It is kind of mind boggling how clear and concise it is. So somewhat related question I had is why you can use TempVars in a query and not a VBA variable. It is also related to above. Access looks inconsistent here at first glance, but once you understand which engine is doing...

Somewhat unrelated but explains some quirks in Access. This took me years and years to understand. For example in an property if you can specify a Function but not a Sub even though you are doing an action and there is not even a way to use a return value if you wanted. Example in a controls...

There is no performance difference, but provides clarity in your code. Function - I intend to return a value Sub - I am intending to do something. KitaYama's, thread shows there can be a few unintended consequences because something is always returned from a function even if you choose not to...

Here is an example of "editable" form based on a cross tab. https://www.access-programmers.co.uk/forums/threads/i-need-the-minimum-value-among-5-different-fields-in-one-record.334251/post-1966766 I did a presentation on this with other methods to do this...

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.