A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Set appOutlook = GetObject(, "Outlook.Application") Set nms = appOutlook.GetNamespace("MAPI") If SelectFolder = True Then Set fld = nms.PickFolder end if lngItemCount = fld.Items.Count For Each itm In fld.Items If itm.Class = 43 Then '43 is the constant olMail Set Safeitm = CreateObject("Redemption.SafeMailItem") Safeitm.Item = itm For Each att In Safeitm.Attachments att.SaveAsFile strFilename Set stm = New ADODB.Stream With stm .Type = adTypeBinary .Open .LoadFromFile strFilename End With Next att 'THE BIT THAT OPENS THE WORD ATTACHMENT, EXTRACTS THE DATA AND CALLS THE STORED PROCEDURE end if If Me.chkDeleteEmail True Then Safeitm.Delete Set Safeitm = Nothing next itm
|Adding new field to an existing database in access||3||27|
|Access - Rounding an average in a report||3||16|
|Access Creating a report using a date range||11||13|