Recent content by MarkK

If your library contains a function that returns a reference to the form, then consumers of your library can manipulate that reference. From a public function in your library, you can return a public class that raises events. That class can open the form, handle that form's events, and then...

Lock him up.

There is every reason to store the commission on the date it is incurred. with the payment or transaction on which it is calculated. Any time a rate is subject to change, like tax or payroll or commission, the amounts calculated using today's rate should be stored in a record with today's date...

Isn't the commission an attribute of the payment? Like, if you already have a payment table that connects buyer and agent, wouldn't it work well to record the commission in a field of the payment table? It occurs on the same date as the payment. It should be linked to the same buyer and agent...

OffsetPolyline is neither declared, nor assigned a value in the code you posted, but you try to reference it's Coordinate() member.

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 the Auto Resize and Auto Center settings and save the form. Then open the form again in design view, and change those settings back. 2) There is an...

Hit <Ctrl> + S all the time.

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 method that returns a new cOrder instance. And say I want to run cCustomer.CreateOrder from the Library. In this case cCustomer can Implement IAction, which is...

You can define an interface in the Library, and then in the front end, implement that interface with custom functionality. In the library, create a class called IAction that exposes a single method Public Function Execute(Optional dcn as Scripting.Dictionary) as Variant. Now, in clients of...

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 of history tends towards justice. If you disagree, you are probably selling something.

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 I would return the FE to you for testing, with an incremented version number, and a description of the changes made under that version number. If you are...

The difficult and error-prone problem of cobbling together SQL statements in code is why DAO allows you to create and run a temporary QueryDef. Here's a code example... Private Const SQL_INSERT_SCORE As String = _ "INSERT INTO tblTestScores " & _ "( dtTestDate, numScore...

You can also do this... Function FieldExists(table As String, field As String) As Boolean On Error Resume Next FieldExists = CurrentDb.TableDefs(table).Fields(field).Name = field End Function I timed them both on a seven column table, looking for the last column in the table, and they are...

Look at this block of code... If Me.ckPrimaryDiag Then strVisibleColumns = strVisibleColumns & "PrimaryDiag, " If Me.ckSecondaryDiag Then strVisibleColumns = strVisibleColumns & "SecondaryDiag, " If Me.ckDateEntered Then strVisibleColumns = strVisibleColumns & "DateEntered, " If...

It may also be important to note in this discussion that the VBA TypeOf operator can distinguish if an object implements an interface. Say you have an Access.Form called Form_Form1 and it implements IKitayamaControls and INavBarHost, then the following code... Dim frm As New Form_Form1...