Require Subject for Outlook eMails

This function will prompt for confirmation if you try to send an email with no Subject. Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)  Dim strSubject As String strSubject = Item.Subject If Len(strSubject) = 0 Then Prompt$ = “Subject is Empty. Are you sure you want to send the Mail?” If MsgBox(Prompt$, vbYesNo + […]

Word Doc “is reserved by”

The project that I am working on right now is using Microsoft SharePoint.  It has some convenient features, but I absolutely hate how it does change control for documents.  Maybe I just don’t know how to use it.  Anyway, a common problem we are having is documents are staying “Reserved By” people who have left […]

How to find the name of a DFF

If you have the name of the table you want the DFF for, you can use this query: select app.APPLICATION_NAME, dff.TITLE, dff.APPLICATION_TABLE_NAME from apps.FND_DESCRIPTIVE_FLEXS_VL dff,  apps.FND_APPLICATION_TL app where dff.APPLICATION_ID = app.APPLICATION_ID  and dff.APPLICATION_TABLE_NAME = ‘HZ_PARTIES’;