Recent content by MarkK

Because there was no antisemitism in, say, 1943? Antisemitism is a fixture in the world and in history. There is no "sweeping."

Democracy is the belief that if all voices are heard, and issues are debated openly and fairly, that the majority of people will make the best choice. In this regard, if you do not see your opponents, and those with whom you disagree, as being an essential part of what democracy requires...

He's not the only one.

The scope of my comment.

IMO, delimiter issues in SQL are more far more easily and robustly solved by using a parameterized DAO.QueryDef.

If you have one purpose, and two databases that distinguish contained data by year, you have a fundamental design problem.

What matters though is what the control renders as its Parent. I could make a CollectionA and put controls in it, but that doesn't make my CollectionA the Parent of the control.

Here's my stab at these problems. Both functions recursively crawl up the Control/Page/Tab/Form hierarchy using the Parent property, which all members expose. - The MainForm is the first object that doesn't have a Parent - The ParentForm is the first Access.Form we encounter above the object...

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.