MarkK's latest activity
-
MarkK replied to the thread Recordset field not readable after update.When adding a row to recordset, grab the new ID after an edit, but before the update... Dim newRowID As Long With... -
Do your employees each work under a unique network login? If so, just grab that information and put it all in a table with various...
-
MarkK replied to the thread VBA class modules & factory design.A potential problem with not retaining data model instances--if you are going to create them at all--is that if your user/consumer code...
-
MarkK replied to the thread VBA class modules & factory design.I think you'd be more likely to use a factory pattern for composition, for instance, if you have a class that contains other classes...
-
MarkK replied to the thread Help with looping through records.If you use a With block... • you don't need a recordset variable Also, when you first open a recordset, if it... • contains no records...
-
MarkK replied to the thread Working with form records.The notes field is bound to the same RecordSource as that which drives the continuous form. If the record selected in the continuous...
-
MarkK replied to the thread Working with form records.Do you have code somewhere that adds that null record? If so, I would debug by setting a breakpoint in that code. Then cause the...
-
MarkK replied to the thread A great idea to fix our universities.If institutions are required to kiss government ass, individuals will be so required in due course. Vote your conscience on this man...
-
MarkK replied to the thread A great idea to fix our universities.Brilliant. Establish a Department of Truth, and only fund institutions that kiss government ass. Nice "Land of the Free" you got there...
-
MarkK replied to the thread Solved Changed relationships has stopped a form working.When you create an entity in a database you should add a single row to a single table. If you want to add a Contact, your SQL should be...
-
@Mister-B, if you want help on restructuring this and moving the data this group can help. You may think that is too much work, but you...
-
MarkK replied to the thread SQL Code in Access Report.If your report module supports class-global variables, these are not automatically reset between PrintPreview and Print. If, for...
-
MarkK replied to the thread A Function that returns a Recordset.I find this a hard problem. Like, I've committed to a pattern, but it's not quite right, so making it work is painful and laborious. So...
-
MarkK replied to the thread Solved Treeview nodes error.Is that a real estate database?
-
MarkK replied to the thread A Function that returns a Recordset.I don't know much about how memory works, but my machine has 12GB of RAM. Task Manager says I've occupied 61%, so I've got 7.3GB of...
