Recent content by MarkK

:)

A faster way to get at your Outlook data is to use an Outlook.Table object, so you might have a function... Function GetItemTable(Folder As Outlook.Folder, Optional FromDate As Date) As Outlook.Table If FromDate = 0 Then Set GetItemTable = Folder.GetTable Else Set...

Is one the opposite of the other? For instance, if Declined = Not Ordered in the same way that On = Not Off or False = Not True, then you don't need two fields. Also, if you bind an Integer field to a CheckBox control, you can set CheckBox.TripleState = True. In that case, the control cycles...

In common practice, you would not move this data to a temp table. Rather, you would save this SQL... ... to a query called "Bay_Sheet." For most purposes, consumers of the temp table "Bay_Sheet" will not distinguish a difference, and the GetBaySheets() method can be deleted. In almost all...

• This is why we must always cultivate in ourselves humility and respect for those with whom we disagree. It is always possible that in our own views we are the Germans, blind to countervailing evidence by the obvious--to us--superiority of our own understandings. • The Germans' fundamental...

• Return the leading comma in all cases, and always remove it... Mid(IIF(SpecialSS, ", SS", "") & IIF(SpecialDT, ", DT", "") & IIF(SpecialSGT, ", SGT", ""), 3) • Also, in boolean math the operation '= True' is called the Identity Function and it has no effect on the outcome. • False = True...

I would not embed this kind of business logic in the UI. Consider writing a service class, like cOrderService, and expose this logic as a public method. Then, in your UI, just do... Private svcOrder As New cOrderService This serves to... • Simplify the code in the UI, making it easier to...

To discover any and all tags used by rich text in MS Access, put a single TextBox on a form, and back it up with code like... Private Sub Text0_DblClick(Cancel As Integer) Me.Text0.TextFormat = Abs(Me.Text0.TextFormat - 1) ' toggle Me.Text0.BorderColor = Me.Text0.TextFormat * vbRed '...

You are performing business logic AND user interface logic in the same routine. Generally you should isolate both. The hazard of not isolating them are... • If you refactor SQL_Delete() or the refresh methods of the Form, this routine will break without warning. • If your system continues to...

I read your post. I know nothing about your problem, except that it involves links to pdf files. Cheers,

You could do... Const Q_NAMES As String = _ "OrphanAddCharges " & _ "OrphanDaily " & _ "OrphanAddChargesInter " & _ "DeletedHorseDetails " & _ "DeleteDupHorseID " & _ "DeleteNoHorseID " & _ "DeleteInvoice " & _...

Interesting observation. I certainly go to AI first these days...

Glad to hear it, thanks George. Looking forward to hacking this line of code... Private Const MAX_WIDTH = 22 * 1440 ...out of a bunch of forms.

Sorry, I meant extensibility, not scalability. Tight-coupling defeats extensibility.