MajP's latest activity
-
MajP replied to the thread Solved Access behaving badly..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... -
MajP replied to the thread Sub vs Function - who win?.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...
-
MajP replied to the thread Solved Linked Tbl (Decimal Type Col Not Displaying Decimal Places As Spec'd).According to Chat, what I guessed was wrong. It should display 15 digits. So no idea, but you could still try forcing the format.
-
MajP replied to the thread Solved Linked Tbl (Decimal Type Col Not Displaying Decimal Places As Spec'd).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...
-
MajP replied to the thread Sub vs Function - who win?.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...
-
MajP replied to the thread Sub vs Function - who win?.Somewhat unrelated but explains some quirks in Access. This took me years and years to understand. For example in an property if you...
-
MajP replied to the thread Sub vs Function - who win?.There is no performance difference, but provides clarity in your code. Function - I intend to return a value Sub - I am intending to do...
-
MajP replied to the thread Edit a pivoted query on a form.Here is an example of "editable" form based on a cross tab...
-
MajP replied to the thread Display Calendar.https://www.access-programmers.co.uk/forums/threads/date-pickers-calendar-controls-and-calendar-resources.315041/
-
MajP replied to the thread Solved List Box Sort.It does not need to get modified. It works with all lists.
-
MajP replied to the thread Solved List Box Sort.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...
-
MajP replied to the thread Solved List Box Sort.You may be interested in this class. It turns any listbox into a sorter. Has many features including drag and drop...