MarkK's latest activity
-
MarkK replied to the thread Opening form move to upper left automatically.1) I have had unpredictable form sizes before, but not locations. I can solve size problems if I open the form in design view, change... -
MarkK replied to the thread Solved Code not save when at runtime.Hit <Ctrl> + S all the time.
-
Yes, I got in the habit of a Ctrl + S, before trying to run anything. :)
-
MarkK replied to the thread Library ACCDB Calls to Referencing Project Procedures?.Say I have a class created in the FE based on FE data and the Library know nothing about it, say a cCustomer class with a CreateOrder...
-
MarkK replied to the thread Library ACCDB Calls to Referencing Project Procedures?.You can define an interface in the Library, and then in the front end, implement that interface with custom functionality. In the...
-
MarkK replied to the thread Squatters have rights. Homeowner arrested.Is that all you have? Those stories are outrage-engine clickbait. In America you used to be able to buy and sell human beings. The arc...
-
MarkK replied to the thread Module Import or Export.If was your programmer, I would ask for the whole system, your FE and your BE. I would then make the requested changes to the FE. Then...
-
MarkK replied to the thread Inserting numeric values into a Table, using SQL : What's the correct VBA code to use in the VALUES part of the code ?.The difficult and error-prone problem of cobbling together SQL statements in code is why DAO allows you to create and run a temporary...
-
MarkK replied to the thread Object Invalid or No Longer Set Error.You can also do this... Function FieldExists(table As String, field As String) As Boolean On Error Resume Next FieldExists =...
-
MarkK replied to the thread Filtering from a multiselect listbox with other filters.Look at this block of code... If Me.ckPrimaryDiag Then strVisibleColumns = strVisibleColumns & "PrimaryDiag, " If...
-
MarkK replied to the thread List of methods of a class in intellisense - 2.It may also be important to note in this discussion that the VBA TypeOf operator can distinguish if an object implements an interface...
-
MarkK replied to the thread New line on IF Statement.You also don't have to compare a boolean to True or False in order to determine if it is True or False, since, as a boolean, it is...
-
MarkK replied to the thread Pay your bills.Yes. Understanding national defence spending policies of NATO member states? Just like gym dues. This is what I love about Trump and...
-
MarkK replied to the thread Verify a File Path.To solve this I would just create the path. If you can create it, it is valid. If you can create it, you can delete it.
-
MarkK replied to the thread Solved Low Date not seeing the previous year.You can also do... Function GetLeastDate(ParamArray dates()) As Date Dim var With...
