MarkK's latest activity
-
MarkK replied to the thread Edited record vanishes from filtered recordset.You could put a "Retain Edits" checkbox on the main form, a Date/Time modified field in the RecordSource, and a filter clause sensitive... -
MarkK replied to the thread The Robot Revolution.The word sabotage originates from the early 1800's after the invention of the the jacquard loom, commonly considered to be the first...
-
MarkK replied to the thread DLAST FOR DATE SERIAL.I think there's also a distinction worth drawing between data storage and data presentation, input and output, which are the two tasks...
-
MarkK replied to the thread SQL problem.If you have a working query, there is no advantage to dump its results into a table. To any consuming process, the query itself is...
-
MarkK replied to the thread SQL problem.Agreed. No good reason to dump query results into a table. Just use the query directly.
-
The real question is why you need to store this info in a table (counted) when the SELECT query you use to populate it will always give...
-
MarkK replied to the thread Solved HELP WITH VBA ON SUBFORM.Two observations I have... • use a parameter query. It completely absolves you of having to delimit or format any parameters. • more...
-
MarkK replied to the thread SUBFORM CONTROLS....or... Private Property Get Buttons() As Access.CommandButton() Buttons = Array(Me.cmdFirst, Me.cmdPrev, Me.cmdNext, Me.cmdLast)...
-
MarkK replied to the thread Solved Should we make The_Doc_Man a Super Moderator?.Despite the lingering horror of post #7, I voted yes. Congrats @The_Doc_Man!!!
-
MarkK replied to the thread Closing Form Instances.I think so. • It's fire-and-forget, and simpler than maintaining an external reference list to manage lifetimes and instances. The...
-
MarkK reacted to The_Doc_Man's post in the thread Solved Should we make The_Doc_Man a Super Moderator? with
Like.
My thought is, "What is a Super Moderator; or, how is that different from an ordinary moderator?" -
MarkK replied to the thread Solved Should we make The_Doc_Man a Super Moderator?.Jon: Can you briefly describe what difference it makes? Thanks, Mark
-
MarkK replied to the thread Closing Form Instances.Maybe there's a misunderstanding. This is the only way I open non-default instances, and I never actually call the CloseMe method, I...
-
MarkK replied to the thread Closing Form Instances.You should also be able to create a non-default instance of a form that reference-counts itself to stay open, like... Private me_ As...
-
MarkK replied to the thread Inconsequential Query.Recently I've been querying data over http from SharePoint. Lists exposed on SharePoint are available via phone-based MS Power Apps for...